How to backup via PhpMyAdmin? (9 posts)

  1. utnalove
    Posted 5 years ago #

    Hello, since I have a different version oh PhpMyAdmin I cannot follow the tutorial on the wordpress codex.

    Please somebody help to choose what I have to select here in order to have a good backup that I can easily restore: http://img713.imageshack.us/img713/3014/screenjl.png

  2. flick
    Posted 5 years ago #

    Doesn't quite answer your question, but I use WP DB-Manager on all my sites to manage database backups and would highly recommend it.

  3. utnalove
    Posted 5 years ago #

    Thanks, I am also using it...

    but I would like to "be able" to use phpmyadmin as well :/

  4. flick
    Posted 5 years ago #

    That's fair enough :) The default settings seem alright from the screenshot, but I would probably use a compression setting (usually gzip?) if you have a large site as sometimes the files - as you probably know - can be massive.

    Then you can always test the download on a test database to see how well it works, as it would be a matter of uploading a test installation of WP and putting in the relevant details DB details of the test db.

  5. utnalove
    Posted 5 years ago #

    mm yes I can try... but let's say that it looks like it works fine, but then after some WP upgrade or sth else I find out that I saved it in a previously supported, but now no more supported format?

    Should I:
    -Enclose export in a transaction?
    -Disable foreign key checks?
    -Which statements to add?
    -Enclose tables and field names with backquotes?
    -Instead of INSERT statements, should I use something else?
    -Which function should I use when dumping data? INSERT?
    -Which syntax should I use when inserting data?
    -Which should be the max lenght of created query?
    -Dump binary columns in hexadecimal notation?
    -Dump Timestamps in UTC?

  6. flick
    Posted 5 years ago #

    Hmm... hopefully someone else can help you with the detail, since I'm not familiar with all the settings, but personally, I wouldn't worry about changing the default - they are there after all to help people make a standard SQL backup.

    Presumably you'll be making a regular backup each month (along with the automated backup by WP DB-Manager) so if you do find that a WordPress upgrade causes issues, I imagine that you could simply upload the files for the previous WP version, purge the database and restore your backup database again, given that the pre-upgrade setting did work?

  7. utnalove
    Posted 5 years ago #

    can anybody help?

  8. arrentan
    Posted 5 years ago #

    Hi utnalove,

    Check out below URL on the part where you backup on the PHPmyAdmin


  9. utnalove
    Posted 5 years ago #

    Thanks, I saw this link and many more... however my phpmyadmin had different option :/

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.