#hy000

[readyspace]

Too many connections – Control WebPanel Wiki Error on the website or in cwp: ERROR 1040 (HY000): Too many connectionsPHP Warning: mysqli_connect(): (HY000/1040): Too many connections…

[gfhost-blog]

MySQL: ERROR 1005 (HY000) at line 14: Can’t create table ‘example.tbl’ (errno: 150)

If you get an error

ERROR 1005 (HY000) at line 14: Can’t create table example.tbl (errno: 150)

it could be for at least two reasons. MySQL doesn’t allow//http://godfatherhost.com/cloud/index.html to create foreign keys for  a set of tables one of which doesn’t exist. To solve this restriction you can set SET foreign_key_checks to 0:

mysql> SET foreign_key_checks = 0;

And after you done with restoring you should enable it back:

mysql> SET foreign_key_checks = 1;

The second reason could be different data types //http://godfatherhost.com/dedicated/index.htmlof columns you trying to create constrain between. For instance, bigint(20) and bigint(21). So, keep it in mind.

More information on  FOREIGN KEY Constraints.

Tagged with: mysql