List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:January 7 2010 5:30am
Subject:Re: mysql Create table in system database
View as plain text  
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@stripped> 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@stripped> 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.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
>>
>>
>


-- 
Thanks
Suresh Kuna
MySQL DBA

Thread
Re: mysql Create table in system databaseManasi Save7 Jan
  • Re: mysql Create table in system databaseSuresh Kuna7 Jan