mysqld dead but subsys locked Backup for future Safety: cp /var/lock/subsys/mysqld /root/mysqld than delete it rm /var/lock/subsys/mysqld then close all services that depends on mysql: service httpd stop and after that: service mysqld restart service httpd restart
Try to add this line in [mysql] in my.cnf max_allowed_packet = 16M
In the backup script the views are first created as tables which are then dropped at the end of the script as each view is being created, so it seems that an error occurs while creating the views at the end of the script. However when a view is created there is a user … Read more
If MySQL reports an error number 1005 from a CREATE TABLE statement, and the error message refers to error 150, table creation failed because a foreign key constraint was not correctly formed. Similarly, if an ALTER TABLE fails and it refers to error 150, that means a foreign key definition would be . Error: 1005 … Read more
Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR) Message: %s near ‘%s’ at line %d Error #1064 means that MySQL can’t understand your command. To fix it: Read the error message. It tells you exactly where in your command MySQL got confused. Check the manual. By comparing against what MySQL expected at that point, the problem is often … Read more
Error: 1008 SQLSTATE: HY000 (ER_DB_DROP_EXISTS) Message: Can’t dropp database ‘%s’; database doesn’t exist
MySQL Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) If you get a too many connections error,Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR), when you try to connect to the mysqld server, this means that all available connections are in use by other clients. To increase the concurrent connections what are allowed to connect to the server, change the max_connections … Read more