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

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...

You must have a problem in your php script somewhere.
If you can post the code maybe someone can find it.

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