Binary logs are not active, and it is not possible to provide point-in-time recovery. In all cases, data restoration is limited to the previous night's updates. Data restoration services are performed on a case-by-case basis and are subject to review and approval by administrators. The Database Administration team will perform MySQL data restoration in extremely limited cases, such as data loss due to SQL injection or unforeseen corruption.

If you need to back up or restore your data for any purpose (development, transference from production to test, etc.), you should take advantage of the functionality and tools that MySQL Workbench offers (for example, mysqldump or Data Export and Import Wizard). These backups are retained for 14 days for service-wide disaster recovery purposes. MySQL for Sitehost uses the MySQL Enterprise Backup features on a nightly schedule.

Manually back up your MySQL for Sitehost schemas.

Detailed information on using the Backup section is available in our Backup article. You can use the Backup section of the hosting Control Panel to create a backup of all your MySQL databases. You can find step-by-step instructions on how to export a database through phpMyAdmin in our Exporting a database using phpMyAdmin article.Įxporting a database via the Backup section of the hosting Control Panel Click on that icon to see information about the exported MySQL dump file. Once the export is complete, an information ( ) icon will appear next to your database.

Click on the Export button next to the database you wish to export.

Select the MySQL version of your database from the MySQL version drop-down menu.

If you wish to export your database via the MySQL Databases section of the hosting Control Panel, follow these steps:

via the Backup section of the hosting Control PanelĮxporting a database via the MySQL Databases section of the hosting Control Panel.via the MySQL databases section of the hosting Control Panel.Here are the three easiest ways to export the SQL dump/schema file of a database:

Download phpmyadmin mysqldump