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?

 

[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? :P 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

 

[madaboutlinux]

You can upload the .sql file anywhere on the server but make sure you specify the complete path to the .sql file. You have to use the complete .sql filename.

For example, if your .sql file name is 'hhd_forum_mysql-ddforum.sql' and you uploaded the file say under, /home/rorum/ directory, your command will be:

mysql -uhhd_ddforum -p hhd_ddforum < /home/rorum/hhd_forum_mysql-ddforum.sql

 

[blow]

Ok so just to clarify before i try, this is my info:

database name: hhd_ddforum
User name: hhd_ddforum
Sql file name: mysql-ddforum.sql
Sql file path: /home/hhd/hiphopdownloadz.com/mysql-ddforum.sql

Is this right?

mysql -u hhd_ddforum -p hhd_ddforum < /home/hhd/hiphopdownloadz.com/mysql-ddforum.sql

& is there a space between "u hhd_ddforum"

mysql -uhhd_ddforum -p hhd_ddforum < /home/hhd/hiphopdownloadz.com/mysql-ddforum.sql

 

[madaboutlinux]

The second command is correct i.e. the one without space between -u and the username.