MySQL #1064 error while importing backup
-
I know that this kind of problem is not new, but there isn`t any sollution that fits my problem exactly.
My Blog was formerly running on a 5.X MySQL server (I don`t know the exact version, probably newer than the version at my new host), the new server has 5.0.37.
The import of my database backup worked just fine, except from the most important table “wp_posts”. Creating the table itself worked, but none of the “insert into” commands is working for that tabel.
Here is an example:
INSERT INTOwp_posts`
VALUES ( 2, 1, ‘2007-01-06 17:17:47’, ‘2007-01-06 16:17:47’, ‘lorem ipsum lorem ipsum lorem ipsum’, ‘Über das Blog’, 0, ”, ‘publish’, ‘open’, ‘open’, ”, ‘about’, ”, ”, ‘2007-07-02 09:51:01’, ‘2007-07-02 07:51:01’, ”, 0, ”, 3, ‘page’, ”, 0, , ”, ” )`Everytime I try this command I get an error message like this:
`MySQL meldet: Dokumentation
#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 ‘ ”, ”)’ at line 5`If there is no easier way I`m willing to change these “Insert into” commands by hand (my blog hasn’t that much posts anyway), but to do that I need to know exactly what I need to change.
Thanks for sollutions and sorry for my bad english 🙂
The topic ‘MySQL #1064 error while importing backup’ is closed to new replies.