Hi!
On Nov 16, Erik Price wrote:
> Until the next release is available, I must use the
> dreaded "kill -9" shell command to shut down the MySQL daemon, which
> may corrupt data in the database
It shouldn't if you'll execute FLUSH TABLES before.
Actually,
mysqladmin shutdown && sleep 60 && killall -9 mysqld
should be safe.
Prepend it with the "mysqladmin refresh && " and increase the delay,
if you're really paranoid.
> This raises another question -- will the original database accept this
> backup if it *has* been corrupted?
Yes.
> PPS: One final question, of which I think I already know the answer but
> request confirmation: if I do some database development with my binary
> install of mysql-3.23.43-apple-darwin1.3.7-powerpc (currently on my
> hard drive), will I be able to dump the data to a file, remove the
> MySQL installation entirely, compile mysql-3.23.44.tar.gz with a few
> extra ./configure options, and re-load the data from the backup?
Yes.
You may also just copy your databases in binary form, without dumping.
You may even install new version over the old one (but still backup your
database directories in case anything will go wrong).
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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
