Linux technical support - [email protected]


clean ibdata1, convert data to per table files

1) backup all DBs
2) stop mysql
3) add “innodb_file_per_table” to my.cnf
4) delete:
ibdata1
ib_logfileXXX
5) start mysql

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>