How to backup/restore your MySQL database

If you run a database driven website, it is important to backup your databases very frequently. You can generate a full back up to do this as well but sometimes it may not be unnecessary to backup everything, just to backup your databases.

To backup the databases please do the following:
1. Click Backups.
2. Under Download a MySQL Database Backup, click the name of the database.
3. Click Save As.
4. Select a destination for where you would like the back up to be locally saved.

If you have ever made a boo-boo with a database, you can always restore the database easily and quickly.

To restore a database, please do the following:
1. Click Backups.
2. Click the Browse button next to the option which says Restore a MySQL Database.
3. Select the sql file which you would like restored.
4. Click the open button and click the upload button.

This will now upload the sql file which you can see in the MySQL Databases section in cPanel. You can also make changes to it in PhpMyAdmin.

  • 0 Utenti hanno trovato utile questa risposta
Hai trovato utile questa risposta?

Articoli Correlati

Can I password protect directories?

  To password protect directory: Login into your cPanel and click on the Password...

Changing your cPanel style.

Login to cPanel and click Change Style. Click the radio button under the style you like....

Creating a URL redirect.

Login to cPanel and click the Redirects icon. Leave the setting as 301 redirect, as this is...

Custom error pages

To create a custom error page for your account, please login to cPanel and click Error Pages,...

Do you have a manual for our control panel?

Yes, a manual for cPanel is available. Go to http://www.cpanel.net/support/docs/index.htm to view...

Powered by WHMCompleteSolution