[BNM] MySQL auto data export

[Jason Bailey]

> Anyone know if there is a way in MySQL for windows to automatically
> export the data from a collection of databases ?

> I want to ensure that I have a copy each night of the databases, but it
> would seem that doing a straight copy of the database flat files isn't
> gonna be the best route.
>
This has probably already been answered but I'm reading via google groups. 
Is mysqldump any good for you?
<http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html>
It's in previous versions too. I run a cronjob which does a lynx view of a 
php page.  This has some code that writes my data somewhere. It's not the 
best way perhaps as you need WWW user rights which is a bit insecure.

Actually I don't do it anymore but the mysqldump bit is useful.

Jas