08-03-2006 01:31 PM
12-16-2009 09:03 AM
1. Shut down the MySQL server and make sure that it stops without errors.
2. Copy all InnoDB data files (ibdata files and .ibd files) into a safe place.
3. Copy all the .frm files for InnoDB tables to a safe place.
4. Copy all InnoDB log files (ib_logfile files) to a safe place.
5. Copy your my.cnf configuration file or files to a safe place.
In addition to making binary backups as just described, you should also regularly make dumps of your tables with mysqldump…
http://dev.mysql.com/doc/mysql-backup-excerpt/5.1/en/innodb-backup.html
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.