mysql移动数据存放目录及问题
131226 13:32:38 mysqld_safe mysqld from pid file /mnt/resource/mysqldate/pacteralinux.pid ended131226 13:56:18 mysqld_safe Starting mysqld daemon with databases from /mnt/mntsdc2formysql/mysqldata
2013-12-26 13:56:19 0 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 Plugin 'FEDERATED' is disabled.
2013-12-26 13:56:19 7837 InnoDB: The InnoDB memory heap is disabled
2013-12-26 13:56:19 7837 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2013-12-26 13:56:19 7837 InnoDB: Compressed tables use zlib 1.2.3
2013-12-26 13:56:19 7837 InnoDB: Not using CPU crc32 instructions
2013-12-26 13:56:19 7837 InnoDB: Initializing buffer pool,>
2013-12-26 13:56:19 7837 InnoDB: Completed initialization of buffer pool
2013-12-26 13:56:19 7837 InnoDB: Highest supported file format is Barracuda.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."doc_type"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."documents"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."menu_event_response_config"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."pictures"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."response_config"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."sys_function"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."sys_function_catalog"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."sys_orgnization"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."sys_role"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."sys_role_function"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."sys_user"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."sys_user_role"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."usr_chat_his"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."usr_message"', ignored.
2013-12-26 13:56:19 7fac674d7720InnoDB: 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 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 InnoDB: Tablespace open failed for '"weixin"."wx_config"', ignored.
2013-12-26 13:56:19 7837 InnoDB: 128 rollback segment(s) are active.
2013-12-26 13:56:20 7837 InnoDB: Waiting for purge to start
2013-12-26 13:56:20 7837 InnoDB: 5.6.14 started; log sequence number 2138639
2013-12-26 13:56:20 7837 Server hostname (bind-address): '*'; port: 3306
2013-12-26 13:56:20 7837 IPv6 is available.
2013-12-26 13:56:20 7837 - '::' resolves to '::';
2013-12-26 13:56:20 7837 Server socket created on IP: '::'.
2013-12-26 13:56:20 7837 Event Scheduler: Loaded 0 events
2013-12-26 13:56:20 7837 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.14'socket: '/mnt/mntsdc2formysql/mysqldata/mysql.sock'port: 3306Source distribution
2013-12-26 14:42:17 7837 IP address '182.151.205.254' could not be resolved: Name or service not known
页:
[1]