apt-get install mdbtools
mysqladmin create newdatabase
mdb-schema olddatabase.mdb postgres \
| sed "s/Int8/int/" \
| sed "s/Char /varchar/" \
| sed "s/^-/#/" \
| grep -v "^DROP" \
| mysql newdatabase
Explanation:
- exporting as progres (since mysql is not an option);
- the first sed turns Int8 into int (which becomes int(11);
- the second sed turns Char into varchar;
- the third sed turns postgres comments into mysql comments;
- the grep drops the DROP statement
It seems to work quite well. Of course, if you have other data types then Int8 and Char, you might want to add some sed magic of your own.