Re: Removing schema information from MySQL system files
The DELETE command does remove mention of the former databases from the tables in the mysql database. Performing SELECT on the tables_priv, column_priv and db tables show empty tables. Unfortunately, the tables_priv.MYD, tables_priv.MYI, columns_priv.MYD, columns_priv.MYI and db.MYD files still containn reference to the database that were created on the system, even after DELETE and FLUSH PRIVILEGES. Even removing MySQL server all together does not cause the files to be reset or emptied.
Martin
Subject
Views
Written By
Posted
5186
June 14, 2006 08:23AM
2846
June 14, 2006 09:48AM
Re: Removing schema information from MySQL system files
2872
June 14, 2006 11:07AM
2998
June 14, 2006 12:15PM
2540
June 15, 2006 09:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.