mysql ?

[tak2mark]

I have set up a my sql database for the forum on my site.
I made the (mistake?) of using the same database for my web based email.

Is this ok? Should I start a new database for each service that requires one, or is it ok to run several services on one database?


Please help soon My site is new, but, it's growing quickly I want to take care of this issue? asap.

tx :)

[Nino]

There is really no reason why you can't use the same database for more than one application.
Someone with more expertise in MySQL would probably be able to better elaborate on this, but I don't think running multiple applications on the same database causes any resource problems (for most sites -- unless you're another Yahoo -- then you need dedicated everything with built in redundancies :) ).

Just remember when you install additional applications, you want to make sure they do not try to create tables in the database with the same name other applications are using.

I use one database and I've installed multiple applications without any problems. Each application I installed created tables with names that had specific prefixes (to ensure they would be unique in the database).

For ex., when I installed the PHPBB forum software it created tables with the prefix "phpbb_" (or something like that).

[Atomic-Design]

Just make sure that you won't need more then 3 users, and that you won't go over your query limit. :cool:

I've found 2 databases to be mainly an organizational thing.

[tak2mark]

ok, ... Let's say, I stop using one of my applications.

Can I remove changes made to the database?

[Nino]

If you can identify the tables that are associated to that application (as I mentioned in my previous post), then you can drop them from the database.
Then, if you delete the application's folder on the webserver, it will be as if you never installed the application.

To drop the tables, you can use a front end utility like MySql Control Center, or PHPMyAdmin, or one of the many other MySql utilities available out there.

Originally posted by tak2mark
ok, ... Let's say, I stop using one of my applications.

Can I remove changes made to the database?