So, my host is decommissioning the MySQL server that my WP installation(s) are using.
I have about 10 WP sites on this database server.
Worried about manually cloning the db's through PHPMyAdmin (eg screwing up) I went ahead and paid $197 for Backup Buddy. It does backups, migrations etc.
Sadly after buying and installing BackupBuddy (which looks great BTW) I found out that my host (Namesco) won't allow HTTP Loopback connections, which BackupBuddy needs to run the simulated cron jobs.
So two hundred bucks worse off and after a few weeks messing around with support teams for both BackupBuddy and Namesco I am now right back at the start, with the deadline for the DB decommissioning looming.
Can anyone explain in super simple steps how to copy my existing WP DB and import the data into a fresh new DB?
I have googled this to death but everyone seems to be dealing with migrating to a new host or domain, which I am not.