I changed the only two
InnoDB tables on a replication slave to
MyISAM, so the slave now only has
Can I now remove the
ibdata1 file completely?
In case you do not have a single InnoDB table, then yes, you can remove the
The file ibdata1 is tablespace for the InnoDB Engine.If you remove it you will not be able to Start MySQL Server.
If you don't have
Some times ibdata1 grows endlessly,In Case you need help on how to shrink ibdata1 size you can follow steps suggested by RolandoMySQLDBA On MySql - Clean ibdata1 .