[solved]For multiple sites on the same server, should I...? <mysql question

[greenftechn]

I want the flexibility of being able to move sites without losing data from one server to another. When I create multiple sites on the same server, should I simply use a different table prefix for different sites, or should I create entirely separate databases? I'm not a mysql expert, but my initial hunch is that it makes little difference. My thinking is that exporting an entire database, or just those belonging to a particular site, identified by the prefix, are roughly equivalent. I could be wrong, and would like to know before I do a dozen more sites and somebodies needs moved. Portability may not be the only issue here. Performance might enter in as well. Thanks in advance!

[Peciura]

It would work either way.
If you are using phpMyAdmin make sure file is imported within php max_execution_time limit, or you can split big files into pieces.
I would keep  separate DBs for each site, because it takes just seconds to reimport sql files. And of course big/busy  sites should be on separate DBs.

[greenftechn]

Thanks. I think separate DBs are the best approach for modularity. Will do that from now on.