Backing up database

How often do you do this? I was a mod at a vB board and it got hacked once. I am just scared of something happening when I start my own board.

Thanks in advance. This board looks great!

well you could run a cron job so it goes off every night around 2am. Usually pick a time slot where you dont have a lot of members on.

another way is: Maintenance > Database Backup, I do mines once a week. I believe my host backs up daily.

Ok sorry I am new to all this lol. What is a cron job?

It is used to schedule commands to be executed periodically, so pretty much an automated process to do various tasks.

I do a full backup about every 2 days, this insures I have everything I need incase something goes wrong or I break something.:p

Hello,

I use vB Database Backup Pro (Lite) (http://www.vbulletin.org/forum/showthread.php?t=126925) for my automated daily database backups.

-Raymond

Thanks guys! This helps.

Jenn, I second Ray's suggestion. You set it up once and forget it. And it puts and end to the "It's been THAT long since I did a back-up" shocker. It's one of the add-ons that I really appreciate, but sometimes don't even remember is actually there because it just quietly goes about doing its job.

Man, that backup mod is AWESOME1 Just installed it, tested it, and it worked! Whew!

:)

I'm gonna have to install that. I need to be alot more consistent with my backups.

Hello,

I use vB Database Backup Pro (Lite) (http://www.vbulletin.org/forum/showthread.php?t=126925) for my automated daily database backups.

-Raymond
How do you do a restore from that?

How do you do a restore from that?

Restoring method depends on your operating system, I believe. So the way I might restore, wouldn't necessarily be the way you would restore. Is your host server running Unix or Windows?

Running Unix.

I have the mod installed and it has been running for about a month, but I have no idea how to do a restore from it ;)

I am also currently using mysqldumper as it has a backup and restore function, but it's not automated so I have to do it manually :( so that only get's done about once a week....lol

[QUOTE=viper357;59118]I am also currently using mysqldumper as it has a backup and restore function, but it's not automated so I have to do it manually :( so that only get's done about MySQLDumper can be setup to also run from a cron, it was designed with this in mind. I have it setup this way.

Would you mind sharing how to set it up to run from a cron? I would be eternally grateful. I have had a look but I'm not too sure exactly how to do it.

If I follow these instructions will it work?

http://www.jaguarpc.com/forums/showthread.php?t=14590

I cant even back my site up using the database back up in Admin CP it always times out ect... i have to contact my host and have them drop me a copy on the root then i snag it and put it on my 160gb External Hard drive then delete the back up off the root

Ill look into this back up Mod ,

DM

I cant even back my site up using the database back up in Admin CP it always times out ect... i have to contact my host and have them drop me a copy on the root then i snag it and put it on my 160gb External Hard drive then delete the back up off the root

Ill look into this back up Mod ,

DM

that sounds like the mysql does not have access to create the file.

Create a directory called mysqlbackup or something, back up to there, and delete when done.

It's best if you can automatically have them created someplace outside your web files.

/
- /www
- /www/forums/
- /backups


-Raymond

It saves a portion of the back up but cannot complete before it goes into Max User Connections , Server Time Out Errors Ect.....

DM

ok, I'm 99% of the way there, but I am stuck on the Scheduled Task part in vb, here are the instructions given, how do I adapt them to run on vb?

Step Eleven. Scheduling the mySQLdumper Perl Cron Script

This is how you tell the JaguarPC system how to schedule your automated mySQLdumper backup.

Click on 'Backup'.

Click on 'Backup PERL'.

Under 'Configuration for Perl Cron', look for two lines...

Code:
Commandline in the Shell or for the Crontab:
perl /home/jmyaccnt/public_html/mysqldumper/msd_cron/crondump.pl config=mysqldumper.conf
where 'jmyaccnt' will be you JaguarPC account name.

Copy that Commandline.

Go into your JaguarPC Control Panel.

Under 'Tools', select 'Cron Jobs'.

Choose 'Standard'.

Enter the email address where the Cron Manager will send the cron output.

Paste the Commandline from your mySQLdumper installation in as the 'Command to run'.

Now set how regularly you want the cron job to run. On most of my JaguarPC accounts I usually set my backups to run once a day, somewhere between midnight and 4 a.m., my local time.

Note, the time you are specifying here is the time on the JaguarPC servers, which may not be your local time.

Click on 'Save Crontab'.

someone please help, I'm almost very excited :p

It's working perfectly via a URL, I just can't figure out how to get it to run in the Scheduled tasks of vb

could it be because mysqldumper is using a .pl file and not a .php file?

ok, I think I have figured it out, instead of running it through Scheduled tasks in vb, I am using the cronjobs function in cPanel. I have set it to run at 3am GMT, hopefully it will work.

Make sure you CHMOD the Perl (cron) script to 755.

Would that be crondump.pl ?

Yes, that's it.