MysqlDump - no increment

Question

is there any option to dump without auto_increment. Keep the table structure with auto_increment 0

I use

mysqldump -u username -p dbname > db_dump.sql

CREATE TABLE `acesso_sistema` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip_acesso` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `id_usuario_acesso` int(11) NOT NULL,
  `unidade` varchar(30) CHARACTER SET latin1 NOT NULL,
  `operadora` varchar(35) COLLATE latin1_general_ci NOT NULL,
  `host_by_addr` varchar(35) COLLATE latin1_general_ci NOT NULL,
  `id_usuario` int(11) NOT NULL,
  `data_now` datetime NOT NULL,
  `ip` varchar(15) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

score 0 · Answer 1 · edited May 23 '17 at 11:52

0

This is probably best answered by reference to another question:

mysqldump - Export structure only without autoincrement

edited May 23 '17 at 11:52

Community

1
1

answered Oct 13 '15 at 15:06

Chris Lear

6,592
1
18
26

If it's a dupe it should be tagged as such. If it isn't you should include the relevant information in your answer. – Álvaro González Oct 13 '15 at 15:18
I'm not sure I'm able to tag it as a duplicate. So I did what I thought was the next best thing. – Chris Lear Oct 13 '15 at 15:31

MysqlDump - no increment

1 Answers1