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

  • veenuisthebest
    replied
    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!

    Leave a comment:


  • Bob_R
    replied
    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.

    Leave a comment:


  • Blue91
    replied
    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!

    Leave a comment:


  • bigwater
    replied
    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.

    Leave a comment:


  • Blue91
    replied
    Thanks for the reply. I've seen that one but prefer to do it outside of php.

    Leave a comment:


  • KW802
    replied
    Consider using an add-on like this...

    http://www.vbulletin.org/forum/showthread.php?t=201319

    Leave a comment:


  • 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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X