vb.org Archive - Automated backups + Linux + rsync?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - Automated backups + Linux + rsync? (https://vborg.vbsupport.ru/showthread.php?t=191826)

kursed

09-25-2008 03:47 AM

Automated backups + Linux + rsync?

Can anyone here help me set up a cron job for doing a daily mysql dump of my forum's dbase and rsync for it at bqbackup.

I'm not too sure, if this is the forum to ask such questions at. But I'm looking forward to you folks helping me out.

Amenadiel

09-28-2008 04:30 PM

I have this dbbackup.sh in my /root folder which contains:

Code:



fecha=`date +%Y-%m-%d`



mkdir /var/.backupsql/bd-$fecha



rsync -a -p -o -g /var/lib/mysql/vb/ /var/.backupsql/bd-$fecha/.

and an entry in the crontab telling it to run daily at 4am

Code:

0 4 * * * /root/backup.sh > /dev/null

In my experience, mysqldump was slower than this procedure, and so far (almost a year now) I haven't had any complications with corrupted tables whatsoever.

Lynne

09-28-2008 04:43 PM

I use this mod - Automatic Database Back-up and throw the backups in a /dbbackups folder which is then rsynced to bqbackup. Every couple of days I go in and move the backups to another folder on my server (and delete some old ones).

Quarterbore

09-28-2008 04:52 PM

I do mine like this:

http://www.vbclassified.com/showthread.php?t=241

Perhaps I should be using rsinc instead of a full copy?

http://rsync.samba.org/

All times are GMT. The time now is 02:27 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01132 seconds Memory Usage 1,713KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: