MySQL – Consequences of Deleting .idb File

MySQLmysql-5.7

I tried to check what is consumming my Disk Space on Centos 7, I found these 2 database file:

/var/lib/mysql/pub/vues.ibd: 8.1G
/var/lib/mysql/pub/log.ibd: 8.6G

I would like to delete them. pub is the name of my database.
And log and vues are tables.

Best Answer

That would be most unwise. Never fiddle with MySQL files directly.

If you want to delete those tables use SQL:

DROP TABLE pub.vues, pub.log
Related Question