Wjunction Nightly DB Backup

[Dj Mad]

So just wondering how can i set up a cron likes wjunctions where it takes a copy of the db and closes the forum,i know the basics of cron but not the db backup and closing of the forum?Any help would be much apprecatied.

 

[CammyD]

I'd also like to know. :d.

 

[leonight]

me too want to know

 

[Dj Mad]

Im surprised it hasnt been asked before or maybe it has.

 

[Palooo 2009]

It is a mod of vbulletin.

 

[Dj Mad]

It is a mod of vbulletin.

Can you point to the mod or a name?

 

[World Life]

Maybe this?

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

 

[Palooo 2009]

Here you go:

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

 

[Profit]

You can find this on vBulletin.org

 

[ushare]

Here you go:

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

Where do i access the backed up database??

 

[Dj Mad]

thank you for the replies.

 

[onel0ve]

why u need mod for that simple work if you have ssh access then its so easy to take backup if not use mysqldumper using this i can take big dump backup

 

[Dj Mad]

why u need mod for that simple work if you have ssh access then its so easy to take backup if not use mysqldumper using this i can take big dump backup

So it does it auto everynight.

 

[Sik]

So which one is it ?

This one ? http://www.vbulletin.org/forum/showthread.php?t=78486
Or this one ? http://www.vbulletin.org/forum/showthread.php?t=201319

 

[kicker-hp_27]

@Sik,

Its a LITE version ? http://www.vbulletin.org/forum/showthread.php?t=78486

better use this:
Pro version ? http://www.vbulletin.org/forum/showthread.php?t=201319

 

[Lock Down]

There is also no need to close the forum. You are just reading records.

Just use file manager to create a folder called storage under the /home/YOUR_Folder so it is not accessible to the public.

In cron choose run once a day and use this command line :

mysqldump -u YOUR_Username -pYOUR_Password YOUR_Databasename | gzip -9 > /home/YOUR_Folder/storage/YOUR_Databasename.sql.gz

 

[onel0ve]

So it does it auto everynight.

mysqldumper is an great program if u set an cron job for that work it will take backup based on cron job and it also can upload into your ftp server also auto its have sql splitter also :D

 

[Chutad]

Where do i access the backed up database??

your root server

 

[snowmanrene]

mysqldumper is an great program if u set an CORN job for that work it will take backup based on CORN job and it also can upload into your ftp server also auto its have sql splitter also :D

What's a corn job

 

[TLK]

^It's like handjob and blowjobs but here, the ladies use corn.