Moving databases between one MySQL server and another isn’t always easy, especially if you’re migrating database servers from one server to another. Imagine for this tutorial that you want to take an entire MySQL setup and put it on another server. We will also be exporting all the user accounts too, very useful for instance if we have lots of websites in our database. This tutorial will show you how to do just that.
All posts tagged mysql
If we’ve got a whole pile of databases on a server, it’s possible that not all of them will change regularly. If we’re backing up with something like rsync it makes sense not to do a whole database dump which would mean big perpetually backups so lets backup our databases individually.