It's actually rather easy to do through ssh:
Login to old host:
Commands:
First, dump the database to a file.
mysqldump database -uusername -ppassword > database.sql
then open an FTP session to your new host:
ncftp -uuser new-host
then put the file dump on the new server. Navigate to any appropriate directory first:
put database.sql
Exit twice, first to close the FTP session, and the SSH session:
exit
exit
ssh to new host (make sure the database actually exists!)
mysql database -uusername -p < database.sql
or simply mysql database -uusername -p
enter password
source database.sql
Login to old host:
Commands:
First, dump the database to a file.
mysqldump database -uusername -ppassword > database.sql
then open an FTP session to your new host:
ncftp -uuser new-host
then put the file dump on the new server. Navigate to any appropriate directory first:
put database.sql
Exit twice, first to close the FTP session, and the SSH session:
exit
exit
ssh to new host (make sure the database actually exists!)
mysql database -uusername -p < database.sql
or simply mysql database -uusername -p
enter password
source database.sql