[iKwak]

Hello there,

I been using CPanel for more than two years and I need to know something about MySQL.
I frequently use PHP and MySQL to install softwares for websites. My webhost offered 10 MySQL databases for my use.

So far, I have used up all 10 databases to install 10 programs (Wordpress, Invision Board, gallery scripts, and etc.).

I recently found out that I can install two programs using only 1 database! I can use the same database name and password and only alter the table name.



My question to you: Can I use only 1 MySQL database to install 3 different programs under one domain?
i.e. programmingtalk.com, programmingtalk.com/forums/ (vBulletin), programmingtalk.com/blog/ (Wordpress), and programmingtalk.com/books/ (some script) with 1 MySQL database


Thank you in advance.

[Wuiqed]

Of course, you can have an (I think) unlimited amount of tables in a database. The hardware in the computer will probably limit you before mysql does

On a side note: I only use one database per site I make. And I always give the tables a prefix like "forum_users", "forum_posts", "forum_threads", "blog_posts", "blog_comments" and so on. Try to organize your tables something like that and you won't get lost in PhpMyAdmin

[monkey123]

Originally Posted by Wuiqed

Of course, you can have an (I think) unlimited amount of tables in a database. The hardware in the computer will probably limit you before mysql does

On a side note: I only use one database per site I make. And I always give the tables a prefix like "forum_users", "forum_posts", "forum_threads", "blog_posts", "blog_comments" and so on. Try to organize your tables something like that and you won't get lost in PhpMyAdmin

Yes, I second that. My host only allows 1 database and I have 4 different things installed on it. I have a PHPBB forum, a gallery, a poll and a newsletter. just use prefixes like Wuiqed said.

[iKwak]

I appreciate the response guys. I never knew that! Now I do.