mysql problem

only one database

[finlandrocks]

hi, i was wondering if there is a way to add virtual databases as i have only one database but want to use more than one script that uses databases.

my problem, 1 database, multiple scripts needing to use databases.

if i create the tables needed for another script within an existing database used by another script, is this possible and if so like wordpress modules, what issues might i come across and any solutions. i know theres free mysql services out there but would rather use my own database for all scripts.

any help much appreciated, simon

[LifeinAsia]

You can certainly have multiple scripts using the same database. (You can also have 1 script using multiple databases.)

If the scripts use the same set of table names (but you need different data in the tables), then you'll need to modify the scripts. But if Script1 uses tables A, B, & C, while Script2 uses Tables X, Y, & Z, then you should be fine.

[edited by: LifeinAsia at 5:08 pm (utc) on Mar. 31, 2009]