Error when restoring database backup

SuperMAG · 2008-07-16 00:34:47

hi, i just changed host and when tried to upload db, i got an error

Error

SQL query:

INSERT INTO `pbb_search_matches` (`post_id`, `word_id`, `subject_match`) VALUES (1306, 5335, 0), (1306, 3705, 0), (1306, 2951, 0), (1306, 6313, 0), (1306, 593, 0), (1306, 4005, 0), (1306, 3184, 0), (1306, 735, 0), (1306, 1163, 0), (1306, 406, 0), (1306, 7811, 0), (1306, 3598, 0), (1306, 5793, 0), (1306, 3876, 0), (1306, 1440, 0), (1306, 4907, 0), (1306, 5010, 0), (1306, 7816, 0), (1306, 449, 0), (1306, 912, 0), (1306, 404, 0), (1306, 492, 0), (1306, 867, 0), (1306, 6034, 0), (1306, 463, 0), (1306, 470, 0), (1306, 268, 0), (1306, 695, 0), (1306, 3176, 0), (1306, 4141, 0), (1306, 358, 0), (1306, 1319, 0), (1306, 4775, 0), (1306, 4064, 0), (1306, 7813, 0), (1306, 2044, 0), (1306, 4928, 0), (1306, 3189, 0), (1306, 9, 0), (1306, 349, 0), (1306, 4908, 0), (1306, 1, 0), (1306, 2933, 0), (1306, 4934, 0), (1306, 166, 0), (1306, 3315, 0), (1306, 1155, 0), (1306, 5334, 0), (1306, 3842, 0), (1306, 1807, 0), (1306, 4906, 0), (1306, 3197, 0), (1306, 5336, 0), (1306, 904, 0), (1306, 27, 0), (1306, 4[...]

MySQL said: Documentation
#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 181

can any one have quick solutions please the site is down for two days now.

thanks

Smartys · 2008-07-16 01:55:12

Modify your dump to remove the INSERT query for that table and then rebuild the search index when your forum is back up.

Smartys · 2008-07-16 01:55:46

I also just edited your title to make it actually reflect the issue

SuperMAG · 2008-07-16 03:00:03

Smartys wrote:

Modify your dump to remove the INSERT query for that table and then rebuild the search index when your forum is back up.

mmm how do i do that, i can provide the db if needed.

SuperMAG · 2008-07-16 17:03:20

any one

damaxxed · 2008-07-16 17:23:56

Oh common SuperMAG, you should be able to do some research on your own or are you 11 years old?

Remove the INSERT INTO `pbb_search_matches` from the dumpfile (backup)
Upload it / execute it
Rebuild the search index in the admin panel

SuperMAG · 2008-07-16 17:57:38

you mean i should open the backup file and search for pbb_search_matches line and delete it.

damaxxed · 2008-07-16 18:24:22

Yes

SuperMAG · 2008-07-16 23:37:51

ok its looks like that the whole db was corrupt so i uploaded an old one, so problem solved any way thanks

Forums

#1 2008-07-16 00:34:47

Error when restoring database backup

#2 2008-07-16 01:55:12

Re: Error when restoring database backup

#3 2008-07-16 01:55:46

Re: Error when restoring database backup

#4 2008-07-16 03:00:03

Re: Error when restoring database backup

#5 2008-07-16 17:03:20

Re: Error when restoring database backup

#6 2008-07-16 17:23:56

Re: Error when restoring database backup

#7 2008-07-16 17:57:38

Re: Error when restoring database backup

#8 2008-07-16 18:24:22

Re: Error when restoring database backup

#9 2008-07-16 23:37:51

Re: Error when restoring database backup

Board footer