Best practice migrating mysql 4.1.x -> 5.0.x with mixed innodb myisamtables

--------------ms030603080105070205080101
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable

Hey,

happy new year and I do have a question what might be the best way to
migrate some different databases to a new central server.

The question came up as I wanted to put our web CMS database on our
newer master/slave mysql installation.

We run red hat el 4 and 5 right now, so the source db is mysql 4.1.22
and the target is 5.0.77.

I did a mysqldump (--create-options --default-character-set=3Dutf8 -K -e
--opt -q) on the source server and imported that dump on the new system,
but all innodb tabels are converted to myisam.

In the last time I focused on other topics than mysql, so may be
somewone can explain to me or give me a link to some compressed doku on
what happend and why?!

The other question is, what might be the best way to migrate the 'old'
database to a/the new system? This might be importand to, when switching
to myslq > 5.0

Dose the my.cnf options for innodb have to be identically?

Thanks a lot for any hint or suggestion!


Best regards . Götz
--=20
Götz Reinicke
IT-Koordinator

Tel. +49 7141 969 420
Fax +49 7141 969 55 420
E-Mail goetz.reinicke@filmakademie.de

Filmakademie Baden-Württemberg GmbH
Akademiehof 10
71638 Ludwigsburg
www.filmakademie.de

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrats:
Prof. Dr. Claudia Hübner

Geschäftsführer:
Prof. Thomas Schadt


--------------ms030603080105070205080101
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIVNTCC
BCEwggMJoAMCAQICAgDHMA0GCSqGSIb3DQEBBQUAMHExCzAJBgNVBAYTAkRF MRwwGgYDVQQK
ExNEZXV0c2NoZSBUZWxla29tIEFHMR8wHQYDVQQLExZULVRlbGVTZWMgVHJ1 c3QgQ2VudGVy
MSMwIQYDVQQDExpEZXV0c2NoZSBUZWxla29tIFJvb3QgQ0EgMjAeFw0wNjEy MTkxMDI5MDBa
Fw0xOTA2MzAyMzU5MDBaMFoxCzAJBgNVBAYTAkRFMRMwEQYDVQQKEwpERk4t VmVyZWluMRAw
DgYDVQQLEwdERk4tUEtJMSQwIgYDVQQDExtERk4tVmVyZWluIFBDQSBHbG9i YWwgLSBHMDEw
ggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDpm8NnhfkNrvWNVMOW UDU9YuluTO2U
1wBblSJ01CDrNI/W7MAxBAuZgeKmFNJSoCgjhIt0iQReW+DieMF4yxbLKDU5 ey2QRdDtoAB6
fL9KDhsAw4bpXCsxEXsM84IkQ4wcOItqaACa7txPeKvSxhObdq3u3ibo7wGv dA/BCaL2a869
080UME/15eOkyGKbghoDJzANAmVgTe3RCSMqljVYJ9N2xnG2kB3E7f81hn1v M7PbD8URwoqD
oZRdQWvY0hD1TP3KUazZve+Sg7va64sWVlZDz+HVEz2mHycwzUlU28kTNJpx dcVs6qcLmPkh
nSevPqM5OUhqjK3JmfvDEvK9AgMBAAGjgdkwgdYwcAYDVR0fBGkwZzBloGOg YYZfaHR0cDov
L3BraS50ZWxlc2VjLmRlL2NnaS1iaW4vc2VydmljZS9hZl9Eb3dubG9hZEFS TC5jcmw/LWNy
bF9mb3JtYXQ9WF81MDkmLWlzc3Vlcj1EVF9ST09UX0NBXzIwHQYDVR0OBBYE FEm3xs/oPR9/
6kR7Eyn38QpwPt5kMB8GA1UdIwQYMBaAFDHDeRu69VPXF+CJei0XbAqzK50z MA4GA1UdDwEB
/wQEAwIBBjASBgNVHRMBAf8ECDAGAQH/AgECMA0GCSqGSIb3DQEBBQUAA4IB AQA74Vp3wEgX
3KkY7IGvWonwvSiSpspZGBJw7Cjy565/lizn8l0ZMfYTK3S9vYCyufdnyTmi eTvhERHua3iR
M347XyYndVNljjNj7s9zw7CSI0khUHUjoR8Y4pSFPT8z6XcgjaK95qGFKUD2 P3MyWA0Ja6ba
hWzAP7uNZmRWJE6uDT8yNQFb6YyC2XJZT7GGhfF0hVblw/hc843uR7NTBXDn 5U2KaYMo4RMJ
hp5eyOpYHgwf+aTUWgRo/Sg+iwK2WLX2oSw3VwBnqyNojWOl75lrXP1LVvar QIc01BGSbOyH
xQoLBzNytG8MHVQs2FHHzL8w00Ny8TK/jM5JY6gA9/IcMIIFXjCCBEagAwIB AgIEEBtOAjAN
BgkqhkiG9w0BAQUFADBaMQswCQYDVQQGEwJERTETMBEGA1UEChMKREZOLVZl cmVpbjEQMA4G
A1UECxMHREZOLVBLSTEkMCIGA1UEAxMbREZOLVZlcmVpbiBQQ0EgR2xvYmFs IC0gRzAxMB4X
DTEwMDUyNTEzMjgxOVoXDTE5MDYzMDAwMDAwMFowgcoxCzAJBgNVBAYTAkRF MRswGQYDVQQI
ExJCYWRlbi1XdWVydHRlbWJlcmcxFDASBgNVBAcTC0x1ZHdpZ3NidXJnMS0w KwYDVQQKEyRG
aWxtYWthZGVtaWUgQmFkZW4tV3VlcnR0ZW1iZXJnIEdtYkgxFTATBgNVBAsT DElUIE9mZmlj
ZU5ldDEaMBgGA1UEAxMRRkEgTHVkd2lnc2J1cmcgQ0ExJjAkBgkqhkiG9w0B CQEWF2NhLWZh
bHVAZmlsbWFrYWRlbWllLmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB CgKCAQEA0mMf
lkuyiVXWqKo8TpRjIJWhIkmCr/singYPLtM5wXTfvpGhCOnkVOeEb0Qzy/C3 zNlIrLObsJ78
1AwKNRyXOTW2T7fA3JrQPEFsahjXmVsWLDBCyA0S2uQa/0xStMET7m+MxohJ VJ5503M6T+Xg
kuwW3r7xq7gB7CjHSK7n0VdrrDWamqES1cBr7GJutCZNfic/PXsW3QO7hOT3 Y/XX0RnX5OJr
uMFF5V7qyb/Q+Ma9U5NGaqy4FakTLyTK4naP+N8Gvlnqn41/sUdNXwx4YMvC TUEH4ujAB6Wf
vP+OPnnOrjzPElcfs6JXQ2P9Wxhvrx0EaAdH7e5w1oZb00sSvQIDAQABo4IB uTCCAbUwEgYD
VR0TAQH/BAgwBgEB/wIBATALBgNVHQ8EBAMCAQYwHQYDVR0OBBYEFM3uRxJy PeKNeVus3iNL
fQZwWJi8MB8GA1UdIwQYMBaAFEm3xs/oPR9/6kR7Eyn38QpwPt5kMCIGA1Ud EQQbMBmBF2Nh
LWZhbHVAZmlsbWFrYWRlbWllLmRlMIGIBgNVHR8EgYAwfjA9oDugOYY3aHR0 cDovL2NkcDEu
cGNhLmRmbi5kZS9nbG9iYWwtcm9vdC1jYS9wdWIvY3JsL2NhY3JsLmNybDA9 oDugOYY3aHR0
cDovL2NkcDIucGNhLmRmbi5kZS9nbG9iYWwtcm9vdC1jYS9wdWIvY3JsL2Nh Y3JsLmNybDCB
ogYIKwYBBQUHAQEEgZUwgZIwRwYIKwYBBQUHMAKGO2h0dHA6Ly9jZHAxLnBj YS5kZm4uZGUv
Z2xvYmFsLXJvb3QtY2EvcHViL2NhY2VydC9jYWNlcnQuY3J0MEcGCCsGAQUF BzAChjtodHRw
Oi8vY2RwMi5wY2EuZGZuLmRlL2dsb2JhbC1yb290LWNhL3B1Yi9jYWNlcnQv Y2FjZXJ0LmNy
dDANBgkqhkiG9w0BAQUFAAOCAQEAupdwxPU9OGGH4qGEKBMO2dUjTZtSIYJy W8uN1cMgv2cD
gkZpFXEycEgpp+gm7gzvup3TC0010XnZ3jVuNycEuClJLB1elYDrCRTHH46l TglPygxzeSO0
Ybv94qx4Q0pCK2IplBYPvmcHGrWmSUIXEDzbIFBf38lv9/YO5AgFijdU+V5D bEBzbcBHZ4OL
G9Mjpi0pW6wPEJw5jel5O/NmJOQ1G+pOPwHfbPowaiTnDTs3JRBdy5xzGLzt 6dLvp7agEHpX
ENZoIVdtuEE6nKdouJGcuPqyySZBQ6xsSV0ppH+ezLciEWshS5KkBFSf8YQ1 z9NVIi09y1Hx
Gt3szSO5STCCBdMwggS7oAMCAQICBBA+n+0wDQYJKoZIhvcNAQEFBQAwgcox CzAJBgNVBAYT
AkRFMRswGQYDVQQIExJCYWRlbi1XdWVydHRlbWJlcmcxFDASBgNVBAcTC0x1 ZHdpZ3NidXJn
MS0wKwYDVQQKEyRGaWxtYWthZGVtaWUgQmFkZW4tV3VlcnR0ZW1iZXJnIEdt YkgxFTATBgNV
BAsTDElUIE9mZmljZU5ldDEaMBgGA1UEAxMRRkEgTHVkd2lnc2J1cmcgQ0Ex JjAkBgkqhkiG
9w0BCQEWF2NhLWZhbHVAZmlsbWFrYWRlbWllLmRlMB4XDTEwMDYyMTA4Mjcw OVoXDTEzMDYy
MDA4MjcwOVowVTELMAkGA1UEBhMCREUxLTArBgNVBAoTJEZpbG1ha2FkZW1p ZSBCYWRlbi1X
dWVydHRlbWJlcmcgR21iSDEXMBUGA1UEAxMOR29ldHogUmVpbmlja2UwggEi MA0GCSqGSIb3
DQEBAQUAA4IBDwAwggEKAoIBAQCvJgdLf/1lSZt6/cdJ6fQPJ+pBLsLm+0Zt /5xxELD30fVg
YS3ocYfwesyoBR0wiryR0dlNGISElfhssanYCluoF4RIi1LyUSGZbf6Dz3bp oqGRoLu5FJrX
thbD23AopV/s8RNm8P2qTBHuPtvBrIR2r52uV9/pZkdESFkXmC3AEStYaJJG G13JbGaYIg4I
exzH0Pxw9bvPxzv/iRDznV66RpY+hRyky4ouxaKp43rZbfeHQEbTMApWI8ck 1OqhYkdrv+/V
3M5nI1Zck9aWukAkE9aHeU9NUhv5ThHCIt6FavBHpx+clxR8v+qXz4mdSIwG hhM35kSqH05/
PluzXkutAgMBAAGjggIzMIICLzAJBgNVHRMEAjAAMAsGA1UdDwQEAwIF4DAp BgNVHSUEIjAg
BggrBgEFBQcDAgYIKwYBBQUHAwQGCisGAQQBgjcUAgIwHQYDVR0OBBYEFKoQ /yRAmIMHBjxL
X0t/ZyUP8YdfMB8GA1UdIwQYMBaAFM3uRxJyPeKNeVus3iNLfQZwWJi8MCkG A1UdEQQiMCCB
HmdvZXR6LnJlaW5pY2tlQGZpbG1ha2FkZW1pZS5kZTCBsQYDVR0fBIGpMIGm MFGgT6BNhkto
dHRwOi8vY2RwMS5wY2EuZGZuLmRlL2ZpbG1ha2FkZW1pZS1iYWRlbi13dWVy dHRlbWJlcmct
Y2EvcHViL2NybC9jYWNybC5jcmwwUaBPoE2GS2h0dHA6Ly9jZHAyLnBjYS5k Zm4uZGUvZmls
bWFrYWRlbWllLWJhZGVuLXd1ZXJ0dGVtYmVyZy1jYS9wdWIvY3JsL2NhY3Js LmNybDCBygYI
KwYBBQUHAQEEgb0wgbowWwYIKwYBBQUHMAKGT2h0dHA6Ly9jZHAxLnBjYS5k Zm4uZGUvZmls
bWFrYWRlbWllLWJhZGVuLXd1ZXJ0dGVtYmVyZy1jYS9wdWIvY2FjZXJ0L2Nh Y2VydC5jcnQw
WwYIKwYBBQUHMAKGT2h0dHA6Ly9jZHAyLnBjYS5kZm4uZGUvZmlsbWFrYWRl bWllLWJhZGVu
LXd1ZXJ0dGVtYmVyZy1jYS9wdWIvY2FjZXJ0L2NhY2VydC5jcnQwDQYJKoZI hvcNAQEFBQAD
ggEBAK0DGenAT6oI+vu+21AOtGbKf6erWSJOG9p9ltL8/jGvl28YlhSESl1C nElIRDIJKqNT
HeO9Wp17Yutay+xXMm8Qdesf6jQcJLiVLRnqbwdDj8Bp1JGU50bo4tRM4BPR GN4TQ1zjouvk
lk20BXrdA9iSEBQ35DtGjn4AeKkdZxGMFiT9FulUvWVOTVoTZwUZUuo6iggo AwM4l5UgN5Ug
beRvJZFNKyaIneFIME7k1RyLoAYZZEoN1VuvovyGcw4gApRFQImRgwnhCNN9 E6fbjJbZ9Y6j
YYWLqSHzKcLR80vyj1rYXSbUf8ML6tyg34fX6zh0uYVOwWmxj7Fj7vmRoJow ggXTMIIEu6AD
AgECAgQQPp/tMA0GCSqGSIb3DQEBBQUAMIHKMQswCQYDVQQGEwJERTEbMBkG A1UECBMSQmFk
ZW4tV3VlcnR0ZW1iZXJnMRQwEgYDVQQHEwtMdWR3aWdzYnVyZzEtMCsGA1UE ChMkRmlsbWFr
YWRlbWllIEJhZGVuLVd1ZXJ0dGVtYmVyZyBHbWJIMRUwEwYDVQQLEwxJVCBP ZmZpY2VOZXQx
GjAYBgNVBAMTEUZBIEx1ZHdpZ3NidXJnIENBMSYwJAYJKoZIhvcNAQkBFhdj YS1mYWx1QGZp
bG1ha2FkZW1pZS5kZTAeFw0xMDA2MjEwODI3MDlaFw0xMzA2MjAwODI3MDla MFUxCzAJBgNV
BAYTAkRFMS0wKwYDVQQKEyRGaWxtYWthZGVtaWUgQmFkZW4tV3VlcnR0ZW1i ZXJnIEdtYkgx
FzAVBgNVBAMTDkdvZXR6IFJlaW5pY2tlMIIBIjANBgkqhkiG9w0BAQEFAAOC AQ8AMIIBCgKC
AQEAryYHS3/9ZUmbev3HSen0DyfqQS7C5vtGbf+ccRCw99H1YGEt6HGH8HrM qAUdMIq8kdHZ
TRiEhJX4bLGp2ApbqBeESItS8lEhmW3+g8926aKhkaC7uRSa17YWw9twKKVf 7PETZvD9qkwR
7j7bwayEdq+drlff6WZHREhZF5gtwBErWGiSRhtdyWxmmCIOCHscx9D8cPW7 z8c7/4kQ851e
ukaWPoUcpMuKLsWiqeN62W33h0BG0zAKViPHJNTqoWJHa7/v1dzOZyNWXJPW lrpAJBPWh3lP
TVIb+U4RwiLehWrwR6cfnJcUfL/ql8+JnUiMBoYTN+ZEqh9Ofz5bs15LrQID AQABo4ICMzCC
Ai8wCQYDVR0TBAIwADALBgNVHQ8EBAMCBeAwKQYDVR0lBCIwIAYIKwYBBQUH AwIGCCsGAQUF
BwMEBgorBgEEAYI3FAICMB0GA1UdDgQWBBSqEP8kQJiDBwY8S19Lf2clD/GH XzAfBgNVHSME
GDAWgBTN7kcScj3ijXlbrN4jS30GcFiYvDApBgNVHREEIjAggR5nb2V0ei5y ZWluaWNrZUBm
aWxtYWthZGVtaWUuZGUwgbEGA1UdHwSBqTCBpjBRoE+gTYZLaHR0cDovL2Nk cDEucGNhLmRm
bi5kZS9maWxtYWthZGVtaWUtYmFkZW4td3VlcnR0ZW1iZXJnLWNhL3B1Yi9j cmwvY2Fjcmwu
Y3JsMFGgT6BNhktodHRwOi8vY2RwMi5wY2EuZGZuLmRlL2ZpbG1ha2FkZW1p ZS1iYWRlbi13
dWVydHRlbWJlcmctY2EvcHViL2NybC9jYWNybC5jcmwwgcoGCCsGAQUFBwEB BIG9MIG6MFsG
CCsGAQUFBzAChk9odHRwOi8vY2RwMS5wY2EuZGZuLmRlL2ZpbG1ha2FkZW1p ZS1iYWRlbi13
dWVydHRlbWJlcmctY2EvcHViL2NhY2VydC9jYWNlcnQuY3J0MFsGCCsGAQUF BzAChk9odHRw
Oi8vY2RwMi5wY2EuZGZuLmRlL2ZpbG1ha2FkZW1pZS1iYWRlbi13dWVydHRl bWJlcmctY2Ev
cHViL2NhY2VydC9jYWNlcnQuY3J0MA0GCSqGSIb3DQEBBQUAA4IBAQCtAxnp wE+qCPr7vttQ
DrRmyn+nq1kiThvafZbS/P4xr5dvGJYUhEpdQpxJSEQyCSqjUx3jvVqde2Lr WsvsVzJvEHXr
H+o0HCS4lS0Z6m8HQ4/AadSRlOdG6OLUTOAT0RjeE0Nc46Lr5JZNtAV63QPY khAUN+Q7Ro5+
AHipHWcRjBYk/RbpVL1lTk1aE2cFGVLqOooIKAMDOJeVIDeVIG3kbyWRTSsm iJ3hSDBO5NUc
i6AGGWRKDdVbr6L8hnMOIAKURUCJkYMJ4QjTfROn24yW2fWOo2GFi6kh8ynC 0fNL8o9a2F0m
1H/DC+rcoN+H1+s4dLmFTsFpsY+xY+75kaCaMYIEjTCCBIkCAQEwgdMwgcox CzAJBgNVBAYT
AkRFMRswGQYDVQQIExJCYWRlbi1XdWVydHRlbWJlcmcxFDASBgNVBAcTC0x1 ZHdpZ3NidXJn
MS0wKwYDVQQKEyRGaWxtYWthZGVtaWUgQmFkZW4tV3VlcnR0ZW1iZXJnIEdt YkgxFTATBgNV
BAsTDElUIE9mZmljZU5ldDEaMBgGA1UEAxMRRkEgTHVkd2lnc2J1cmcgQ0Ex JjAkBgkqhkiG
9w0BCQEWF2NhLWZhbHVAZmlsbWFrYWRlbWllLmRlAgQQPp/tMAkGBSsOAwIa BQCgggKOMBgG
CSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTExMDEw NTE0MDczMFow
IwYJKoZIhvcNAQkEMRYEFA5DJ27G2kOLAJEgUh7xy255omEOMF8GCSqGSIb3 DQEJDzFSMFAw
CwYJYIZIAWUDBAECMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggq hkiG9w0DAgIB
QDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDCB5AYJKwYBBAGCNxAEMYHWMIHT MIHKMQswCQYD
VQQGEwJERTEbMBkGA1UECBMSQmFkZW4tV3VlcnR0ZW1iZXJnMRQwEgYDVQQH EwtMdWR3aWdz
YnVyZzEtMCsGA1UEChMkRmlsbWFrYWRlbWllIEJhZGVuLVd1ZXJ0dGVtYmVy ZyBHbWJIMRUw
EwYDVQQLEwxJVCBPZmZpY2VOZXQxGjAYBgNVBAMTEUZBIEx1ZHdpZ3NidXJn IENBMSYwJAYJ
KoZIhvcNAQkBFhdjYS1mYWx1QGZpbG1ha2FkZW1pZS5kZQIEED6f7TCB5gYL KoZIhvcNAQkQ
AgsxgdaggdMwgcoxCzAJBgNVBAYTAkRFMRswGQYDVQQIExJCYWRlbi1XdWVy dHRlbWJlcmcx
FDASBgNVBAcTC0x1ZHdpZ3NidXJnMS0wKwYDVQQKEyRGaWxtYWthZGVtaWUg QmFkZW4tV3Vl
cnR0ZW1iZXJnIEdtYkgxFTATBgNVBAsTDElUIE9mZmljZU5ldDEaMBgGA1UE AxMRRkEgTHVk
d2lnc2J1cmcgQ0ExJjAkBgkqhkiG9w0BCQEWF2NhLWZhbHVAZmlsbWFrYWRl bWllLmRlAgQQ
Pp/tMA0GCSqGSIb3DQEBAQUABIIBADxVDsaOW2aB4Ld1fn0AImSj5UiWTNd7 xbf+d3aRdoUZ
XLvV+I7sPG/R8yrHJ0fCY3AoYCj1n002GnI0hO3v8txFp4g0hvFfKth7an8g CAPhOWsKPqhN
+RDq3bwWKatgK9LV6l3JgfzdRynQjqxscW+b1LU9jjsON0GlQeY5m2OPpWWw Wb9PCa2xOf3K
c70iAkSzWe7rsMVgSY2FkLa7qaZW3hsAimhYf2Bjbt5xL1EpBZycsD3f+LPn QYXGvgjomOIN
uwSWn/uDS2mN0ozWQFde0TxErIhnj21NaWQWJLoeGjKgEaJGJXV86jyS4no+ +gYCUI5wva9r
tDpzDLFE2BAAAAAAAAA=
--------------ms030603080105070205080101--