phpMyAdmin – question about what to tick

  • snowman247

    (@snowman247)


    15 years, 4 months ago

    I am trying to learn how to back up my blogs.

    There seems to be a contradiction between the advice on different parts of the codex about what to tick on the Data section of the phpMyAdmin interface. The advice given here ……

    http://codex.wordpress.org/WordPress_Backups
    (Right at the end)

    is different to the advice here……….

    http://codex.wordpress.org/Backing_Up_Your_Database
    (7. The DATA section)

    In brief, the question is do you tick “Complete inserts” and “Use hexadecimal for binary fields”? Which if any should be ticked? Do you tick different ones depending if you are ticking tables or databases?

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • scribu

    (@scribu)

    15 years, 4 months ago

    I have no ideea. I just use the WP DB Backup plugin. Also, when I manually backup a wp datababase, I just leave the boxes the way they are (no ticking or unticking) and it works fine.

    Saurus

    (@saurus)

    15 years, 4 months ago

    There is no contradiction – the graphics shown in “backing up your database” are quite explicit. You check what the graphics show to check, and don’t change any others. Works just fine.

    Thread Starter snowman247

    (@snowman247)

    15 years, 4 months ago

    Saurus, I don’t understand what you are saying – there is a contradiction.

    Backing_Up_Your_Database says “7. The DATA section . Leave the boxes inside this section unticked…….” while WordPress_Backups clearly tells you to “3. Check the “Complete inserts” box” The image that accompanies the text also has “Use hexidecimal…..” ticked as well.

    Are you saying just do what it says in “backing up your database” and ignore the other?

    figaro

    (@figaro)

    15 years, 4 months ago

    Follow the steps here:

    http://codex.wordpress.org/Backing_Up_Your_Database

    Don’t worry about steps 6 and 7…just leave those settings to default.

    That’ll produce a good sql download for you. You can open it in a text editor like EditPlus to see that everything is there–and change anything if you like.

    mrmist

    (@mrmist)

    15 years, 4 months ago

    Yes, it’s annoying and the doc needs tweaking. But at the end of the day I don’t think it matters much.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘phpMyAdmin – question about what to tick’ is closed to new replies.