Database Error When Restoring With Bigdump

[blow]

Im tring to restore my vbulleting forum on my new vps.
I've uploaded all the files, & imported the database with bigdump.
It said it has been completed sucessfully, but im getting this database error when i go to my site:

<!--
Database error in vBulletin :

Invalid SQL:

            SELECT *
            FROM datastore
            WHERE title IN ('options','bitfields','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','attachmentcache','cron','profilefield','loadcache','noticecache','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

MySQL Error   : Table 'ddforum.datastore' doesn't exist
Error Number  : 1146
Request Date  : Monday, August 29th 2011 @ 04:56:40 PM
Error Date    : Monday, August 29th 2011 @ 04:56:40 PM
Script        : http://www.hiphopdownloadz.com/
Referrer      : 
IP Address    : *********
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

Does anyone know how to fix it?

blow Reviewed by blow on 29th Aug 2011. Database Error When Restoring With Bigdump Im tring to restore my vbulleting forum on my new vps. I've uploaded all the files, & imported the database with bigdump. It said it has been completed sucessfully, but im getting this database error when i go to my site: <!-- Database error in vBulletin : Invalid SQL: SELECT * Rating: 5

[gfxguru]

try to repair the table datastore from phpmyadmin

[blow]

There is no table datastore. Can i just add a table & call it datastore?

[my123world]

Mate, Vb definitely has a table called "datastore" & bad news is u havent uploaded it!

[blow]

Thats weird, bigdump said it has been completed sucessfully.

Looking now theres 31 tables thats been added to the database, it stops at cronlog. I dont know how many i should have.

[my123world]

mate are u running vb or something else? VB Has 100+ Tables Definitely! U r missing many...

[blow]

Ok thanks mate for the info...

I'll have to try and import the sql file again.

Whats the best way to import it? its way to big for phpmyadmin, thats why i used biggdump.

[NewEraCracker]

you should use ssh to do the job.

If you are in a VPS:

mysql -u mysql_username -p database_name < database_backup.sql

If you are using shared, you have to ask your host to do that.

[Sp32]

If you don't have the tech savvy to do it via ssh try using mysqldumper, I found that to be a lot better than bigdump when I used to import via php. SSH is definitely the best way to import a file though because you can upload it as a .rar, extract it then import it.

[blow]

Ok so it would be like this:

mysql -u hhd_ddforum -p hhd_ddforum < mysql-ddforum.sql

The bit at the end is just the filename, have i got to put the database name_then filename. like this hhd_forum_mysql-ddforum.sql or is it ok above.

Shall i upload the sql file to the rorum root?

Thanks