To back up your MySQL database
The easiest way to backup a MySQL database is via the web-based program phpMyAdmin. Do you have a web package, your Provider easy access via the database administration of the program.
- You are now logged in to phpMyAdmin, appear on the left of your database and associated tables.
- In the menu bar of the main window, click on "Export".
- On the following page Adapted to enable the type of export "- Show all possible options".
- Below that you will see in a box at the tables of the database. You want to back up the entire database, you need to make here is nothing. You want to export only parts of the database, you can select the appropriate tables.
- In the output select "save output in file". The rest of the settings, you can accept the way you are.
- Click on the "OK" button will download the database from the Server to your computer.
DB backup with phpMyAdmin
In General, databases are quite extensive. For small amounts of data, you can also Excel as a database use.
