I seem to be having quite a few problems with MySQL on my server 
First of all, my connections are not beign stopped. I'm getting 150 odd connections building up in the space of a few hours...and then getting the MySQL error saying I have to many connections. How would I go about stopping this, maybe restricting their max run time to 2 mins?
Another thing...when doing MySQLDumps, i get;
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table 'error_log' (Can't find file: 'error_log.MYD' (errno: 2))
and when trying to create new databases I get;
MySQL said: Can't create database 'new_ace_clipart'. (errno: 28).
Query: CREATE DATABASE new_ace_clipart
I've been trying to get these things fixed for about a week now...but still no success. Any help you can offer would be much appreciated :0
Thanks
Andy
First of all, my connections are not beign stopped. I'm getting 150 odd connections building up in the space of a few hours...and then getting the MySQL error saying I have to many connections. How would I go about stopping this, maybe restricting their max run time to 2 mins?Another thing...when doing MySQLDumps, i get;
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table 'error_log' (Can't find file: 'error_log.MYD' (errno: 2))
and when trying to create new databases I get;
MySQL said: Can't create database 'new_ace_clipart'. (errno: 28).
Query: CREATE DATABASE new_ace_clipart
I've been trying to get these things fixed for about a week now...but still no success. Any help you can offer would be much appreciated :0
Thanks
Andy