Multiple tables versus multiple databases

[flugh]

Greetings,

I have an Access database that I'm trying to get migrated to MySQL. There are a few types of tables I currently have in the .mdb ('pay_*, inv_*, dat_*). I'm wondering if it's preferrable to keep the single database with multiple tables, or do multiple databases with the more 'data specific' tables in each? My high update/traffic tables are first the inv_*, then pay_*, then finally dat_* (which doesn't change much, except to add in new hires, new clients, etc). I also need to keep backup in mind, and possibly archiving (splitting off old stuff, say 1 year +, to an archive).

The server is Linux+MySQL 4.0.11a-gamma. Going to build a front-end for it all using PHP. However, I will probably also keep one desktop using an Access frontend and link the tables via ODBC, just for the sake of variety.

Any thoughts are appreciated!

----
JBR

 

[sleipnir214]

I think using multiple databases will simply complicate your code for no real benefit.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[flugh]

Thanks for the feedback sleipnir214. I reckon I'll keep it all on one database.

And congrats on the TipMaster of the week last week. You sure earned it! Thanks for all your tips!

----
JBR