MySql 5 export for MySql 4

[neugi]

Hi,

i try to export a table from my mysql server to place it than on the MySql Server of my Client.

after i exported the table for MySql4, there is no auto_increment for any of the fields.

if i export the script normal without telling my server that i'll use the dump for an MySql4 server the auto_increment will be exported.

my server:
-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- Server Version: 5.0.20
-- PHP-Version: 5.1.2

client server:
-- phpMyAdmin SQL Dump
-- version 2.8.1
-- Server Version: 4.0.12
-- PHP-Version: 4.3.10

maybe  somebody can help me, otherwise i've to add this by hand.

thx

[fenway]

It shouldn't matter -- the auto_increment value will be ok anyway.

[wildteen88]

If you are exporting a MySQL5 database in phpMyAdmin to MYSQL4. Make sure when you are in the export page (by clicking the Export tab at top of the page for your database). That the [b]SQL export compatibility[/b] option is set to MySQL40 and that the [b]Add AUTO_INCREMENT value[/b] checkbox is checked.

[neugi]

Hi,

export with standard settings:

[code]CREATE TABLE `sprache` (
  `id` int(11) NOT NULL auto_increment,
  `ger` text collate latin1_general_ci NOT NULL,
  `eng` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='texte für die homepage' AUTO_INCREMENT=29 ;[/code]

export with settings for mysql 4:
[code]CREATE TABLE `sprache` (
  `id` int(11) NOT NULL,
  `ger` text NOT NULL,
  `eng` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='texte für die homepage' AUTO_INCREMENT=29 ;[/code]

at the field there is missing the auto_increment statement. the value ist exported at both. Ive also tried to check every checkbox and export but the auto_increment is still missing.

still got the problem

[fenway]

Oh... I thought you meant the value, not the actual attribute to the field itself... I've never seen that before.