Backup Agents and Tools Raw: Using mysqlhotcopy

• If you're only using ISAM or MyISAM table types, mysqlhotcopy is recommended over dump. It's faster, simple, has smaller output, and yields "drag and drop" restores.

• Raw mysqlhotcopy Examples:

• Local backup of just the users table from the mydb1 DB: # mysqlhotcopy --allowold mydb1./users/ /root/mysql-backups/

• Local backup of whole mydb1 DB to /root/mysql-backups/ : # mysqlhotcopy --allowold --regexp=mydb1 /root/mysql-backups/

• Local backup of all DBs and keep old copy: # mysqlhotcopy --keepold --allowold --regexp=".*" /root/mysql-backups/

• Remote backup and DL of all DBs on dbserver.example.com: # ssh root@dbserver.example.com "mysqlhotcopy --allowold --regexp='.*' /root/mysql-backups/" && scp -rp root@dbserver.example.com:/root/mysql-backups/* /root/mysql-backups

Notes: