MySql DB restore

[duncan320]

Hi

On the shared cPanel hosting if i wanted to restore a MySql DB is this something i can do or do support need to do it. If i can do it can someone please give me a example of how to do this.

Thanks.
Duncan

[Rock]

Originally Posted by duncan320

Hi

On the shared cPanel hosting if i wanted to restore a MySql DB is this something i can do or do support need to do it. If i can do it can someone please give me a example of how to do this.

Thanks.
Duncan

Hi Duncan,

You'd be able to restore the MySQL database backup from the PHPMyAdmin feature available in the cPanel control panel, if the .SQL file is less than 32MB in size (limitation in the web based MySQL DB admin tool) or you can use any 3rd party tool (MySQL Admin, Navicat for MySQL, MySQL Front, SQLYog, etc) to get this job done..

But if your DB.SQL file is quite large (500+ MB), then it needs to be restored by us (support) from the server directly through SSH (mysql -uxxxx -pxxxx db-name < /home/db-bak.sql). All you'd need to do is to ZIP the huge database backup file on your local machine & upload it to the server & ask our support technicians to get it restored into your database. The latter option would be much more preferable

Let us know if you have any more questions..

[duncan320]

Thanks, that worked, it was only small file.

[Rock]

Originally Posted by duncan320

Thanks, that worked, it was only small file.

You're welcome