S
S
Sergey Petrikov2013-08-07 09:36:37
MySQL
Sergey Petrikov, 2013-08-07 09:36:37

How to store auto-increment value in database dump via mysqldump?

There is a site engine with a huge number of auto-increment values ​​in the database, respectively, after a simple mysqldump, restoring the dump resets all auto increment values ​​​​and nothing works, which key must be substituted into mysqldump so that it saves the increment values ​​\u200b\u200band makes the most complete backup of the required database ?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
kenny_opennix, 2013-08-07
@kenny_opennix

mysqldump -uroot -p db --opt 

D
Dmitry Pyatkov, 2013-08-07
@dkrnl

maybe the key is --skip-auto-increment?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question