Thanks Bruce, very helpful. I set up SQLyog and successfully connected to the new server, but the administrator on the old server would not give me the IP address :(
Fortunately, the administrator pushed the data into the new databse himself and managed to transfer most (~90%) of the posts. It kept bailing out at the same point each time and he thought there may be a corrupted post or something, which may also have caused the problems in the straight copy we were doing. Anyway, it's up and running now and much faster (smiles all round).
However, smiles turned to frowns when the forums kept going down because of database connection issues.
Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.
Support Error Code:- err_mySQL_db_connection
File Name:- database_connection.asp
Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 5.1 Driver]Too many connections
The first time it went down, he increased the number of connections and it was OK. Then yesterday it was down again with the same issue. He fixed it by further increasing the number of connections...
Apologize for the delay. I have increased the MySQL max_connection to 2,000 connection.
And please add your script to close the MySQL database connection everytime it is not used anymore. Thanks.
My questions are: What is the correct number of connections for an active forum? Secondly, does the script close the database correctly? Any thoughts on how I can prevent it going down so often?
Thanks in advance.
Topic Options
Post Options
Thanks(0)
