Is there a limit?

On my MySQL database I have 6 tables.

Could anyone please tell me is there a limit to the number of tables you can have in a database and is there also a limit to the mumber of records (rows) in a table?
I cannot find this information anywhere.

Many Thanks in advance.

I don't believe there is a limit... if there is then it will be astronomically huge enough not to worry about.

It's all about the filesystem it's on. see here http://www.mysqldeveloper.com/faqs/f...do=browse&id=7

After I added my 7th Table to my Database it crashed on me... I take off the 7th table and it worked great again.. Is it just me or is 6 the limit?

The only limit on the number of databases and tables is how many files you may be able to store in a directory.

When you create a database, MYSQL creates a directory in which to store the tables. Thus, the number of databases is limited by the number of subdirectories the OS can handle for the MySQL data directory.

For ISAM and MyISAM tables, each table in a database consists of 3 files. Therefore, the maximum number of tables you may define is limited by the number of files your operating system allows in a single directory, divided by 3. Other table types generally use only one file per table. Some temporary data will also be written to this directory, e.g. during table restructuring.

That said, some common sense is in order when you plan your database layout: Making the OS search through thousands of directory entries whenever a query is performed, is a bad idea.