I Need to migrate a MySQL Database of size 300 GB and its live environment only has 3 hours downtime to perform the task. Please advise me which backup and restore method will help me to do this activity effectively.
I have two methods in hand.
1. mysqldump backup of full Database.
2. Cold backup of mysql database directory to New server.
Database lies in a redhat cluster. Please advise me for any other effecient way to perform this activity?
Please sign in to leave a comment.