Everything is running. MySQL started but for websites they can not connect to the mysql database at all.
Error log does not show much. Only:
121025 8:39:49 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './catz_forum/catz_wvalid_tag.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue. 121025 8:39:49 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 121025 8:39:49 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './catz_forum/catz_wwlist.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue.
However, I do not see how this effects connecting?
[mysqld] default-storage-engine=MyISAM local-infile=0 symbolic-links=0 max_connections = 500 key_buffer = 64M myisam_sort_buffer_size = 32M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 2M read_rnd_buffer_size = 2M thread_concurrency = 8 table_cache = 1024 thread_cache_size = 50 wait_timeout = 1800 connect_timeout = 10 tmp_table_size = 32M max_allowed_packet = 160M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 16M query_cache_type = 1 [mysqld_safe] open_files_limit = 8192 [mysqldump] max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M
ls -la /home/mysql total 46392 drwxr-x--x 184 mysql mysql 12288 Oct 25 10:05 ./ drwx--x--x. 135 root root 4096 Oct 25 08:22 ../
UPDATE: Removed the errors, this is the .err file now:
121025 10:25:41 [Note] /usr/sbin/mysqld: Normal shutdown 121025 10:25:41 [Note] Event Scheduler: Purging the queue. 0 events 121025 10:25:41 InnoDB: Starting shutdown... 121025 10:25:41 InnoDB: Shutdown completed; log sequence number 3476957563 121025 10:25:41 [Note] /usr/sbin/mysqld: Shutdown complete 121025 10:25:41 mysqld_safe mysqld from pid file /var/lib/mysql/sub.host.com.pid ended 121025 10:25:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 121025 10:25:42 [Note] Plugin 'FEDERATED' is disabled. 121025 10:25:42 InnoDB: The InnoDB memory heap is disabled 121025 10:25:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins 121025 10:25:42 InnoDB: Compressed tables use zlib 1.2.3 121025 10:25:42 InnoDB: Using Linux native AIO 121025 10:25:42 InnoDB: Initializing buffer pool, size = 128.0M 121025 10:25:42 InnoDB: Completed initialization of buffer pool 121025 10:25:42 InnoDB: highest supported file format is Barracuda. 121025 10:25:42 InnoDB: Waiting for the background threads to start 121025 10:25:43 InnoDB: 1.1.8 started; log sequence number 3476957563 121025 10:25:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 121025 10:25:43 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 121025 10:25:43 [Note] Server socket created on IP: '0.0.0.0'. 121025 10:25:43 [Note] Event Scheduler: Loaded 0 events 121025 10:25:43 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.27-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
I still can't access websites.
EDIT BY RolandoMySQLDBA 2012-10-25 10:59 EDT
Please post the following information into the question:
From the Database:
SHOW ENGINES; SHOW DATABASES; SHOW VARIABLES LIKE 'dir';
From the OS:
ls -l /var/lib/mysql ls -l /home/mysql