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
vps9Ryan Reviewed by vps9Ryan on . 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