max Size of a Database?

[sip]

What is the maximum size of a single database file in mysql?
What is the maximum number of record can i have in a single database?
what is max number of field can i have in a single record.
Which is the best version of mysql 4 or 5?

Thanks in advance.

[ess]

Depends on a number of factors, check the following link...I believe it answers most of your questions.

http://dev.mysql.com/doc/refman/5.0/en/full-table.html

As for MySql4 vs MySql5...there is a number of improvements from 4 to 5. Check the following from MySQL website for more info.

http://dev.mysql.com/doc/refman/5.0/...-nutshell.html

Cheers,
Ess