Re: [cobalt-developers] move mysql

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Kai r. s., euroweb as" <kai@xxxxxxxxxx> wrote:
> Could anybody tell me how to move a complete (databases, user permissions,
> etc) mysql database from one raq4r to another raq4r. I have to reinstall a
> raq4 that's why I need this done.

You can either use mysqldump to create dumps of all of the databases, then
recreate them on the target server by doing:

mysql < dumpfile

or you can shutdown MySQL and then tar and gzip the MySQL data directory and
extract it on the target server.  If you're not creating regular dumpfiles
of your databases already it's a good idea to start now.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/