Re: MySQL - Ibdata file deletion ?
Posted by: Rick James
Date: November 12, 2014 12:15AM

NO. Do _NOT_ delete ibdata1; it contains vital data.

If your goal was to shrink ibdata1, the you needed to dump and reload all the tables, with the delete in the middle of the procedure. After the procedure, ibdata1 was reconstructed based on the size given in my.cnf.

10G is not very big these days. I recommend ignoring it.

Options: ReplyQuote

Written By
November 11, 2014 02:07AM
Re: MySQL - Ibdata file deletion ?
November 12, 2014 12:15AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.