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:[email protected]] > Sent: 12 November 2009 15:11 > To: [email protected] > 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 [email protected] List: https://lists.sourceforge.net/lists/listinfo/backuppc-users Wiki: http://backuppc.wiki.sourceforge.net Project: http://backuppc.sourceforge.net/
