I've seen hosts offer this feature in many packages. It ranges from 1-5 DB for shared hosting.

The thing is i'm not too sure how many DB i need. My site deals with classified ads.

Can someone pls advise.

thanks

The number of mySql databases you needs depends on what you will be doing.

Typically, most people use one database per application. For example, they may use a database for each of the following:
forums
classifieds
file database
etc.

That is the simpliest form of usage. Remember that a database is really just a bunch of tables. Some applications allow you to use a table prefix to the table name such as forum_tablename. If all the applications you are using allow this, you could, in theory, use all of the above applications in the same database.

Originally posted by dandanfirema
The number of mySql databases you needs depends on what you will be doing.

Typically, most people use one database per application. For example, they may use a database for each of the following:
forums
classifieds
file database
etc.

That is the simpliest form of usage. Remember that a database is really just a bunch of tables. Some applications allow you to use a table prefix to the table name such as forum_tablename. If all the applications you are using allow this, you could, in theory, use all of the above applications in the same database.

Thanks for your help dan.

Does this mean that 1 DB is for my class ads and another for storing misc files (user profiles, pictures, etc...)?

thanks

Normally you don't store files, pictures etc in a database. Usually you might some sort of database that stored information about your pictures and files. If you want a sample of a db-based file site, give me a pm and I can show you one.