Home  |  Helpdesk  |  Technical Library  |  Demon Web Hosting  |  Backup MySQL data

Backup MySQL data

How to backup MySQL data

If your website uses a MySQL ® database, you must back up its data by exporting it on to your local computer. These instructions describe how to export MySQL data from the following Demon shared hosting products: -

• Demon Web Hosting Professional
• Demon Web Hosting Advanced
• Demon Web Hosting Standard

If your MySQL database is bigger than 1 MB please read the “Backing up large Databases” section at the bottom of this page.

----------------------------------------------------------------------------------

Log in to your control panel at https://admin.dwh.demon.net

Click on the 'My Database' section

Login to the PHPMyAdmin tool

Click on the name of the database at the top left corner of the page

Click on the 'Export' tab

Click 'Select ALL'

Make sure the option for 'SQL' is selected

Make sure the option for 'Structure' is ticked

Make sure the option for 'Add AUTO _INCREMENT value' is ticked

Make sure the option for 'Enclose table and field names with backquotes' is ticked ( The selection for comments is optional )

Make sure the option for 'Data' is ticked

Export type should be 'INSERT'

Tick the box for 'Add drop table'

Tick the box for 'save as file' You can optionally give the file a name (e.g. yourdomain-DAY-MONTH-YEAR)

Click 'GO'

Select a location on the hard disk of your computer to save the MySQL dump file.

NOTE: Should you need to restore from this back up, please follow the instructions here.

----------------------------------------------------------------------------------

Backing up large Databases

If the MySQL dump file is larger than 4 MB then it will need to be divided up into smaller files to enable you to restore the database from your local computer in the future. If the MySQL dump file is larger than 1 MB then it may produce a time out error on the web page. Customers that have very large databases are advised to backup their database in smaller sections. This can be done by not selecting all tables at the same time. You can select individual tables to backup and then give your backup file and name which describes which tables you are exporting e.g. yourdomain-DAY-MONTH-YEAR-table1-table2-table3

 

MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries.