On Thu, 6 Jan 2000 19:58:40 +0000 (GMT), hypnos wrote:
>I just broke down and run mysqladmin shutdown before
>backing up the files, then restarting it after I'm
>done. It takes less than 60 seconds to copies the
>databases I want to back up, and my server isn't
>"mission-critical" or anything, just used on my local
>network, so 1 minute of downtime about 6 a.m. isn't
>gonna affect me. :)
What would be really nice is a signal to send to the server with a
database_name (e.g. via mysqladmin) that would copy the files in the
database directory to a backup directory (e.g. database#bak where '#'
is a char not allowed in a db name), with the data appropriately
committed to file (file system cache is ok) and locked against
modification, followede by UNLOCK of the database.
This could be made very fast and simple and the backup dir could then
be backed up to whereever.
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)