Re: [cobalt-users] Moving a mysql database from one machine to another along with virtual site...

["Ken Marcus - Precision Web Hosting" <ken@xxxxxxxxxxxxxxxx>]

> I'm planning on decommissioning a RAQ and rebuilting it's OS, as we've
been having speed issues with the ASP problem I posted before (no-one seemed
able to help, so I'm simply rebuilding the machine now)...
>
> anyway, some of the sites have MySQL/PHP databases - what methods would
anyone recommend for moving said databases from one machine to another?
>
> I have phpmyadmin installed, and I was thinking of simply dumping the
database - ftp the file across to the destination box and creating a blank
database of the same name, then running the dumped output of phpmyadmin
backup - does anyone have any other/better solutions?
>
> As a side note - moving the site using cmuexport/import won't create any
problems with SSL certs will it?
>
> tia
>
> Greg Hewitt-Long

Greg,

This works for me on a raq4 usign the pkgmaster.com mysql install.
If the MySQL version is the same,  just
cd /home
tar czvpf mysql.tgz mysql

Then FTP that file to the new server and:
cd /home
/etc/rc.d/init.d/mysql stop
mv mysql mysqlold
tar xzvpf mysql.tgz
/etc/rc.d/init.d/mysql start

Or if you just have a couple of databases, use phpmyadmin to save a database
from one server, then create the database on the new server and use
phpmyadmin to browse to and read in the saved database. Very easy.


----
Ken Marcus
Precision Web Hosting
ken@xxxxxxxxxxxxxxxx
http://www.precisionweb.net