2台linux mysql a 机器 b 机器现在想法是 把a 机器的mysql的数据 物理 迁移搞到 b机器
（也就是 aj机器 的mysql 服务停掉之后copy数据到b 机器
之后在b机器的mysql服务停掉 数据复制完后 在重启mysqll的服务
）
但现在突然发现b机器有这个错误 ：：
有新错误
starting Mysql.manager of pid-file without updating.......不知道如何解决 ？
这个mysql server 感觉难度不大 。 ps -ef |grep mysql
回应为空 说明压根服务没有启动错路 登录日志 如下：：
100614 18:47:40 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100614 18:47:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibZGStar' (Errcode: 2
100614 18:47:40 InnoDB: Error: unable to create temporary file; errno: 28
100614 18:47:40 [ERROR] Plugin 'InnoDB' init function returned error.
100614 18:47:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/usr/sbin/mysqld: File '/var/log/mysql/slow-queries.log' not found (Errcode: 13)
100614 18:47:40 [ERROR] Could not use /var/log/mysql/slow-queries.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
100614 18:47:40 [ERROR] Unknown/unsupported table type: INNODB
100614 18:47:40 [ERROR] Aborting100614 18:47:40 [Note] /usr/sbin/mysqld: Shutdown complete100614 18:47:40 mysqld_safe mysqld from pid file /var/lib/mysql//localhost.localdomain.pid ended
100614 18:50:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
100614 18:50:10 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
100614 1100614 18:50:11 mysqld_safe mysqld from pid file /var/lib/mysql//localhost.localdomain.pid ended
100614 18:52:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100614 18:52:43 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100614 18:52:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibbbNoq6' (Errcode: 2
100614 18:52:43 InnoDB: Error: unable to create temporary file; errno: 28
100614 18:52:43 [ERROR] Plugin 'InnoDB' init function returned error.
100614 18:52:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100614 18:52:43 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/localhost.localdomain.pid' (Errcode: 2
100614 18:52:43 [ERROR] Can't start server: can't create PID file: No space left on device
100614 18:52:43 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
100614 19:06:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100614 19:06:34 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100614 19:06:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibpeF9hw' (Errcode: 2
100614 19:06:34 InnoDB: Error: unable to create temporary file; errno: 28
100614 19:06:34 [ERROR] Plugin 'InnoDB' init function returned error.
100614 19:06:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100614 19:06:34 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/localhost.localdomain.pid' (Errcode: 2
100614 19:06:34 [ERROR] Can't start server: can't create PID file: No space left on device
100614 19:06:34 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
100614 19:13:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100614 19:13:52 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100614 19:13:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibsnszpP' (Errcode: 2
100614 19:13:52 InnoDB: Error: unable to create temporary file; errno: 28
100614 19:13:52 [ERROR] Plugin 'InnoDB' init function returned error.
100614 19:13:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100614 19:13:52 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/localhost.localdomain.pid' (Errcode: 2
100614 19:13:52 [ERROR] Can't start server: can't create PID file: No space left on device
100614 19:13:52 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid end
（也就是 aj机器 的mysql 服务停掉之后copy数据到b 机器
之后在b机器的mysql服务停掉 数据复制完后 在重启mysqll的服务
）
但现在突然发现b机器有这个错误 ：：
有新错误
starting Mysql.manager of pid-file without updating.......不知道如何解决 ？
这个mysql server 感觉难度不大 。 ps -ef |grep mysql
回应为空 说明压根服务没有启动错路 登录日志 如下：：
100614 18:47:40 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100614 18:47:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibZGStar' (Errcode: 2
100614 18:47:40 InnoDB: Error: unable to create temporary file; errno: 28
100614 18:47:40 [ERROR] Plugin 'InnoDB' init function returned error.
100614 18:47:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/usr/sbin/mysqld: File '/var/log/mysql/slow-queries.log' not found (Errcode: 13)
100614 18:47:40 [ERROR] Could not use /var/log/mysql/slow-queries.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
100614 18:47:40 [ERROR] Unknown/unsupported table type: INNODB
100614 18:47:40 [ERROR] Aborting100614 18:47:40 [Note] /usr/sbin/mysqld: Shutdown complete100614 18:47:40 mysqld_safe mysqld from pid file /var/lib/mysql//localhost.localdomain.pid ended
100614 18:50:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
100614 18:50:10 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
100614 1100614 18:50:11 mysqld_safe mysqld from pid file /var/lib/mysql//localhost.localdomain.pid ended
100614 18:52:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100614 18:52:43 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100614 18:52:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibbbNoq6' (Errcode: 2
100614 18:52:43 InnoDB: Error: unable to create temporary file; errno: 28
100614 18:52:43 [ERROR] Plugin 'InnoDB' init function returned error.
100614 18:52:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100614 18:52:43 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/localhost.localdomain.pid' (Errcode: 2
100614 18:52:43 [ERROR] Can't start server: can't create PID file: No space left on device
100614 18:52:43 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
100614 19:06:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100614 19:06:34 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100614 19:06:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibpeF9hw' (Errcode: 2
100614 19:06:34 InnoDB: Error: unable to create temporary file; errno: 28
100614 19:06:34 [ERROR] Plugin 'InnoDB' init function returned error.
100614 19:06:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100614 19:06:34 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/localhost.localdomain.pid' (Errcode: 2
100614 19:06:34 [ERROR] Can't start server: can't create PID file: No space left on device
100614 19:06:34 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
100614 19:13:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100614 19:13:52 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100614 19:13:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibsnszpP' (Errcode: 2
100614 19:13:52 InnoDB: Error: unable to create temporary file; errno: 28
100614 19:13:52 [ERROR] Plugin 'InnoDB' init function returned error.
100614 19:13:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100614 19:13:52 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/localhost.localdomain.pid' (Errcode: 2
100614 19:13:52 [ERROR] Can't start server: can't create PID file: No space left on device
100614 19:13:52 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid end
100614 19:13:52 [ERROR] Can't start server: can't create PID file: No space left on device目录/var/lib/mysql下空间不够？?
查一下先。
但还是提示那个错omain.pid ended
100617 21:29:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100617 21:29:27 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
100617 21:29:27 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100617 21:29:28 InnoDB: Started; log sequence number 0 4838248
100617 21:29:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100617 21:29:28 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
chown -R mysql:mysql /... finished Thanks for iihero