Hi Christiann,
I’m getting the same problem when trying to import my backup into an empty database:
SQL query:
#
# Data contents of table wp_categories
#
INSERT INTO wp_categories
VALUES ( 1, ‘Uncategorized’, ‘uncategorized’, ‘, 0, 0, 0, 0, 0) ;
INSERT INTO wp_categories VALUES (2, ‘Unusual ‘, ‘unusual ‘, ‘, 0, 2, 0, 0, 0 ) ;
MySQL said:
#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 ‘Unusual’, ‘unusual’, ‘, 0, 2, 0, 0, 0)’ at line 1
I’m using Version 1.7 of database backup, phpMyAdmin 2.9.0 and WordPress 2.1.3. What software did you use to add the single quotes to your database backup and where are they placed?
I’m having the same problem, if it’s any consolation.