I have 2 servers runnnig
One mandriva linux system, with the database on at the moment
and one fedora linux system which is where i want to put the database.
I would like a guide of how i would go about moving the database from one system to the other.
Either using MYSQL-administrator or just in the terminal window.
please give a detailed list as i have been trying to do this for some time and will probably be only something small. :)
Things i have tryed:
Connecting through MYSQL-administrator but i keep getting the error message"1045 access denied for user'admin@.............local'
Using the command "mysqldumo --databases db1" but i get erro code 2002 "cannot connect to local MYSQL server through socket '/var/lib/mysql/mysql.sock'
now i have checked this directory but there is nothing in there, should there be?
thanks for you time and help.