|
If the versions of mysql are compatible on each server....
you can:
cd /var/lib/mysql
then use that scp command above I showed you and scp it over to the other server in the same place.
On the destination server, first do this:
mv /var/lib/mysql /var/lib/mysql_new_original
that moves the fresh install data out of the way
Next make the directory again:
mkdir /var/lib/mysql
(make sure the permissions are the same as the original mysql directory)
ls -la /var/lib/mysql_new_original will show you the proper permissions.
NOTE: before moving it over...
stop mysql on both servers... typically:
service mysqld stop
|