Cannot restore Vbulletin forum database,

Hey guys, im trying to restore my old database, what i did do is backup everything had, im getting an error stating i can't edit the information schema table, now i know i can't edit this because it's the system of my mysql database, is there anyway to edit the .sql table to leave it out of it? i clicked the ignore errors button but it did nothing, i'd attach the .sql file but the file is 500mb's..

Not sure what details would be useful but i can post them.

So, you load an .sql file in HeidiSQL or what caused the errors?

If you load an .sql file to run it, be sure the right database is selected by click on it (see the green checkmark on it).

Yep loading the sql file into my new fresh database where ive made another forum on hoping it replaces new files with old files.

Now this error, Password doesn't need to be the same does it?

The first screenshot shows that your dump file contains structure and data from the system database "information_schema", which also has the green check mark in the tree on the left. This is most probably not what you wanted, so the dump is crap.

The other screens say there is more content, this time from the database called "forum". This is probably what you want. In the end you have a dump file with more than one database in it. You should go and make another dump, this time with only the "forum" or whatever database you want to backup.

I already lost the database, so i'm screwed huh.

Open the .sql file in some text editor and remove everything which does not refer to the database you want to restore. Save that to a new filename and try to run it in HeidiSQL.

I've tried and had nothing but errors, im very computer literate, consider me a xml php & developer but suck at sql databases, can you do it for me? just need the forum database, theres world etc don't need them :)

Well, I can see if I can do that for you when you put the compressed sql file to some host where I can download it. You can send the link to the email address displayed on the imprint page.

Thank you so much Ansgar, i've compressed it and has made it tonnes smaller, keep in touch with you in just a moment :)

All is good Ansgar i had 3 errors though and am unsure how to check them, also did you see a database under _users? user's and forum categorys didn't restore D:

Nevermind, Making new category's in vB make them appear