MySQL Forums
Forum List  »  Backup

Shutting down MySQL for backup
Posted by: Phil Williams
Date: August 16, 2005 11:33AM

The manual states:

If you are able to shut down your MySQL server, you can make a ``binary'' backup that consists of all files used by InnoDB to manage its tables. Use the following procedure:
Shut down your MySQL server and make sure that it shuts down without errors.
Copy all your data files into a safe place.
Copy all your InnoDB log files to a safe place.
Copy your `my.cnf' configuration file or files to a safe place.
Copy all the `.frm' files for your InnoDB tables to a safe place.

The queston is how can the check to make sure MySQL shut down without errors be automated?

Options: ReplyQuote

Written By
Shutting down MySQL for backup
August 16, 2005 11:33AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.