Re: mysql Create table in system database

2010-01-06 Thread Suresh Kuna
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

Re: mysql Create table in system database

2010-01-06 Thread Manasi Save
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 qui

Re: mysql Create table in system database

2009-11-16 Thread Johan De Meersman
File permissions ? SE Linux ? AppArmor ? On Mon, Nov 16, 2009 at 7:48 AM, Manasi Save < manasi.s...@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

Re: mysql Create table in system database

2009-11-15 Thread 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. >

Re: mysql Create table in system database

2009-11-14 Thread Shawn Green
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

mysql Create table in system database

2009-11-13 Thread Manasi Save
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