mysql data migration procedure


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



Construction of DB to be migrated

DB Creation

mysql > createdatabase database name


Data Import



data consistency check

Difference between source and destination DBs



WordPress Migration Process Steps (