Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Ananda Kumar
sounds like a good solution. regards anandkl On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote: In news:[EMAIL PROTECTED], "Ananda Kumar" <[EMAIL PROTECTED]> wrote: > What i meant to say was. Say if i have two database A & B, and if i > want to move only database A, then the shared tab

Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], "Ananda Kumar" <[EMAIL PROTECTED]> wrote: > What i meant to say was. Say if i have two database A & B, and if i > want to move only database A, then the shared tablespace will also > have info about database B, and when i try to open the database A in > the new machine,

Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Ananda Kumar
Hi Maciej, What i meant to say was. Say if i have two database A & B, and if i want to move only database A, then the shared tablespace will also have info about database B, and when i try to open the database A in the new machine, will it not throw any error, saying that database B is not present

Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Ananda Kumar
Okie, but in this case, if the shared tablespace has other database, then i will be moving that also, which i may not require. regards anandkl On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote: On Wed, 28 Mar 2007, Ananda Kumar wrote: > Hi Maciej, > When you say copying binary Innodb d

Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Maciej Dobrzanski
On Wed, 28 Mar 2007, Ananda Kumar wrote: Hi Maciej, When you say copying binary Innodb data. Can you please elobrate on this. I meant the .ibd files, shared tablespace files, and so on. Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Ananda Kumar
Hi Maciej, When you say copying binary Innodb data. Can you please elobrate on this. regards anandkl On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote: On Wed, 28 Mar 2007, Ananda Kumar wrote: > Hi Maciej, > > Thanks a lot for this info, so the best may to move tables from one db to >

Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Maciej Dobrzanski
On Wed, 28 Mar 2007, Ananda Kumar wrote: Hi Maciej, Thanks a lot for this info, so the best may to move tables from one db to another db on a different machine is to use mysqldump, right? Not necessarily, especially if you are moving to a fresh, empty server. Each solution has its advantage

Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Ananda Kumar
Hi Maciej, Thanks a lot for this info, so the best may to move tables from one db to another db on a different machine is to use mysqldump, right? regards anandkl On 3/28/07, Maciej Dobrzanski <[EMAIL PROTECTED]> wrote: In news:[EMAIL PROTECTED], "Ananda Kumar" <[EMAIL PROTECTED]> wrote: > I

Re: move .idb and .frm files from one db to another db

2007-03-28 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], "Ananda Kumar" <[EMAIL PROTECTED]> wrote: > Is it possible for me to move all these files to a new db on a new > machine. If you can you please let know how it can be done or guide > to any url, it would be of great help. You cannot do this with copying .ibd files alone

move .idb and .frm files from one db to another db

2007-03-28 Thread Ananda Kumar
Hi Friends, I have set innodb_file_per_table option in my.cnf file for one database. Now there is huge load on this servers. Is it possible for me to move all these files to a new db on a new machine. If you can you please let know how it can be done or guide to any url, it would be of great help