All posts tagged mysql

Migrate MySQL Servers with Databases and Users

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.

Continue reading →

Backing Up All MySQL Databases Individually using Cron

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.

Continue reading →