Archive for the tag 'backup'

 

 

May 08 2013

Mysql Stored Procedures Backup

Published by under Mysql

Be aware while backing up Mysql databases: triggers are included by default but NOT the stored procedures/functions. Do not forget to add the –routines switch when running a backup.   mysqldump -u user -p my_database –routines backup.sql   Check your backup scripts before running into a disaster recovery.

No responses yet

Dec 15 2012

Windows Remote Server/NAS Files Easy Sync

Published by under Backup,Windows

robocopy lets you copy but more interestingly synchronize data from a server (or a NAS) to another Windows server. It is provided with the Windows 2003 Server resource kit tools or natively in Windows 2008 Server.Synchronization takes little bandwidth and can be a good way to backup data over a slow network link. Here’s a DOS […]

No responses yet

Nov 10 2011

Delete Backup Exec B2D Files

Published by under Backup

Here’s a script that deletes all the Backup Exec B2D files part of a media set. Stick the following script into a .bat file and edit the first 3 settings Mediaset, B2Dfolder and BEPath.You can run it straight. I consider it is good practice to do for the following reasons:– You can of course set the […]

5 responses so far

Aug 12 2010

Backup a Directory when Modified

Published by under Linux

I use this script to keep a full local backup of my tftp directory on Linux. It keeps the archive only if some of the files were modified. It can be used for any directory indeed. There are the files produced:   [root@tftp_server backup]$ ls -l -rw-r—– 1 tftp tftp 124200 May 1 04:04 tftp-20100501.tgz […]

No responses yet

Jul 26 2008

Mysql Ultra-Fast Backup with LVM

Published by under Mysql

It is generally good practice to respect the two following points when backing up databases. The backup has to be: consistent fast Consistency is easily achieved putting a read lock on all tables beforehands. However, this isn’t always applied, and WILL definately lead to a database integrity problem at some stage. Once a lock has […]

No responses yet