mysql data migration procedure
Outline of what you want to do
DB migration (application migration)
from where to where
mysql5.(VPS) -> mysql5(EC2)
Why make the transition?
To use AWS environment
Estimation of DB data capacity
Confirmation of Dump Data Output Destination
Export Time Estimates
Exporting Data
data migration
rsync
Construction of DB to be migrated
DB Creation
mysql > createdatabase database name
Data Import
data consistency check
Difference between source and destination DBs
