MySQL Data migration from one server box to another

  Here’s a quick way to move data from one MySQL server to another Let source box be ServerOne, and the target box be ServerTwo. (user-names and schema names are indicative) – On ServerOne, mysqldump -u username -p db_name > data-dump.sql  (provide password when asked) scp data-dump.sql serverTwoUsername@ServerTwo:~/ On ServerTwo mysql -u username -p create […]

Continue reading →