Removing schema information from MySQL system files

[Martin Dubuc]

I am trying to write some RPM scripts to remove my application from a system. My application uses MySQL database. I notice that even after I perform DROP DATABASE, there is still some reference to my database (database name, column names, etc.) in various system files. Under /var/lib/mysql/mysql, I can find references to my database schema in the following files: tables_priv.MYI, columns_priv.MYI, db.MYI, db.MYD, tables_priv.MYD. I wonder if there is a way to massage these files to remove mention to databases that would be removed from the system. Even performing a RPM remove of MySQL server leaves these files around.

Martin