Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

MySQL... how many DBs do you use?

Jun 13, 2002, 7:33 AM
oldmoney
User (431 posts)
oldmoney's avatar
Jun 13, 2002, 7:33 AM
Post #1 of 7
Views: 7151
Shortcut
Quote Reply
MySQL... how many DBs do you use?
I am just getting my proverbial toe wet with MySQL, and am only allowed one DB per account. I assume this won't be a problem, since even with multiple applications, each can have their own tables in the same DB even if they are not related, yes? Thanks in advance.

*edit* And is there any good reason to name the DB one way or another?

Last edited by:

oldmoney: Jun 13, 2002, 7:34 AM
Jun 13, 2002, 9:41 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 13, 2002, 9:41 AM
Post #2 of 7
Views: 6936
Shortcut
Quote Reply
Re: [oldmoney] MySQL... how many DBs do you use? In reply to
I have about 10 running on my server...but thats cos I own it Tongue When I was on shared hosting you could quite hapily live with one database. The main thing is to use 'prefixes' on your tables...like Links SQL does Tongue

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 13, 2002, 9:43 AM
Paul
Veteran (19537 posts)
Jun 13, 2002, 9:43 AM
Post #3 of 7
Views: 6953
Shortcut
Quote Reply
Re: [Andy] MySQL... how many DBs do you use? In reply to
>>but thats cos I own it<<

If you are talking about your dedicated server then no you don't own it Cool
Jun 13, 2002, 10:13 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 13, 2002, 10:13 AM
Post #4 of 7
Views: 6945
Shortcut
Quote Reply
Re: [Paul] MySQL... how many DBs do you use? In reply to
God Paul...you look too deep with everything! Tongue

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Last edited by:

Andy: Jun 13, 2002, 10:14 AM
Jun 15, 2002, 7:34 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Jun 15, 2002, 7:34 PM
Post #5 of 7
Views: 6885
Shortcut
Quote Reply
Re: [oldmoney] MySQL... how many DBs do you use? In reply to
oldmony,

Hi there.

I use four MySQL databases in my main site:

1) Stores LINKS SQL v.1.13 data and USERS table.
2) Stores Utility tables (like Country, State, etc.)
3) Stores Career Center data
4) Stores Forum data

Alex has posted the benefits and limitations of using multiple databases. In terms of data processing, it may be more efficient to have all your tables within one database, but as soon as you get used to SQL programming and constructs, you can use multiple databases with ease.

Hope this helps!
========================================
Buh Bye!

Cheers,
Me
Jun 15, 2002, 8:20 PM
oldmoney
User (431 posts)
oldmoney's avatar
Jun 15, 2002, 8:20 PM
Post #6 of 7
Views: 6909
Shortcut
Quote Reply
Re: [Stealth] MySQL... how many DBs do you use? In reply to
*edited*

Last edited by:

oldmoney: Jun 15, 2002, 8:59 PM
Jun 15, 2002, 8:32 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Jun 15, 2002, 8:32 PM
Post #7 of 7
Views: 6831
Shortcut
Quote Reply
Re: [oldmoney] MySQL... how many DBs do you use? In reply to
Private message sent...
========================================
Buh Bye!

Cheers,
Me