mysql移动数据存放目录及问题

yanqiufang

131226 13:32:38 mysqld_safe mysqld from pid file /mnt/resource/mysqldate/pacteralinux.pid ended　　
131226 13:56:18 mysqld_safe Starting mysqld daemon with databases from /mnt/mntsdc2formysql/mysqldata
　　
2013-12-26 13:56:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
　　
2013-12-26 13:56:19 7837 [Note] Plugin 'FEDERATED' is disabled.
　　
2013-12-26 13:56:19 7837 [Note] InnoDB: The InnoDB memory heap is disabled
　　
2013-12-26 13:56:19 7837 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
　　
2013-12-26 13:56:19 7837 [Note] InnoDB: Compressed tables use zlib 1.2.3
　　
2013-12-26 13:56:19 7837 [Note] InnoDB: Not using CPU crc32 instructions

　　
2013-12-26 13:56:19 7837 [Note] InnoDB: Initializing buffer pool,>　　
2013-12-26 13:56:19 7837 [Note] InnoDB: Completed initialization of buffer pool
　　
2013-12-26 13:56:19 7837 [Note] InnoDB: Highest supported file format is Barracuda.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/doc_type'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."doc_type"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/documents'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."documents"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/menu_event_response_config'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."menu_event_response_config"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/pictures'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."pictures"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/response_config'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."response_config"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/sys_function'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."sys_function"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/sys_function_catalog'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."sys_function_catalog"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/sys_orgnization'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."sys_orgnization"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/sys_role'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."sys_role"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/sys_role_function'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."sys_role_function"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/sys_user'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."sys_user"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/sys_user_role'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."sys_user_role"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/usr_chat_his'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."usr_chat_his"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/usr_message'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."usr_message"', ignored.
　　
2013-12-26 13:56:19 7fac674d7720  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.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Could not find a valid tablespace file for 'weixin/wx_config'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
　　
2013-12-26 13:56:19 7837 [ERROR] InnoDB: Tablespace open failed for '"weixin"."wx_config"', ignored.
　　
2013-12-26 13:56:19 7837 [Note] InnoDB: 128 rollback segment(s) are active.
　　
2013-12-26 13:56:20 7837 [Note] InnoDB: Waiting for purge to start
　　
2013-12-26 13:56:20 7837 [Note] InnoDB: 5.6.14 started; log sequence number 2138639
　　
2013-12-26 13:56:20 7837 [Note] Server hostname (bind-address): '*'; port: 3306
　　
2013-12-26 13:56:20 7837 [Note] IPv6 is available.
　　
2013-12-26 13:56:20 7837 [Note]   - '::' resolves to '::';
　　
2013-12-26 13:56:20 7837 [Note] Server socket created on IP: '::'.
　　
2013-12-26 13:56:20 7837 [Note] Event Scheduler: Loaded 0 events
　　
2013-12-26 13:56:20 7837 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
　　
Version: '5.6.14'  socket: '/mnt/mntsdc2formysql/mysqldata/mysql.sock'  port: 3306  Source distribution
　　
2013-12-26 14:42:17 7837 [Warning] IP address '182.151.205.254' could not be resolved: Name or service not known