I need to move all databases from one server to another.
Can someone please give me the Step by step proccess.
I have root access to both servers.....
Both are *nix,

Thanks,
James

just tar them up and ftp them over, if its the same directory tree then just extract it to the correct place it needs to be and make sure the programs that interact with it are edited correctly.

If you are moving all the databases, should be as easy as moving the entire directory where the databases are stored. If you are refering to MySQL, they are usually stored under:
/var/lib/mysql

If that is the case, then you can simply scp the files over as follows:

scp -r /var/lib/mysql 0.0.0.0:/var/lib

Substitute the 0.0.0.0 for the IP of the target server.

you should copy /var/lib/mysql (assuming thats where db's are stored on your server).. over to the new server as so:-


Login via ssh onto Old server
cd /var/lib
scp -r mysql/ root@123.123.123.123:/var/lib/

(IP is second or new server)

You will be prompted for the root pass of new server, enter it and away you go.

:)