Generating mysql dump

Question

When I dump a db from mysql, is there a way out by which I can remove the lines ENGINE=MyISAM AUTO_INCREMENT=528 ... , LOCK TABLES "controller_actions" WRITE; and UNLOCK TABLES; . Opening the db file and removing these lines would be extremely tedious as the database is such huge.

Any help is appreciated

Barmar · Accepted Answer · 2012-12-12 07:19:52Z

1

I'm not sure why you would want to remove the ENGINE and AUTO_INCREMENT options; as far as I can tell there's no way to remove just these options. If you want to remove the entire CREATE TABLE statement, use the --no-create-info option. To prevent the LOCK TABLE and UNLOCK TABLE commands, use --skip-add-locks.

answered Dec 12, 2012 at 7:19

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Generating mysql dump

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related