>> On windows you could simply copy the entire data directory with a
>> Scheduled job. Copying the files should be all you need to do for
windows.
>> For a cleaner, and what most people would say is a better way you could
>> schedule a batch file to run mysqldump that would dump the data and
>> structure to a file.
>> mysqldump info can be found at:
>> http://www.mysql.com/doc/m/y/mysqldump.html
>
>I hope you're shutting down MySQL before you do this. If yuo're not, your
"backups" are probably worthless.
Shouldn't it be enough to lock the tables and FLUSH before doing the copy?
I want to keep read access while doing the backup, and let writes queue
(i.e. writers will find the database a bit soggy during backups, but read
work OK and INSERT DELAYED will just be delayed - I hope.
Alec
mysql, query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
