Ms. Goober reporting in. I’m in the middle of changing webhosts. Downloaded all important files, backed up database according to the Codex instructions here. Made three backups, each in a different compression format, and tucked them safely into my hard drive.
Tried ftping my WP files into new host, didn’t work, so I installed WordPress with Fantastico. Worked fine, but then I needed to restore my database into it.
I tried to restore my backup database into the new database according to these Codex instructions.
When that failed no matter which compression format file I used (got the “SQL Syntax Error”), I turned to Podz’s instructions here. I dumped the tables and then tried to restore, but got the dang error again:
#1064 – You have an error in your SQL syntax.Â Â Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘cat_ID
bigint(20) NOT NULL auto_increment,cat_name` varcha
I found this thread, but the error message appears to be a little different from mine.
So here I sit with dumped tables, hoping somebody can set me straight. Please tell me what I need to do. And don’t use big words.
- The topic ‘Restoring Database: SQL Syntax Error’ is closed to new replies.