Not with that error.davss wrote: Usually the problem lies in wrong username and password in config.php.
On shared hosting there can be many many sites on one server. The total for that server is being hit.davss wrote:But there was no other people accessing the new server apart from myself (we changed the URL)?
How did you go about doing this?davss wrote:Basically, by default tables are MyISAM which means each time DB is read whole table gets locked hence no other operations could be carried out at the same time.
What we did was converted most tables to InnoDB that supports row locking apart from php_posts that has to stay MyISAM to support full text search.
Code: Select all
mysql -u DB_USERNAME -pDB_PASSWORD DB_NAME < YOUR_SQL_FILE.sql
MySQL fulltext indexes can only be used with MyISAM tables.
Does this work - I've been having trouble transferring to InnoDB so would like to know if this is *the* solution for the "Too many connections" bug?davss wrote:It worked for us and the same error never came back.