What files of Mysql lib directory safe to be deleted and to be recreated with innodb_file_per_table settings?

Database Administrators Asked on December 12, 2020

I have brand new mysql 8 setup and installed on a centos 7. Unfortunately I forget to set innodb_file_per_table. I would like to dump the database and recreate with the innodb_file_per_table settings. I have google and its say its safe to delete ibdata1 and ib_logfile0 and ib_lofile1. But I could see many other files in it example binlog.000001, binlog.index, .pem file. mysql.ibd, #innodb_temp,undo_001, undo_002, performance_schema, mysql, mysql.sock,mysqlx.sock, sys etc. My question is that which are the files I should delete to get a fresh setup with my new settings?

Add your own answers!

Related Questions

Automatically purging binary logs

6  Asked on January 6, 2022 by kriegu


Query customers attributes

1  Asked on January 6, 2022 by mac-portter


MongoDB different members of cluster choosing different index

1  Asked on January 4, 2022 by marc-esher


The opposite of ordering by a column in SQL

2  Asked on January 2, 2022 by john-hamelink


How to deal with a person that may have multiple alias names?

2  Asked on January 2, 2022 by javascriptloser


Service Broker locks

1  Asked on January 2, 2022


How can I find a view column’s base table column?

3  Asked on December 31, 2021 by durette


Ask a Question

Get help from others!

© 2022 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP