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

["Jake Smith" <jake@xxxxxxxxxx>]

>> >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.


mysqldump - look at mysql.com in the documentation

you can have it dump your database and then compress it like so:

mysqldump -uUsername -p dbname | gzip > dbname.gz


You would then upload that gz file to your raq3 and run:

gunzip < dbname.gz | mysql -uUsername -p dbname

Now the zipping is optional,

 but look at the documentation in mysql.com and you will see how to do multi
databases at one time,

oh you have to create the databases first on the raq 3,

hope that helps

jake