Mysql Error - Error 1064 (42000) At Line 13332:

[Bobsuch]

Hi,



I'm getting the follow error when I try to restore a Mysql

ERROR 1064 (42000) at line 13332: 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 'INSERT INTO `ibf_member_extra` (`id`,`notes`,`links`,`bio`,`ta_size`,`photo_type' at line 591

How can I solve this?
I've got 5 backups, all of them with a difference of 1 day, and they're all giving the same error


Thanks!

[vivianeg]

remove the complete tables
ibf_member_extra
ibf_members
ibf_members_converge

after insert complete tables again, Whit the insert rows from you'r back up.

after that you should maybe rebuild and recount you'r stats in admin tools & settings

greetings

[Bobsuch]

remove the complete tables

ibf_member_extra

ibf_members

ibf_members_converge

after insert complete tables again, Whit the insert rows from you'r back up.

greetings

So I remove these tables from my backup:
ibf_member_extra
ibf_members
ibf_members_converge

Then I restore the database and restore the 3 tables afterwards/

[AndyF]

Topic moved to Server Management, Resources, Optimization :)

[RTM]

Did this work ?

Having identical issue going from MySQL 4 to 5 with an IPB 2.3.4 database...

Rob