Support » Fixing WordPress » How to backup via PhpMyAdmin?

Viewing 8 replies - 1 through 8 (of 8 total)
  • 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.

    Thanks, I am also using it…

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

    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.

    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?

    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?

    can anybody help?

    Hi utnalove,

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

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

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘How to backup via PhpMyAdmin?’ is closed to new replies.