Announcement

Collapse
No announcement yet.

Can someone walk me through the exact steps to auto-backup my dbase?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can someone walk me through the exact steps to auto-backup my dbase?

    I recently lost 2 months worth of posts/threads/users/etc on my site b/c I am not diligent in backing up my database. I have no clue how do mess with 'cron jobs', scripts, etc etc. I am good at following instructions though.

    I've done some searching about scripts that allow my database to be automatically backed up at my preferred frequency, and it will upload a dump file to my ftp (to my directory of choice) and email me confirmation. All of these things I've read though talk to the reader as if they are already familiar with cron, scripts, etc.

    Can someone walk me though this, step by step, either here (for others to get the benefit from) or via PM or email?

    I really don't want to lose 2 months of posts ever again but with everything else going on in life, it's a PITA to remember to login to ssh and do a dump.

    Thanks in advance for any help you all can provide.
    Fred Bingham
    http://PoMoFoRacing.com
    http://Htownracing.com

  • #2
    Consider using an add-on like this...

    http://www.vbulletin.org/forum/showthread.php?t=201319
    [URL="http://coolscifi.com"]Cool Sci-Fi[/URL="http://coolscifi.com"] | [URL="http://awalkerbit.me"]Walking Dead[/URL="awalkerbit.me"]

    Comment


    • #3
      Thanks for the reply. I've seen that one but prefer to do it outside of php.
      Fred Bingham
      http://PoMoFoRacing.com
      http://Htownracing.com

      Comment


      • #4
        How big is the database, and how big is the web space directory? Both of those questions affect how to approach an automated backup solution.

        Small database and small file system, you'll probably be fine just dumping the database and gzipping it up with the web space files. If the database is huge, you still don't have much choice other than mysqldump, then gzipping it, but it can seriously impact the performance of your board so it will need to be done during the dead zone (when the fewest people are on) for your site. If the web space is huge (lots of picture attachments, etc), gzipping the file system can take hours, so generally your best bet then is to rsync --size-only to offsite storage. The first one will take a long time, but after that only files that are new or have changed will be copied.

        Managing cron jobs is very simple. Do a google search on crontab and you'll find so much information on how to set up a cron job that you'll wonder why you ever scratched your head over how it's done.

        So, the steps are: evaluate your system, determine the strategy, write the shell script, set up the cron job to run the shell script daily. Go to bed every night and sleep well knowing that your data is safe. I have a variety of user configurable scripts already written to handle different backup scenarios, from small boards all the way up to entire servers, so if your situation isn't terribly unique, I'm sure I've got something that could work for you with little modification. PM me with an IM address (yahoo or msn) if you want to discuss this.
        Anybody who says "it can't be done" will usually be interrupted by somebody who is already doing it.

        Comment


        • #5
          Thanks for the reply! I can't IM from work so I'll pm you my email address if that's ok. My main site isn't huge (right now, the dbase is ~300MB). However, I've recently become an owner for another site that runs vb and it gets more traffic and has paying sponsors, etc. That db is only 500mb at the moment, but it will definitely grow.

          As far as space, I would have no problem with 10 backups of a 1gb file. I have 300gb space allowable for each site.

          Thanks!
          Fred Bingham
          http://PoMoFoRacing.com
          http://Htownracing.com

          Comment


          • #6
            Originally posted by bigwater View Post
            How big is the database, and how big is the web space directory? Both of those questions affect how to approach an automated backup solution.

            Small database and small file system, you'll probably be fine just dumping the database and gzipping it up with the web space files. If the database is huge, you still don't have much choice other than mysqldump, then gzipping it, but it can seriously impact the performance of your board so it will need to be done during the dead zone (when the fewest people are on) for your site. If the web space is huge (lots of picture attachments, etc), gzipping the file system can take hours, so generally your best bet then is to rsync --size-only to offsite storage. The first one will take a long time, but after that only files that are new or have changed will be copied.

            Managing cron jobs is very simple. Do a google search on crontab and you'll find so much information on how to set up a cron job that you'll wonder why you ever scratched your head over how it's done.

            So, the steps are: evaluate your system, determine the strategy, write the shell script, set up the cron job to run the shell script daily. Go to bed every night and sleep well knowing that your data is safe. I have a variety of user configurable scripts already written to handle different backup scenarios, from small boards all the way up to entire servers, so if your situation isn't terribly unique, I'm sure I've got something that could work for you with little modification. PM me with an IM address (yahoo or msn) if you want to discuss this.
            Could you help me with this situation. My site is small (right now ). But, I wish to have a backup routine in place and the cron jobs/scripts you have sound right up my alley.

            And, with your knowledge and providing me with instructions it'll be a quick turnaround because I'm a fast learner but just need to get my feet wet.

            Thanks and I anxiously await your reply. If it's a go I'll PM you my email addy. I don't have IM.

            Comment


            • #7
              Forget everything and use this. Extremely easy to setup and works great.
              http://www.vbulletin.com/forum/showt...290#post898290

              Do read the complete thread!

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X