Re: Using MySQL 4 to create tables for MySQL 3

[Ingo Strüwing]

I cannot give a definite answer on this. It depends on your schema and data. You might want to try this with a smaller number of records first. There were a number of changes in 4.1, which could make it impossible. Changed handling of trailing space and charsets for example. If you really want to try it, create the table and indexes on 3.23.58, transfer .frm, .MYD, and .MYI to 4.1, load the data with single INSERT commands (no bulk insert, as it disables the indexes and re-creates them), and move the files .MYD and .MYI back if the .frm files are still equal (not updated by 4.1 that is). Then try some selects.

The better way (if possible) would be to install MySQL 3.23.58 on the new machine. This version is still downloadable for a bunch of platforms from the MySQL web page. http://downloads.mysql.com/archives.php?p=mysql-3.23&v=3.23.58