1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

A problem with an SQL database, anyone have an idea?

Discussion in 'PHP & Perl' started by The Joker, Aug 24, 2010.

  1. The Joker

    The Joker BANNED BANNED

    Joined:
    Apr 8, 2008
    Messages:
    308
    Likes Received:
    152
    Hello,

    I own a wordpress mu blog that gets a fair bit of traffic and is on the front page for a fairly competitive search term, now I was completely unaware my blog was going to get so many users and I used one Sql database for setting it up, and the website has started timing out every now and again because it is unable to connect to the database... I have tried exporting the database but it can't even load any tables when I try and get in via phpmyadmin.. I found out the database is 2gb in size and every day is getting bigger and bigger... I don't wanna have to go back to the beginning and delete all the blogs being used... prob some of your backlinks :) I've tried to use some scripts to export single tables out of the DB but they also time out cauz they are unable to connect... Anyone have any ideas how to extract it? If I can't get this fixed I will prob have to sell it then... even then I am unable to provide the DB lol...
     
    Last edited: Aug 24, 2010
  2. Skyjockey

    Skyjockey Newbie

    Joined:
    Aug 19, 2009
    Messages:
    41
    Likes Received:
    10
    You must have a problem in your php script somewhere.
    If you can post the code maybe someone can find it.
     
  3. tical525

    tical525 Newbie

    Joined:
    Jul 26, 2009
    Messages:
    19
    Likes Received:
    1
    Try this.

    If you have the privileges, edit /etc/my.cnf (mysql config) and set max_connections=1000

    If you can't do that, you might have to take the website down for a bit while you dump the database to a gz file.

    Good luck