How do I download or back up my MySQL Database?

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 Pixallus control panel and the second on a ‘per database’ basis via phpMyAdmin.

Backup/Restore

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

• Access the Backup/Restore page: Pixallus > Manage Hosting > [select package] > Backup/Restore
• Ensure Databases is checked under Backup Type
• 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.

phpMyAdmin

The phpMyAdmin management software lets you import and export your databases. 

• Login to your database via phpMyAdmin (Pixallus > Manage Hosting > [select package] > phpMyAdmin) 
• Choose the database you want to back up on the left-hand side
• 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.