Codestance

PHP, Linux and Marketing Playground
  • Home
  • Articles
  • Resources
  • Tips
  • Tutorials
2013 Middax | Rainbow Newsletter
April 5, 2013 Comments

Automatic Database Manipulation And Migration Script – Part I

Smarter is better don’t you think?

Let’s imagine that we have bunch of MySQL databases which you need to migrate from one server to another and for every database you need at least 15 minutes.

Well, i had chance to transfer 99 websites from one server to another (99 of them, YES 99), and i was struggling with each database migration, which was overkill for me. Then i was thinking, if i need let say at least 5 minutes for every database this would be like 495 minutes for all, but if i make one simple bash script which will do all the work for me, then i would be done in 20 minutes max, so i made one simple script which i can share with you all. But … don’t be happy just yet.

Read More