mysqldump and auto_increment

Hello all,
I am trying to backup mysql server by this command:
mysqldump -u root --password='password' -A > mysql.sql

However, the backup sql doesn't contain information about auto_increment variables. Could anyone tell me how to backup auto_increment variables via mysqldump?

Thanks in advance.
Pang

 

 

 

 

Top