On 22 Sep 2009, at 17:39, Andrei F wrote:
> 1) grab a dump of the master (server) database: mysqldump -u -p
> dbname >
> dbname.sql
This will usually work, but won't always as it doesn't guarantee that
the data is in a consistent state. This becomes more of a problem as
your database gets bigger and the dumps take longer (and thus
opportunities for inconsistency increase). Take a look at Xtrabackup
which doesn't suffer this problem and is very good for setting up new
slaves (or rebuilding broken ones), I wrote an article about it:
http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html
Marcus
--
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/
