|
- Login to PHPMyAdmin.
- 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"
- Within the OPTIONS group, under the DATA sub group:
- 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:"
- Below, select the check box labeled "Save as file" group,
- then type a name for the database and
- click the button labeled "Go".
- Select a location to save your database.
|
