CMS Made Simple Forums

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!

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.

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