mysqldump For Backupmysqldump can be use for backup.
mysqldump --tab=/path/to/dir --opt db_name
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