How to reduce the size of IBDATA?

[mos]

I have an IBDATA1 file that has grown to 2gb even though all Innodb tables 
have been either converted to MyISAM or dropped. (There are no InnoDb 
tables left)  My question is how to I decrease the size of the IBData file?

I tried shutting down the MySQL server and deleting the IBDATA1 file, then 
restart MySQL to rebuild the file. But MySQL has a problem of starting and 
no error is reported in MySQL.Err.

So is there a proper way of reducing the size of the filespace used by 
Innodb? TIA

Mike
Win2k & MySQL 4


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]