vBulletin

Hello. On vBulletin. What would you guys recommend to use to automatically backup a database everyday? I need something that is risk free, and something that is easy to install/set up.

Whats your opinions?

Thanks,
BlueEew.

 

i use "MySqlDump database backup script" for my forums.

free from http://www.scripts.oldguy.us/mysqldump/

 

Thanks for that. Before I choose which one I will go with I will see what everyone else as to say.

 

I use the mod by Ken at vbhackers that creates a backup once a night

 

Thanks. I didn't even know that something like that exists.

 

is there one that emails me sql database as an attachment? I know this is possible in joomla so asking here also....

 

Thank you for the link of this script. I will try this.

 

For free, just create a cron job to do this:

mysqldump --opt -Q -u dbusername --password=dbpassword dbname > /home/dbbackuplocation/monday.sql

So you create 7 of those, but you change it from monday.sql to sunday.sql for example.

Change dbusername, dbpassword and dbname to the right details aswell.

For example, here is mine:

Those commands will dump the whole database into the files. Make sure you create a folder for the backups to go to and CHMOD the folder to 0777.

Everyone monday a dump will be created and overwrite last mondays dump, so you will have a week of db dumps.

 

http://www.maratz.com/blog/archives...base-backup-to-your-mailbox-with-backup2mail/


I use google. Try it.

 

A daily automatic backup would be something very wise to do. Personally, I try to backup every 3-4 days.

 

I have been looking for this one.

What one would you guys and gals suggest then. I need one daily, automatic, and that dosen't require much bandwidth.

 

I already posted the one I use, go t www.vbhackers.com and look for "Ken"'s profile.. You'll see the backup hack, it's very easy to do and will do everything you've asked for in this thread

cheers
-Brandon