Do you backup your Database Data or do you rely on your provider?

Discussion in 'Directories' started by shenron, Nov 30, 2006.

  1. SFOD_D223

    SFOD_D223 Peon

    Messages:
    4,512
    Likes Received:
    174
    Best Answers:
    0
    Trophy Points:
    0
    #21
    Remember the phrases "Grandmother" type of backup? I always that was a weird name to call a backup sequence. I say the larger the db the more often the backup should be performed...Never trust a third party.
     
    SFOD_D223, Dec 1, 2006 IP
  2. Obelia

    Obelia Notable Member

    Messages:
    2,083
    Likes Received:
    171
    Best Answers:
    0
    Trophy Points:
    210
    #22
    I always do my own backups. The host's backup should always be considered a last resort.
     
    Obelia, Dec 1, 2006 IP
  3. frankcow

    frankcow Well-Known Member

    Messages:
    4,859
    Likes Received:
    265
    Best Answers:
    0
    Trophy Points:
    180
    #23
    some DBs I backup twice daily

    others, I just go with the realtime data backups provided by the host
     
    frankcow, Dec 1, 2006 IP
  4. carl_in_florida

    carl_in_florida Active Member

    Messages:
    1,066
    Likes Received:
    63
    Best Answers:
    0
    Trophy Points:
    90
    #24
    On my WP blogs I set up a cron job to run a backup daily and email the file to a Gmail account that i use for nothing other than that.

    I started doing that after my host lost a server and their last backup was corrupt. They only had a 2 week old backup that was any good.
     
    carl_in_florida, Dec 1, 2006 IP
  5. ketan9

    ketan9 Active Member

    Messages:
    548
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    58
    #25
    Nope, this ain't good, what happens if server crashes, your host will charge you $$$ to recover the backup. So do your backup and save it to a place accessible by you so that you do not have to rely on others.. Just my 2 cents
     
    ketan9, Dec 1, 2006 IP
  6. shenron

    shenron Notable Member

    Messages:
    4,965
    Likes Received:
    374
    Best Answers:
    0
    Trophy Points:
    295
    #26
    Saving the database itself maybe enough in most cases (except sitewide links on static pages).
    A regular weekly backup maybe enough if you don't have many submissions, but if you do I wonder how you'll be able to rebuild 200 submissions lost from your paypal account!...
     
    shenron, Dec 2, 2006 IP
  7. donttrustthisposter

    donttrustthisposter Peon

    Messages:
    1,477
    Likes Received:
    91
    Best Answers:
    0
    Trophy Points:
    0
    #27
    Some of you guys are nuts. Simple cronjob

    
    * 0 * * * mysqldump -u database -h sqldatabaseaddress -ppassword example| gzip > /home/shared/yourdirectory.com/backupdirectory/FWD`date +\%Y\%m\%d`.sql
    
    Code (markup):
    daily backup by cronjob.
     
    donttrustthisposter, Dec 2, 2006 IP
  8. shenron

    shenron Notable Member

    Messages:
    4,965
    Likes Received:
    374
    Best Answers:
    0
    Trophy Points:
    295
    #28
    It's still on your server... I mean offline backups
     
    shenron, Dec 2, 2006 IP
  9. EveryQuery

    EveryQuery Well-Known Member

    Messages:
    2,039
    Likes Received:
    366
    Best Answers:
    0
    Trophy Points:
    180
    #29
    I keep receipts just in case. For example, I backup weekly. It is a good idea to save a week's worth of those "successful payment" receipts that phpLD also emails to you, with all the submission info on it. Then, if something bad happens, you have all the submissions you had received with owner name, category, description, etc.

    For free directories, there probably is no way to keep such records since their is no payment. If you had a crash or attack, you would probably lose your latest submissions with no way to get them back.
     
    EveryQuery, Dec 2, 2006 IP
  10. shenron

    shenron Notable Member

    Messages:
    4,965
    Likes Received:
    374
    Best Answers:
    0
    Trophy Points:
    295
    #30
    Exactly, the only way, or at least easier and safer way to keep track of everything (almost everything I'd say) is getting a Gmail account (because of it's size the reliability) and activate the function that forwards every submission to your inbox.
    Since you don't delete your Gmail you can always re-check and contact :rolleyes: everyone to submit again... :|
     
    shenron, Dec 2, 2006 IP
  11. pachecus

    pachecus Well-Known Member

    Messages:
    1,841
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    110
    #31
    I backup all my databases every week.
     
    pachecus, Dec 2, 2006 IP