I've got a multi setup with one main and five subsites. Because my host cannot run MySQL 5 with their current software, they've created a bypass to allow Joomla (and soon WP) users to run their software requiring MySQL 5. They've got one server running MySQL 5 on which only they themselves can set up a database. So now I'm trying to find a way to copy my existing multisite database on another server to the new database that I'm going to need as soon as 3.2 is released. What would be the easiest way to do this?
Exporting/importing using the WP function does not sound much of an option. This would mean that I edit wp-config, install WP anew, probably loose my network, set it up again and import the exports.
Would it work when I use the Plesk database export and the PHPmyAdmin import or is this going to give problems due to different software?
Basically I need to copy my database to a database running on other software.