AnswerBun.com

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 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP