[SPAM?] [rt-users] Backup Procedure

[Drew Barnes]

It has been my experience that I can build a new box and resolve the 
dependencies with CPAN faster than I can spool from tape.  I keep ASCII 
backups from the first, fifteenth, and last day of each month, as well 
as the entire current and one previous months.  scp them off to one or 
more other servers, and good to go.

Less space to backup, and no tape spooling makes me happy.

DB

Kaplan, Andrew H. wrote:
> Hi Keith -- 
>
> I thought I would combine the best of both approaches in the following manner: 
> 		1. Cron job /etc/init.d/mysqld stop
> 		2. mysqldump --opt --add-drop-table --single-transaction
>
>                     -u <rt_user> -p <rt_password> - h <databasehost>
> rt3 > rt3-mysql-backup
> 		3. Backup of the filesystems on the RT server including the
> directory where the flat file from step 2 is sent.
> 		4. Cron job /etc/init.d/mysqld start
>
> Your thoughts?
>
>
> -----Original Message-----
> From: Keith Edmunds [mailto:keith at midnighthax.com] 
> Sent: Thursday, October 27, 2005 3:20 PM
> To: Kaplan, Andrew H.
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [SPAM?] [rt-users] Backup Procedure
>
> Kaplan, Andrew H. wrote:
>   
>> I know the mysqldump utility is an option to use when backing up the
>> database. My question is, should I use mysqldump in addition to the above
>> procedure or is what I am doing now sufficient? Thanks.
>>     
>
> Personally I would use mysqldump /instead/ of what you are doing now. 
> Many reasons, including the removal of the requirement to restore the 
> database to the exact same version, patchlevel, etc, of MySQL, and the 
> fact that if there are any kind of problems with the restore, mysqldump 
> gives you an ASCII file to rebuild the data from - much more flexible 
> than a binary file.
>
> Keith
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Buy your copy of our new book, RT Essentials, today! 
>
> Download a free sample chapter from http://rtbook.bestpractical.com
>   

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati