Exporting tables in phpmyadmin (auto_increment not working)

[danmurf]

I was wondering if anyone else gets an ache from exporting database tables in phpmyadmin, mainly with auto_increment?

I'm running Drupal, and I develop this locally on my machine. My local setup is running mysql5 and the live server is mysql4, so when I export I use mysql4 compatibility mode. Also, the box 'Add AUTO_INCREMENT value' is selected by default.

When I import on the live server, my tables are all set up fine, apart from there's a '0' in default value, and auto_increment isn't set.

I've checked the exported SQL file and it does have auto_increment set when it creates the tables before the data is inserted. It also seems to export the auto_increment value. Does anyone know why it's not working?

Any ideas much appreciated!

 

[danmurf]

My local one is 2.8.1 (which came with xampp) and my live server is running 2.10.3 (which I downloaded today). I've just been checking tables against original ones and altering the tables on the live site - everything's running sweet so far. I haven't checked on the mysql forums, I'm guessing it's more of a phpmyadmin issue - just wasn't sure where to start looking. Thanks for the advice

 

[danmurf]

It's all been running peachy since I installed the latest version of phpmyadmin on my local server and exporting to the same version on my live server, so I guess it was a phpmyadmin issue all along. Thanks for your help