Thanks Shawn for the quick response.
But then What I am doing is I am doing copy paste of one database and
rename it to another. but I cannot read the tables inside it.
Can you tell me what might be the possible reason for that.
Thanks and Regards,
Artificial Machines Pvt Ltd.
> Hello Manasi,
> Manasi Save wrote:
>> Hi All,
>> Can anyone give me any input on How mysql create table write data into
>> system database and where it has been stored besides information_schema.
>> Is there any article on mysql System Databases anyone went through as I
>> not able to find it on Google.
>> I want to write a table information in mysql system database. Can anyone
>> help me on this.
>> Thanks in advance.
> MySQL does not store that information within an internal table. The
> basic information for each table is stored within a .frm file stored in
> the file system. The various additional pieces of metadata for each
> storage engine are maintained in methods specific to those storage
> engine. The information you see in the many tables exposed through
> INFORMATION_SCHEMA is generated dynamically based on the results of
> polling those separate sources of metadata at the time of your query.
> quoting from
> Inside INFORMATION_SCHEMA there are several read-only tables. They are
> actually views, not base tables, so there are no files associated with
> More details are available in the manual:
> Shawn Green, MySQL Senior Support Engineer
> Sun Microsystems, Inc.
> Office: Blountville, TN