Moving database from one machine to another machine..

Hi, I have 2 machine. Master and a slave replication. few days back I have switched slave machine (innodb_file_per_table) from single innodb file to one per file table. Now I want to do for Master. Now question, Is it recommendable this method, stop MYSQL services on both and copy mysql

Re: Moving database from one machine to another machine..

Am 14.09.2011 22:06, schrieb Prabhat Kumar: Hi, I have 2 machine. Master and a slave replication. few days back I have switched slave machine (innodb_file_per_table) from single innodb file to one per file table. Now I want to do for Master. Now question, Is it recommendable

Re: Moving database from one machine to another machine..

If the hardware on master and slave, version of mysql server, configuration and memory allocations are same then you can do a clean shutdown of mysql on slave and copy the files to master. Check if any memories needs to be adjusted and start mysql adding the innodb_file_per_table option on master

Re: Moving database from one machine to another machine..

Hi Prabhat, FYI On Thu, Sep 15, 2011 at 10:33 AM, Suresh Kuna sureshkumar...@gmail.comwrote: If the hardware on master and slave, version of mysql server, configuration and memory allocations are same then you can do a clean shutdown of mysql on slave and copy the files to master. Check if