Joshua,
>I hope you can also use MySQL dump, in which case, you don't have to shut
>down, right?
yes, you can use mysqldump without shutting down. It did not come to my
mind that actually mysqldump is a kind of online backup mechanism :).
Since Innobase is multiversioned, you will get consistent snapshots of
your tables, and since the consistent read does not set any locks, your
users should be able to update the tables concurrently. Here I have
to check if mysqldump sets a full table read lock on the table you dump:
for Innobase that is not needed, but maybe MySQL currently does this because of
other table types.
Regards,
Heikki
>j----- k-----
> >2) Can you perform backups as with other tables?
>
> You have to shut down the database, make sure that it shuts down without
> errors, and then copy the Innobase data files to a safe place (it is
> safest also to copy the log files). Note that the .frm files only contain
> table definitions, not table data, which resides in the data files you
> specify in my.cnf. Currently there is no incremental backup nor on-line
> backup in Innobase.
--
Joshua Kugler
Associated Students of the University of Alaska Fairbanks
Information Services Director
[EMAIL PROTECTED]
907-474-7601
---------------------------------------------------------------------
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
