How many tables is it ok to put in a db?

[poring]

I would like to know up to how many tables it is okay to put on a mysql db.
On this page: http://www.mysql.com/doc/en/Creating_many_tables.html they say it's not good to put too many of them, but they don't say how much is too many..

thanks

[bastien]

it suggests that you can use as many tables as you need to achieve the result of not duplicating data anywhere in the tables...

ie
you have a customers table with
id
name
address
contact info
etc

in a cart table or sales table
invoice id
product id(s)
customer id

in a users tables (for logins etc)
user id
password
username
customer id(if user becomes a customer, not always guaranteed)

but really there is no hard and fast rule. and as you build onto your site you will need to create new tables to handle additional info...

hth