question on backing up wordpress blogs

[KeyzDT]

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?

 

[mseostrategy]

when you download SQL.GZ check proper download actual from original file.

 

[bluemonster]

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

 

[innozemec]

where you heard the GZ files get corrupted easily? a GZ file is simply compressed text file with your db data....

 

[davids355]

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.

 

[webhost50]

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.

 

[adbox]

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.

 

[KeyzDT]

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.

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.

 

[adbox]

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.

 

[wykydtron]

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.