In regards to: http://serverfault.com/questions/442218/remounting-mysql-under-a-new-mount-point
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?
my.cnf:
[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
Permissions:
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
