[Resolved] Restoring Database: SQL Syntax Error
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 ‘[Resolved] Restoring Database: SQL Syntax Error’ is closed to new replies.