MySQL database migration


#1

I just exported my MySQL database from the old 000webhost account and now with my new account setup, tried to import my data to the new MySQL database, using PHPMyAdmin. But for one table, I keep getting #1064 syntax error for many of my data. The field has content of rich text, so it has many html tags and so on. Sometimes, it is something like "= " (a space after equal symbol) would cause the error. Sometimes it is a word of “select” which the server thinks to be illegal. I tried to import the same dataset to another MySQL server and everything went smoothly. It seems the problem is at the 000webhost’s end. Does anybody else I similar issues?


#2

Maybe try recreating the database and importing it again?