How to backup via PhpMyAdmin?

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

https://howto.cnet.com/8301-11310_39-20078556-285/how-to-back-up-your-hosted-wordpress-site/

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