I do a backup of my wordpress blogs every week in the form of an SQL.GZ file now I'm hearing these get corrupted easily??? is there a better way to do a FULL backup of a WP blog?
Do you have a large dB our small one? If small dB you can use plugins and send them to dropbox out FWD to email. Sent from my Nexus 7 using Tapatalk 2
where you heard the GZ files get corrupted easily? a GZ file is simply compressed text file with your db data....
No it's fine, how do you do it, from shell? Most important thing I would say beyond anything else is test your backups - once a month, just extract the files / db to test the zip is intact, and one every 6 months do a full test restore. I once had an issue where I had been backing a site up for ages, then when I needed a restore, I tried, only to find the files had been uploaded as ASCII instead of binary and they were all corrupt and unusable! Also, it's good idea to make a script and keep 5 or 10 revisions, that's what I do now.
Try going into cpanel and then backing up WP that way, it's very easy this way. It will backup all your files and databases.
I see some issues with 7zip and .gz files but usually if I open them through the 7zip software and not by double clicking I am able to retrieve the content (on Windows 7). Also BackWPup has the ability to post backups to dropbox: http://wordpress.org/extend/plugins/backwpup/. pretty cool.
man I feel like a dumbass. been using cpanel for years did not know you could do a full backup of ALL your sites in one shot hahah.
Don't feel too dumb mate. If you've a lot of sites these backups can reach 1gb+ and oftentimes they corrupt as well. But it is nice to have them on hand and they've saved my ass a handful of times too in tight spots.
At that point I would recommend doing clean up and making sure revisions is minimal. If there is a lot of legit content and his db is getting this big, mysqldump all the way. Split those files or do offsite backup.
