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
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?
Posted 1 year ago #
Hi utnalove,
Check out below URL on the part where you backup on the PHPmyAdmin
http://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 :/
This topic has been closed to new replies.
