Exporting tables in phpmyadmin (auto_increment not working)

danmurf

danmurf

danmurf

Associate
Joined
28 Apr 2007
Posts
27
Location
Colchester, UK
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? :confused:

Any ideas much appreciated! :)
 
I've had that b4... I think mysql4 doesn't support auto increment properly.

I'm assuming your using the same version of mysqladmin on both servers? try using the latest mysqladmin on both...

Have you had a hunt around mysql's website and forums ect?

Sorry I can't be much help on this as I spent a couple of hours on it and then bypassed it... :(
 
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 :)
 
NP, sorry I could be more help.... also, try the mysql GUI tools for win32 if you got a win32 PC around... I've seen phpmyadmin report some weird settings from time to time but the mysql gui tools have never been wrong so far...
 
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 :)
 
You must log in or register to reply here.
Back
Top Bottom