Legacy Application Modernization: Key Steps, Benefits & Best Practices
This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.
Create the Dump File:
mysqldump --user=<user> --password=<password> <database> --result-file=<file.sql>
Load the Dump File:
myql --user=<user> --password=<password> use <database> source <file.sql>
Create a Dump With Only CREATE Commands:
To create a dump in MySQL without the DROP commands or any other extra command, use this syntax:
mysqldump -u user -p --skip-opt database > dump.sql
External References:
http://www.howtoforge.com/back_up_mysql_dbs_without_interruptions (This is a script I have been using myself, also note down that site IF you are not familiar with it and care about linux).
This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.
This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.
Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...