WordPress.org

Ready to get started?Download WordPress

Forums

MySQL error, the database getting too big. (5 posts)

  1. Sweely
    Member
    Posted 5 years ago #

    I was running WordPress 2.7 yesterday, when you all of a sudden wasn't able to leave a comment. I had about 2000 comments on my blog. Then, you weren't able to leave a comment. When you tried to, you got redirected to my blogs 404 error-page. I decided to upgrade wordpress, from 2.7 to 2.8.

    I did so, and wrote in the exact database-name as I had before. It came to the installation and did not want to get installed.

    I went on searching for the problem and I found it.

    It was my databse. It was getting too large. It was 99999 KB large. One more KB and it was going to get over 10 MB. That was the problem, so I stupidly enough did not backup my database and I just deleted it and created a new one, with the exact name... and now everything is working.

    I'm using freehostia as my webhost. Is there anyway to permit the database file to grow bigger than 10 MB?

  2. whooami
    Member
    Posted 5 years ago #

    sure -- pay for hosting. you get what you pay for, and NO-ONE except your host has control over what your mysql limits are.

  3. Sweely
    Member
    Posted 5 years ago #

    I don't want to pay for hosting! My domain name already costs $30/year. Is there any webhost that offers a big database?

  4. mrmist
    Forum Janitor
    Posted 5 years ago #

    You're paying over the odds for the domain name, so if you find a reasonable web host maybe you can offset the cost by getting cheaper domain renewals.

    Anyway, if you really want free stuff, just google free mysql hosting and check some of the results.

  5. Samuel Wood (Otto)
    Tech Ninja
    Posted 5 years ago #

    10 MB seems rather large. How many posts do you have?

    You might be able to reduce the same of the database by running an optimize on the tables and/or deleting some old revisions and such. This plugin will let you remove revisions: http://wordpress.org/extend/plugins/revision-control/ and then optimizing the tables afetrwards will make the DB smaller.

    As for hosting and database packages, 10 MB is extremely tiny. Although for only $30 a year, I guess you get what you pay for. $30 a year is as close to nothing as you can get.

    To pick an example, GoDaddy's lowest cheap shared hosting offers 10GB of total space (web+databases) and 300GB of transfer for $5 a month. Add another $10 for the domain name and you're talking about $70-80 a year, which is *extremely* cheap for webhosting. I don't generally recommend GoDaddy's cheap plans, but even so, they ain't lying about space and bandwidth.

    So I'd recommend looking into upgrading. Even for something as low end as a personal website, I'd estimate $100 a year for hosting, if the site gets any traffic at all. For $30 a year, I'd say to look into the free hosting services instead and save yourself the trouble. Because you get what you pay for and you're not really paying for anything for $30 that you can't get for free.

Topic Closed

This topic has been closed to new replies.

About this Topic