Database Error When Restoring With Bigdump

[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

blow Reviewed by blow on 30th 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

[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.