hi.

i'm currently hosted on featureprice.com o.O and i'm looking to move to a new host, the thing is. featureprice gave me only one mysql database, so for the past year, i've put everything on it, it's like running two forums, two movable types on different domains, um this other publishing software, and the cafelog-b2 thingy, among a whole other myriad of stuff that needs databases.

so i'm wondering when i move to my new host (which i'm still looking for) can i split all that stuff in to different databases, cuz a lot of the hosts are offering unlimited mysql databases,

do i need to do that mysql dump thingy (which i have NO idea what it mean)? or i need to do something else, if i want to seperate the database.

like i access my database with the phpMyAdmin thing.
and i have 148 files? tables? and i'd realllllllly like to seperate
the the files.

:P sorry. i'm totally clueless.
thanks again.

You might want to check and see if any of your apps have a backup feature built into them to seperate the tables out...otherwise it could get quite hairy.

so i would need to keep the current structure?

you can split them, but there will be a lot of work
you need to know the tables for each script
dump the tables separately, and then load them into their own db