question on backing up wordpress blogs
- Thread starter KeyzDT
- Start date
mseostrategy
BANNED
- Joined
- Oct 2, 2012
- Messages
- 1,368
- Reaction score
- 299
when you download SQL.GZ check proper download actual from original file.
bluemonster
Junior Member
- Joined
- Jun 13, 2011
- Messages
- 106
- Reaction score
- 13
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
Sent from my Nexus 7 using Tapatalk 2
innozemec
Elite Member
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.
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.
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.