How to restore my database

[souvikroy1111]

i have backed up my database before moving to the new host and after moving all database and files are deleted...how to restore...i am on shared hosting

souvikroy1111 Reviewed by souvikroy1111 on 28th Jul 2011. How to restore my database i have backed up my database before moving to the new host and after moving all database and files are deleted...how to restore...i am on shared hosting Rating: 5

[praveer]

Do you still have the files saved? I am asking for files and not database.

Otherwise just go to phpmyadmin and click import. Then choose the DB you wanna import and click import. It will be imported.

[souvikroy1111]

thanks...my files are also being deleted

[vps9Ryan]

If you have the .sql file ... you can import it via phpmyadmin or via ssh using the following command ;

mysql -u username -p dbname < backup.sql

change username, dbname and backup.sql respectively ofcourse.

Cheers,
Ryan

[praveer]

If files not there, then reinstall whatever you using. Whether forum or blog. For that its obvious that we need to create a DB. After installation is done, then import your previous DB on the one you just created. Edit the config file and change the DB name and username if they are not same.

Hope this helps and you import your DB successfully.

Thanks