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
5108
June 14, 2006 08:23AM
2800
June 14, 2006 09:48AM
Re: Removing schema information from MySQL system files
2837
June 14, 2006 11:07AM
2962
June 14, 2006 12:15PM
2508
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.