vbulletin sql database dump help

[tractor3231]

I have vbulletin website..It went down..
And when I go to cPanel>MSQL databases, there is no user and database there..(i dont know what happened)

However, i have sql_backup dumps on my directory:
Forum-2011-07-28-2-16-47-Full-Backup.sql

i have also backup from my hosting provider:
fasterf_username_forum.sql.gz

How can i restore this?
thanks!

tractor3231 Reviewed by tractor3231 on 27th Aug 2011. vbulletin sql database dump help I have vbulletin website..It went down.. And when I go to cPanel>MSQL databases, there is no user and database there..(i dont know what happened) However, i have sql_backup dumps on my directory: Forum-2011-07-28-2-16-47-Full-Backup.sql i have also backup from my hosting provider: fasterf_username_forum.sql.gz How can i restore this? Rating: 5

[ankeshhimesh]

go to your newly cpanel create database with any username and then go to myphp admin select that database and them second last tab import databse there upload that database wait for execution You Are Done..!

[tractor3231]

hmm, i thought phpmyadmin doesnt allow large database file..

[lehoangson]

You can use MySQLDumper to restore that database.
I think if you contact hosting provider, they will help you restore it.

[tractor3231]

how can i restore the database using shell commands?

[resoft11]

If you have shell access, so

mysql -uusername -ppassword database_name < /your/path/yourbackupdb.sql

U need to create a fresh database then import your old database.

[inject0r]

phpmyadmin allows large databases too, you just need to do some configurations and upload the files into a folder. http://www.webdevelopment2.com/impor...n-get-bigdump/


greets

[tractor3231]

If you have shell access, so

U need to create a fresh database then import your old database.

i used this using SSH. and the database has been imported on msql..
but the thing is the config.php does not connect with the database
(the DB, user, and pass are 100% correct)