[BNM] MySQL auto data export

[Tom Hume]

mysqldump also locks some tables by default whilst dumping. There is  
an --option to stop this though.

A client of ours had a nasty surprise when this led to deadlocks at  
3am one morning...

There are tools out there which purport to do hot backups of MySQL  
databases too, but I've not had any direct experience of em.

On 3 Apr 2006, at 10:42, Pete Dowdell wrote:

> Yes, mysqldump is probably the best way to take a back up.  It  
> should be
> installed as part of a normal MySql installation.
>
> Create a batch file with the mysqldump parameters required
> ie: mysqldump -u user -p pass -h hostname databasename > dumpname (see
> documentation!)
>
> Run as a scheduled task.
>
> Should be straightforward.  The obvious disadvantage of this  
> approach is
> that you will have to put a plaintext password in the batch file for
> unattended operation, so it's probably best to create a backup user on
> the database with read-only permission.

--
Future Platforms Ltd
e: Tom.Hume at futureplatforms.com
t: +44 (0) 870 0055924
m: +44 (0) 7971 781422
company: www.futureplatforms.com
personal: tomhume.org