I have a Centos Linux instance with Amazon and I need to migrate my DB's to the instance. I have acesss to ssh on both ends. I have PHPMyAdmin on both ends but trying to import to MyAdmin on the Amazon side didn't work. The import was too large. Additionally, I want to do this server to server because it will take too long to do each DB from the desktop.
I prefer to do it via ssh if that is possble.
Please tell me how I can get this done.