phpMyAdmin v3.4.3.2 – Backing Up My Database
-
My web host updated the installation of phpMyAdmin that I use to manually back up my database this past week. If I’m interpreting the support article for backing up my database correctly, the settings I should select are these:
Export Method: Custom
Table(s): click Select All
Output: Select “Save output to a file”
Format: SQL
Format-Specific Options: Use the default settings (Select the checkbox for Display Comments and make sure the Structure and Data radio button is selected)
Object Creation Options: Select the checkbox for Add DROP TABLE / VIEW / PROCEDURE / FUNCTION statement. Deselect the checkbox for Add CREATE PROCEDURE / FUNCTION statement. Select the checkbox for CREATE TABLE options and select both checkboxes below it for IF NOT EXISTS and AUTO_INCREMENT.
Data Dump Options: Use the default settings (The checkboxes for INSERT DELAYED statements and INSERT IGNORE are not selected. The “both of the above” radio button is selected. Max Length of Created Query is 50000. The checkboxes for “Dump binary columns in hexadecimal notation” and “Dump TIMESTAMP columns in UTC” are both selected.
Do I have that right? Can I instead select the “Quick” export method option? Do I need to increase the Max Length of Created Query setting?
Can the support document be updated to reflect the new version of phpMyAdmin?
Thanks, Gary
- The topic ‘phpMyAdmin v3.4.3.2 – Backing Up My Database’ is closed to new replies.