Backup Process with phpMyAdmin

The screen shots here are from phpMyAdmin 2.9.2, which I have on my local computer. My web hosts have 2.9.0.2 and look very similar. They certainly produce exchangeable results.

1. Log into phpMyAdmin on your server.
2. Select the name of your databaseA collection of data related to an application. - or your Drupal

   Drupal

   An open-source content management system that is used on this site and is taking over the world. databaseA collection of data related to an application. if you have several databases.


3. The next screen will show you all the tables inside your Drupal

   Drupal

   An open-source content management system that is used on this site and is taking over the world. databaseA collection of data related to an application.. Ignore those, and click the "Export" tab on the top set of tabs.


4. Look at the left box at the top of the Export section. All the tables in the databaseA collection of data related to an application. you selected are in that box.
• If you have other programs that use the databaseA collection of data related to an application., then choose only those tables that correspond to your Drupal

  Drupal

  An open-source content management system that is used on this site and is taking over the world. installation.
• If you only have Drupal

  Drupal

  An open-source content management system that is used on this site and is taking over the world. installed, in the left column, click "Select All."
5. Ensure that the SQLStructured Query Language - a language for accessing a database. button is selected too.
6. In the Structure section tick the following boxes: Structure, "Add DROP TABLE," "Add AUTO_INCREMENT," and "Enclose table and field names with backquotes."
7. In the DATA section leave the boxes inside this section unticked, but make sure to keep the check box next to the "DATA" heading checked.
8. Tick the "Save as file" option, and leave the template name alone.
9. For now, select "None" for compression.
10. Now click "Go" and you should be prompted for a file to download. Save the file to your computer. Depending on the databaseA collection of data related to an application. size, this may take a few moments.

You have now backed up your databaseA collection of data related to an application.! (Not so bad, was it?)

Once that download is complete, you may check the "zipped" option, click "Go", and download the next file. If you want, you can download a backup in each of the compression formats. Your choice.