These tips were posted in the forum by havanese_boy in this thread:

Problem:

My personal server was running MySQL 4.1.x with my database using InnoDB tables.
my web host uses MySQL 4.0.x and the tables have to be MyISAM.

So I needed to change my tables as well as convert back to 4.0.x.

Solution

1. Using the CONVERT command I changed all my tables from InnoDB to MyISAM.

2. Using the following command I created a dump file which is needed for step #3.

shell>mysqldump—create-options—compatible=mysql40 db_name > dump_file

3. After creating the dump file, I then took the dump file and moving to a MySQL server running 4.0.x I ran the following command.

shell>mysql db_name

<

dump_file

Once I did this I made a backup and then imported it to the database created on my hosting acct.

That’s all it took…