I have a huge database approx 200GB (Some tables are more than 25GB in size).
We are willing to migrate to MySQL RDS Instance.but as it does not provide any ssh access so we can't copy file system over there(Like backup taken from Hot backup tools).
we will have to take the dump using
mysqldump but it may take days to complete the backup and in same in restoring it into RDS.
As backup will lock the tables for a huge time so we will also require a long downtime.
How Can we do it Quickly?I am looking for Quick and dirty solution? Also What are the limitation of the RDS Instance?