[HELP]MySQL-ERROR [Error In Query]

B

Ben10

New Member
Hello All

I have changed my Host Server to another server .I made Whole Backup of my forum .But after installation of my Vbulletin Forum when i try to restore my Forum Backup From mysqldumper it failed to restore back with this this error

Code: 
MySQL-ERROR
Error in Query

INSERT INTO attachment VALUES

Plz Help my soon to fix this error
I shell be very thank full to all of you ..
N Happy New Year :)
 
Sorry to say but this error looks like your export failed and didn't tell you. Try to edit the sql file and got to the end of it to see if it has a bunch of error messages instead of SQL code. If it does, I hope you have another backup or access to the old site to take another backup of your database. If its valid SQL and not error messages, try to use bigdump to import your database.

HTH
 
thanks for your kind reply mate but i don't no much about MySQL .the other this is i have no more access off my last database :( iss there any other way to fix it without attachment table how can i del attachment table from this back up ?
 
wow finally i fix it by Deleting all Attachment Tables .Thanku so much bluescorpion's i checked backup file n del all Error massages and now my forum is up but i lost the Attachments but others thing are ok :) i don't wory about attachments coz they were nat more then 20 Mb :)

again Thanks you both
 
You must log in or register to reply here.
Back
Top