mysqldump’s –skip-opt

Thursday, 14. 12. 2006  –  Category: all, sw

–skip-opt is a useful option to mysqldump – amongst other things it disables the extended INSERT syntax producing an INSERT per table row. That’s good for examing individual rows in the dump. However, it also disables –create-options. This flag prevents any MySQL-specific schema stuff appearing in the dump. Unfortunately (for me, during a live deploy) [...]