Re: [cobalt-users] Move MySQL server from RAQ2 to RAQ3i

[David Sexton <dave.sexton@xxxxxxxxxxxx>]

Hans van Kilsdonk wrote:

> I need to move our MySQL server from a RAQ2 to a new RAQ3i. MySQL & PHP is
> installed, but now I need to move the databases from the RAQ2 to the RAQ3.

	Simple, use mysqldump..

	Firstly, create the new databases on the RaQ3 (mysqladmin create
dbname)

	Now, on the RaQ2, dump all your databases to SQL source:

		$ mysqldump dbname > dbname.dump.sql

	Transfer these files over to the raq3

	On the RaQ3, you can insert the data using:
	
		$ mysql dbname < 	dbname.dump.sql

	Now for the usernames & passwords:

	On the RaQ2:
	
		$ mysqldump mysql > mysql.dump.sql

	Edit the mysql.dump.sql and remove all the 'create table' statements.

	Move this file over and do

		$ mysql mysql < mysql.dump.sql
		$ mysqladmin reload

	I'm fairly certain that that's all that needs doing. This will have the
added bonus of cleaning up any wasted space in the ism and index files
also :)

	Good luck.


Dave	
-- 
David Sexton

Security Engineer
Sapphire Technologies Ltd.
Tel: +44 (0) 1642 702100
Fax: +44 (0) 1642 702119


-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily the company.  This message and any files transmitted with it are confidential and solely for the use of the intended recipient.  If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited.

Sapphire Technologies Ltd
http://www.sapphire.net