• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

Recommended Providers

Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

Divi WordPress Theme
WPZOOM

Forum Membership

Forum Membership

Restore MySQL database via SSH

Started by Kailash, September 20, 2008, 10:21:13 AM

Kailash

It is quite possible that you may need to restore your MySQL database via SSH as sometime due to large database size, it is not possible to restore it from PHPMyAdmin. You can restore MySQL database via SSH, if the shell access is enabled for your account. After login vi SSH, shoot out the below command:

mysql -udbusername -pmysqluserpassword databasename < path of your backup file

If you have root access of the server then you can use the following command:

mysql -uroot -pmysqlrootpassword databasename < path of your backup file

Thanks and Regards,

Kailash