With regard to the instruction below: leave the checkboxes as they are if already selected or set if needed.
Using your web browser,
- Go to the PHPMyAdmin location of the server where the database you wish to export resides. For example:
http://www.example.com/phpmyadmin/for a remote database and
http://localhost/phpmyadmin/for a database hosted on your Apache2Triad installation. Select the name of the database you wish to export from the combo box on the left side of the page and you will be taken to that database's main operations page.
- Click the tab labeled "Export" and you will be taken to the Export database page.
- In the EXPORT group, select the check box:
- Select the check box marked "select all" to select all of the tables in the database for export.
- The radio button selected below should be "SQL".
- Within the OPTIONS group; under the STRUCTURE sub group,
- Select the check box next to "Structure"
- Select the check box labeled "add DROP TABLE"*
- Select the check box labeled "Add AUTO_INCREMENT value"
- Select the check box labeled "Enclose table and field names with backquotes"
- Select the check box marked "Complete inserts".
- Select the check box labeled "Use hexadecimal for binary fields" may be selected
- Select "INSERT" in the combo box labeled "Export type:"
Selecting "add DROP TABLE" means that if the copy of the database created is later imported to another Drupal installation, the tables in the imported copy will overwrite them if they exist in the target database. You should be careful to keep track of your databases, and make sure you only import and export the correct databases for your task!
Note if a radio button other than "None" is enabled in the group "compression". Uncompressed databases may be larger, but are sometimes easier to work with.
This document details that items that should be selected. If it is not in this document above, then it *should/can* be omitted.
Finally, it cannot be stressed enough how important it is to make a backup of both your server files and you database! DO NOT DELETE a database or files off a server unless you are 200% sure that everything works!
And the following is an example of why we frown on externally hosted images in documentation pages:
For our visual thinkers, here is a screenshot of the above :) http://www.johnvsc.com/files/phpMyAdmin-screenshot.jpg