Hello,

Le 12/11/2009 16:28, James Wells a écrit :
> Depends how you want to restore things - we use it to just backup the 
> /var/lib/mysql directories , but this means you have to restore the whole 
> database at once to restore things (you can restore to another server and 
> just select the data you want, as required of course).
>   

Backup of files under mysql directory will not work if you use innodb
databases (at least)...

For such a backup, you will have to stop the database, do the file copy
and then restart ; or proceed mysqldump command.

Anyways, I'm not sure that simply copying files is really recommended,
even if it appears to work (it should only work 99 per cent of time ;) ).

Regards,
Johan

> James Wells
> Systems Administrator
>
> t:  +44 (0) 1904 780030
> w: www.webcertain.com
> WebCertain Group Limited - Company No. 06721395
> -----Original Message-----
> From: Timothy Murphy [mailto:gayleard AT eircom DOT net] 
> Sent: 12 November 2009 15:11
> To: backuppc-users AT lists.sourceforge DOT net
> Subject: [BackupPC-users] MySQL
>
> What is the best way to use BackupPC to backup a MySQL database?
>
>   


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/