1. shell> mysqldump --tab=/path/to/some/dir --opt --full
OR
2. shell> mysqlhotcopy database /path/to/some/dir
OR 
3. simply copy all table files (`*.frm', `*.MYD', and `*.MYI' files)

Post By Editor (2,827 Posts)

Website: →

Connect