1. No, it is much easier to backup (=export) all the tables at once.
2. Learn that URLs always should start with http//:
3. No signatures, please!
Your database is divided into various tables. So your posts go in one, your comments in another, options in yet another and so on. Backing them up means that you are saving the various portions of your database.
There should be an option that will allow you to save all the tables in one file, but saving them individually won’t hurt.
BTW, .gz files are like .zip files, it’s a different method of compression, that’s all. 7-zip is a free program that can read .gz files, if you’re curious as to what the database files look like.
OK – on my main phpMyadmin page I have an Export option. I selected jameswp, (my WP DB), checked “add DROP DATABASE”, and ” add DROP TABLE”.
I exported, saved and have a 27kb GZ file titled:
mysql1[1].gearhost.com.sql
Is that complete? I’ll check out 7-zip at home and check out the files to learn more.
screenshot is 4th pic at
http://www.jamesvandellen.com/index.php/backup-screenshots
Thanks both — I appreciate the help!
On the Codex page you linked in your first post there are very, very detailed instructions – with pictures.
Did you follow them in the proper order?
Like:
select the database
click Export
select/highlight the tables to be exported
check the indicated boxes
etc.
EDIT. Do you ever check the links you are posting here???
Corrected link – Thanks.
I am following the Codex guide to the letter, but just want to make sure the final output is correct, as I plan on doing it weekly.
Thanks again for the help.
Well, according to those images (snapshots) you are NOT following the instructions.
On the other hand: if you have WP 2.x you have a backup plugin.
Maerk – Thanks for the info on 7-ZIP. I’ve exported all my files, extracted in 7-zip, checked in Word and it contained all of my content.
That verification is exactly what I was looking for – I appreciate the help.
James…
