SQL options for DB Backups in phpMyAdmin 2.5.0

  • userx

    (@userx)


    21 years, 2 months ago

    Hello all –

    Which of these SQL Options should be checked for a proper database export/backup of WP in phpMyAdmin 2.5.0.?

    Structure
    Add ‘drop table’
    Enclose table and field names with backquotes
    Include column comments as inline SQL-comments
    Data
    Complete inserts
    Extended inserts

    My host’s SQL Options documentation link 404’s … great, eh? I’ve searched and cannot find anything relevant for WP exports and I don’t want to miss anything to only find out later – when it matters – that I backed up incorrectly.

    this tut: http://www.tamba2.org.uk/wordpress/backup/ doesn’t specifically tell me which boxes below should be ticked in phpMyAdmin 2.5.0.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Kafkaesqui

    (@kafkaesqui)

    21 years, 2 months ago

    Here’s all I check off for WP exporting, and it hasn’t failed me yet:

    Structure
    – Add AUTO_INCREMENT value

    Data
    – Use hexadecimal for binary fields

    phpMyAdmin version here is 2.6.0, so there may be variations from what you’re provided as options (but as you can see, few options are needed).

    Thread Starter userx

    (@userx)

    21 years, 2 months ago

    Does anyone have more specific info relevant to phpMyAdmin 2.5.0.’s SQL options as listed above?

    Kafkaesqui’s suggestions aren’t even listed in the tick boxes of phpMyAdmin 2.5.0.’s SQL options.

    Anyone familiar with 2.5.0’s SQL options and which should be selected for a proper backup up WP? I’m pretty new at this and have searched … and searched … to no avail.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQL options for DB Backups in phpMyAdmin 2.5.0’ is closed to new replies.