Please advise on how to migrate my local mysql server to the cloud.
Currently I have a Fedora linux box and a NAS attached to it via ethernet. I believe the best way to go about it is :
- Take a mysqldump of all databases
- Create an amazon RDS instance and try to load from the created mysqldump
- Shift local connection to this instance
Am I on the right track ? How should I go about doing (1). I have a username and password based access to the mysql server and it has only 1 database. I tried to follow a few links on the net but the commands did not seem to work.
Is (2) even possible ?