Use mysqldump For Backup

• mysqldump can be use for backup.

  mysqldump --tab=/path/to/dir --opt db_name

• Also mysqlhotcopy can be use for backup.

  mysqlhotcopy db_name /path/to/dir

  • mysqlhotcopy does not work with InnoDB because InnoDB does not store table contents in database directories.
  • mysqlhotcopy only works for MyISAM tables.

How do I make a backup of individual files?

---

---

© 2007 John Michael Pierobon

Notes