That's odd. If the column is set to auto_increment, a value of 0 in that field means "next value". Sounds like the table is not being created correctly.
FWIW, when using mysqldump I do
mysqldump --opt
never failed for me.
Sean
Aaron
· 3 years ago
Sean, it was supposed to be set to auto_increment. That's how the table structure is. But that is not how the dump came out. it was DEFAULT 0 instead. I've seen this happen on Plesk servers before. One of the reasons I'm tired of control panelled servers. Give me a plain jane box (or three) and set things up as they should.
Eric
· 3 years ago
Actually...
To be honest, I think something changed.
I've noticed if I use phpmyadmin on my local box (no contorl panel thankyou) and do an export, and change compat. mode to ANYTHING, i get auto_inc. stripped and default set to 0
All Comments
FWIW, when using mysqldump I do
mysqldump --opt
never failed for me.
Sean
To be honest, I think something changed.
I've noticed if I use phpmyadmin on my local box (no contorl panel thankyou) and do an export, and change compat. mode to ANYTHING, i get auto_inc. stripped and default set to 0
Try it out ;)