The two common methods of Backup in MySQL are the following:
shell> mysqldump –tab=/path/to/some/dir –opt db_name
shell> mysqlhotcopy db_name /path/to/some/dir
You can also create a binary backup simply by copying all table files (*.frm, *.MYD, and *.MYI files), as long as the server isn’t updating anything. The mysqlhotcopy script uses this method. (But note that these methods do not work if your database contains InnoDB tables. InnoDB does not store table contents in database directories, and mysqlhotcopy works only for MyISAM tables.) Stop mysqld if it is running, then start it with the –log-bin[=file_name] option. The binary log files provide you with the information you need to replicate changes to the database that are made subsequent to the point at which you executed mysqldump. For InnoDB tables, it is possible to perform an online backup that takes no locks on tables, mysqldump.