Doc Summary
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 WebHostsOnline Web-Solutions 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: WebHostsOnline Web-Solutions > 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 (WebHostsOnline Web-Solutions > 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.
