Pogledaj ovde:
http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
Evo, da imas:
Alternativno, probaj :
--opt
(imas na istom manualu)
http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
Evo, da imas:
Code:
--disable-keys, -K
For each table, surround the INSERT statements with /*!40000 ALTER TABLE tbl_name DISABLE KEYS */; and /*!40000 ALTER TABLE tbl_name ENABLE KEYS */; statements. This makes loading the dump file faster because the indexes are created after all rows are inserted. This option is effective only for nonunique indexes of MyISAM tables.
--disable-keys, -K
For each table, surround the INSERT statements with /*!40000 ALTER TABLE tbl_name DISABLE KEYS */; and /*!40000 ALTER TABLE tbl_name ENABLE KEYS */; statements. This makes loading the dump file faster because the indexes are created after all rows are inserted. This option is effective only for nonunique indexes of MyISAM tables.
Alternativno, probaj :
--opt
(imas na istom manualu)
Potpis
Please do not feed the Trolls!
Blasphemy? How can I blaspheme? I'm a god!'
Blasphemy? How can I blaspheme? I'm a god!'