WordPress.org

Ready to get started?Download WordPress

Forums

phpMyAdmin v3.4.3.2 - Backing Up My Database (1 post)

  1. Gary_Petersen
    Member
    Posted 2 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic