File permissions ? SE Linux ? AppArmor ?
On Mon, Nov 16, 2009 at 7:48 AM, Manasi Save <
> 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,
> Manasi Save
> 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
> >> am
> >> 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
> > http://dev.mysql.com/doc/refman/5.1/en/information-schema.html
> > ~~
> > Inside INFORMATION_SCHEMA there are several read-only tables. They are
> > actually views, not base tables, so there are no files associated with
> > them.
> > ~~
> > More details are available in the manual:
> > http://dev.mysql.com/doc/refman/5.1/en/myisam-storage-engine.html
> > http://dev.mysql.com/doc/refman/5.1/en/innodb-table-and-index.html
> > http://dev.mysql.com/doc/refman/5.1/en/se-db2.html
> > http://dev.mysql.com/doc/refman/5.1/en/merge-storage-engine.html
> > http://dev.mysql.com/doc/refman/5.1/en/memory-storage-engine.html
> > http://dev.mysql.com/doc/refman/5.1/en/federated-description.html
> > http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html
> > http://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.html
> > http://dev.mysql.com/doc/refman/5.1/en/blackhole-storage-engine.html
> > --
> > Shawn Green, MySQL Senior Support Engineer
> > Sun Microsystems, Inc.
> > Office: Blountville, TN
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1