MYSQL Database Backup #

There are various ways to export your MySQL databases for safekeeping or transfer. The first method allows you to back up multiple databases via your StackCP control panel and the second on a ‘per database’ basis via phpMyAdmin.

Backup/Restore via StackCP #

The control panel provides an easy way to download all databases associated with your hosting package. To access this page:

1. Access the Backup/Restore page:
   • Log in to StackCP > Manage Hosting > [select package] > Backup/Restore.
2. Ensure Databases is Checked:
   • Under Backup Type, ensure Databases is checked.
3. Create Backup:
   • Click Create Backup. A backup task will then be queued by our system. Once finished, a download link will be provided; this usually takes 1-2 minutes, depending on the size of the database. You can then download a zip file containing all your MySQL databases.

As a CP CLOUD HOSTING Reseller, you’ll also have the ability to back up your website files and databases in bulk. Choose Back Up Web Hosting from the StackCP homepage and select the packages you wish to back up.

Backup via phpMyAdmin #

The phpMyAdmin management software lets you import and export your databases. Follow these steps:

1. Log in to Your Database via phpMyAdmin:
   • StackCP > Manage Hosting > [select package] > phpMyAdmin.
2. Select the Database:
   • Choose the database you want to back up from the list on the left-hand side.
3. Export the Database:
   • Click the Export tab at the top of your page.
   • Leave Quick selected under Export Method.
   • Select your desired format – we recommend SQL for most cases.
   • Click Go. Within a few seconds, a download should begin in your browser.

By following these steps, you can efficiently back up your MySQL databases within your StackCP control panel, ensuring your data is secure with CP CLOUD HOSTING.