SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I know the decision depends on the nature of the data.
    However, for example with SP, how often a backup of DB is generated?
    Since say everyday there is a backup, what about new users sign up at SPF on that day?
    Anyway, any suggestion would be great.
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  2. #2
    SitePoint Guru prequel's Avatar
    Join Date
    Nov 1999
    Location
    Brisbane, Australia
    Posts
    682
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    for me i use to backup my vB's database 3 times a day, but now i do that once in the morning and once at night.

    check this thread for a dump script for vB (i don't use it)
    http://vbulletin.com/forum/showthread.php?threadid=4256


  3. #3
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    But new threads/posts/signups after backup time will not be included in the backup?

    And if the system crashes (for whatever reason!), how would you deal with that?

    Thanks
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  4. #4
    SitePoint Wizard
    Join Date
    Apr 2000
    Posts
    1,483
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No anything that happens after backup time wouldn't be included, but as long as you back up frequently that shouldn't be more than a few hours worth of data.
    You could use some of the command-line mySQL programs to actually restore the backup - you could also use phpMyAdmin.
    At eDevBoards I've been backing it up once a day, but I'm gonna get that program prequel mentioned running now and do it automatically. Thanks for the link prequel

  5. #5
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, actually I use crontab to do it for me! How could I stay night by night doing the backup!!!

    Say for an active site like SPF, in such situation, the new user that signs up just after the backup and before the crash probably has to register + post again?!
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •