1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

question on backing up wordpress blogs

Discussion in 'Blogging' started by KeyzDT, Mar 20, 2013.

  1. KeyzDT

    KeyzDT Power Member

    Joined:
    Aug 9, 2010
    Messages:
    756
    Likes Received:
    365
    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?
     
  2. mseostrategy

    mseostrategy BANNED BANNED

    Joined:
    Oct 2, 2012
    Messages:
    1,368
    Likes Received:
    296
    when you download SQL.GZ check proper download actual from original file.
     
  3. bluemonster

    bluemonster Junior Member

    Joined:
    Jun 13, 2011
    Messages:
    106
    Likes Received:
    13
    Location:
    Adent.io
    Home Page:
    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
     
  4. innozemec

    innozemec Jr. VIP Jr. VIP

    Joined:
    Aug 19, 2011
    Messages:
    5,289
    Likes Received:
    1,799
    Location:
    www.Indexification.com
    Home Page:
  5. davids355

    davids355 Jr. VIP Jr. VIP Premium Member

    Joined:
    Apr 25, 2011
    Messages:
    8,792
    Likes Received:
    6,329
    Home Page:
    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.
     
  6. webhost50

    webhost50 Newbie

    Joined:
    Aug 9, 2012
    Messages:
    40
    Likes Received:
    9
    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.
     
    • Thanks Thanks x 1
  7. adbox

    adbox Power Member

    Joined:
    May 1, 2009
    Messages:
    658
    Likes Received:
    107
    Home Page:
    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.
     
  8. KeyzDT

    KeyzDT Power Member

    Joined:
    Aug 9, 2010
    Messages:
    756
    Likes Received:
    365
    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.
     
  9. adbox

    adbox Power Member

    Joined:
    May 1, 2009
    Messages:
    658
    Likes Received:
    107
    Home Page:
    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.
     
    • Thanks Thanks x 1
  10. wykydtron

    wykydtron Newbie

    Joined:
    Sep 1, 2009
    Messages:
    40
    Likes Received:
    7
    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.