Secure backup of a MyISAM database: --lock-all-tables: : MyISAM « Engine « SQL / MySQL






  1. SQL / MySQL
  2. Engine
  3. MyISAM

Secure backup of a MyISAM database: --lock-all-tables:

     

> mysqldump -u root -p --lock-all-tables databasename > backup.sql








Related examples in the same category

1.MyISAM storage engine supports composite indexes that include an AUTO_INCREMENT column.
2.Change the Type of the Table (MyISAM, InnoDB)
3.Change it to the more efficient MyISAM type.
4.ENGINE = {BDB | MEMORY | ISAM | INNODB | MERGE | MYISAM}
5.MYISAM engine