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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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
InnoDB tables still you should not remove
ibdata1 file.When you install MySQL
ibdata1 is created by default with initial size of 10MB and has four types of information
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 .