First off, you can export from phpmyadmin / mysql 4.1.19 a 4.0 compatible version of the sql dump in Operations -> SQL options -> SQL export compatibility -> MYSQL40
If you can't for some reason, MYSQL 4.1.x adds ENGINE=ISAM for example.
The 4.0.x compatible is TYPE=ISAM ... so
-- FIND :
ENGINE=
-- REPLACE WITH:
TYPE=
4.1 also adds DEFAULT CHARSET=latin1 for example.
I think by just removing DEFAULT it should work, but generally i remove the whole line.
-- DELETE:
DEFAULT CHARSET=latin1
That's about it.
</randomInfo>
If you can't for some reason, MYSQL 4.1.x adds ENGINE=ISAM for example.
The 4.0.x compatible is TYPE=ISAM ... so
-- FIND :
ENGINE=
-- REPLACE WITH:
TYPE=
4.1 also adds DEFAULT CHARSET=latin1 for example.
I think by just removing DEFAULT it should work, but generally i remove the whole line.
-- DELETE:
DEFAULT CHARSET=latin1
That's about it.
</randomInfo>
Last edited:
