Database backup with mysqldump or mysqlhotcopy
You can backup your database by using mysqldump program or the mysqlhotcopy script. mysqldump is more general because it can back up all kinds of tables. mysqlhotcopy works only with some storage engines.
Create a full backup of your database:
shell> mysqldump –tab=/path/to/some/dir –opt db_name
Or:
shell> mysqlhotcopy db_name /path/to/some/dir
You can also create a binary backup simply by just copying all table files (*.frm, *.MYD, and *.MYI files), as long as the server isn’t updating anything. The mysqlhotcopy script uses this method.
Note:These methods do not work if your database contains InnoDB tables. InnoDB does not necessarily store table contents in database directories, and mysqlhotcopy works only for MyISAM and ISAM tables.
Social Bookmarking
