DreamHost recent made some cool changes to how they manage thier MySQL severs. I just sucessfully migrated 2 databases off of my old mysql server onto a new one, and in the process split one of the databases into 3 (which is what I wanted to do all along, but setting up seperate host names for each was kind of a pain) Now I can manage all of the databases I .. uhm … “use” … from one phpMyAdmin instance.
I even managed to switch which database my bad jokes page and my personal glue site (neither of which gets much traffic) are pointed to with no perceiveable interruption.
now – if I could only get off my ass enough to put the other sites that these databases are designed for together….