mysql Create table in system database

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.

--
Regards,
Manasi Save
Artificial Machines Pvt Ltd.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql Create table in system database

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.ht ml
~~
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-inde x.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-engin e.html
http://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.ht ml
http://dev.mysql.com/doc/refman/5.1/en/blackhole-storage-eng ine.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=gcdmg-mysql-2@m.gmane.org

Re: mysql Create table in system database

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.ht ml
> ~~
> 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-inde x.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-engin e.html
> http://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.ht ml
> http://dev.mysql.com/doc/refman/5.1/en/blackhole-storage-eng ine.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=gcdmg-mysql-2@m.gmane.org

Re: mysql Create table in system database

--0050450181022223950478792f0a
Content-Type: text/plain; charset=ISO-8859-1

File permissions ? SE Linux ? AppArmor ?

On Mon, Nov 16, 2009 at 7:48 AM, Manasi Save <
manasi.save@artificialmachines.com> wrote:

> 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.ht ml
> > ~~
> > 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-inde x.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-engin e.html
> > http://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.ht ml
> > http://dev.mysql.com/doc/refman/5.1/en/blackhole-storage-eng ine.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=vegivamp@tuxera.be
>
>

--0050450181022223950478792f0a--

Re: mysql Create table in system database

--=_3z6f8iulbyf4
Content-Type: text/plain;
charset=UTF-8;
format="flowed"
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit


Hi Johan,

Is it possible to do such manipulation in NDB, the way innodb works.

Thanks in advance.

--
Regards,
Manasi Save

Quoting Johan De Meersman :

File permissions ? SE Linux ? AppArmor ?

On Mon, Nov 16, 2009 at 7:48 AM, Manasi Save wrote:

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.ht ml
> ~~
> 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-inde x.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
>



--=_3z6f8iulbyf4
Content-Type: multipart/related;
boundary="=_4jbnefc3en7k";
start="4jcggtm689hc@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_4jbnefc3en7k
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 4jcggtm689hc@mail.artificialmachines.com

Hi Johan,

Is it possible to do such manipulation in NDB,
the way innodb works.

Thanks in advance.

--

Regards,

Re: mysql Create table in system database

--00504502c10d370516047c8c5dfc
Content-Type: text/plain; charset=ISO-8859-1

Hi Manasi,
Do you mean the copy paste of one database and rename it to another ?
If so, it is not possible as the data is shared between the data nodes by
partitioning.
For innodb, if you are using file_per_table option, We can do so and give
the "flush tables" command to read the same but the data dictionary will get
effected.

Thanks
Suresh Kuna
MySQL DBA

On Thu, Jan 7, 2010 at 9:46 AM, Manasi Save <
manasi.save@artificialmachines.com> wrote:

> Hi Johan,
>
>
> Is it possible to do such manipulation in NDB, the way innodb works.
>
>
> Thanks in advance.
>
>
> --
>
> Regards,
> Manasi Save
>
>
> Quoting Johan De Meersman :
>
> File permissions ? SE Linux ? AppArmor ?
>
> On Mon, Nov 16, 2009 at 7:48 AM, Manasi Save <
> manasi.save@artificialmachines.com> wrote:
>
>> 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.ht ml
>> > ~~
>> > 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-inde x.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-engin e.html
>> > http://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.ht ml
>> > http://dev.mysql.com/doc/refman/5.1/en/blackhole-storage-eng ine.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=vegivamp@tuxera.be
>>
>>
>


--
Thanks
Suresh Kuna
MySQL DBA

--00504502c10d370516047c8c5dfc--