Webhost Answers.net

Although this question can’t be answered specifically, the answer depends on the hardware and operating systems running, and maybe even on the version of MySQL as MySQL upgrades, but generally you should be allowed somewhere at least above 2 gigabytes (GB).  Anything above this and your MySQL database is rather large, and a lot of times may even be dependent on the size that your hosting service allows (which could be less than 2 GB).

At this point, especially for basic websites this would be very hard if not almost impossible to achieve and could make backing up the database a little harder, but at the standard user level this is something that will not have to be worried about.  I have one site with hundreds of posts, and the MySQL database size is only about 3.6 MB, so you shouldn’t have a problem.  MySQL is very efficient in many areas including this one.  Some hosts, in particular free ones, may limit the size you may have to something like 10MB.

MySQL is a database software that allows a user to store lots of information that is easily retrievable using a scripting code such as PHP or another.  MySQL follows the standard SQL (“Standard Query Language“) structure and is relatively easy to learn (with some practice).  MySQL files can also be updated, changed, created and deleted easily and also provides quick access and connections when be called from a programming language such as PHP.

Most PHP hosts offer MySQL with their hosting packages, and this is by far the most popular database language in PHP/Linux environments, and is widely supported.  The best thing of all is it is free, (under GPL license) and can be downloaded and installed even on your home computer.