Description:
InnoDB: You are downgrading from the multiple tablespace format of
InnoDB: >= MySQL-4.1.1 back to the old format of MySQL-4.0.
InnoDB:
InnoDB: MAKE SURE that the mysqld server is idle, and purge and the insert
InnoDB: buffer merge have run to completion under >= 4.1.1 before trying to
InnoDB: downgrade! You can determine this by looking at SHOW INNODB STATUS:
InnoDB: if the Main thread is 'waiting for server activity' and SHOW
InnoDB: PROCESSLIST shows that you have ended all other connections
InnoDB: to mysqld, then purge and the insert buffer merge have been
InnoDB: completed.
InnoDB: If you have already created tables in >= 4.1.1, then those
InnoDB: tables cannot be used under 4.0.
InnoDB: NOTE THAT this downgrade procedure has not been properly tested!
InnoDB: The safe way to downgrade is to dump all InnoDB tables and recreate
InnoDB: the whole tablespace.
How to repeat:
rm -Rf /usr/local/mysql
./BUILD/compile-pentium
make install
./scripts/mysql_install_db
cp ./support-files/my-small.cnf /usr/local/mysql/var/my.cnf
chown -R mysql:daemon /usr/local/mysql
./support-files/mysql.server start
/usr/local/mysql/bin/mysql
create database phpOpenTracker;
exit;
/usr/local/mysql/bin/mysql phpOpenTracker < phpOpenTracker.sql
The phpOpenTracker.sql file contains CREATE TABLE ... TYPE=InnoDB; statements as well as INSERTs. After the above command has completed I see the pasted InnoDB messages in the /usr/local/mysql/var/wopr-mobile.err logfile.
