linux上有两个mysql数据库,一个端口号3306(版本号4.1.16),一个是3316(4.0.8)。我现在需要安装mysql-5.0.27这个版本。以前的还不能删除,还有其它的系统在用。所以我先把端口号3306给停止了(mysqladmin -u root -p shutdown)。停止正常。然后我就安装mysql-5.0.27这个版本
gunzip < mysql-standard-5.0.27-pc-linux-i686-2.tar.gz | tar xvf -权限设置因为以前都设好了,所以我没有做任何操作。
直接启动mysql-5.0.27这个版本
mysqld_safe --user=mysql &
然后就出现以下错误[root@puppy bin]# mysqld_safe --user=mysql &
[1] 13424
[root@puppy bin]# Starting mysqld daemon with databases from /usr/local/mysql/dataNumber of processes running now: 0
070309 08:41:19 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13478 - killed
070309 08:41:20 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13509 - killed
070309 08:41:22 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13540 - killed
070309 08:41:23 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13571 - killed
070309 08:41:24 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13602 - killed
070309 08:41:25 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13633 - killed
070309 08:41:27 mysqld restartedNumber of processes running now: 2
mysqld process hanging, pid 13664 - killed
mysqld process hanging, pid 13664 - killed
070309 08:41:28 mysqld restarted
STOPPING server from pid file /usr/local/mysql/data/puppy.pid
070309 08:41:28 mysqld ended我又到log文件看了一下,如下。
070308 21:53:10 mysqld started
070308 21:53:13 InnoDB: Started; log sequence number 0 297238
070308 21:53:13 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070308 21:53:13 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 0
070308 21:53:14 mysqld restarted
070308 21:53:15 InnoDB: Started; log sequence number 0 297238
070308 21:53:15 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070308 21:53:15 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 1
070308 21:53:15 mysqld restarted
070308 21:53:16 InnoDB: Started; log sequence number 0 297238
070308 21:53:16 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070308 21:53:16 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 0
070308 21:53:16 mysqld restarted
070308 21:53:17 InnoDB: Started; log sequence number 0 297238
070308 21:53:17 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070308 21:53:17 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 1
mysqld process hanging, pid 13633 - killed
070309 08:41:27 mysqld restarted
070309 8:41:27 InnoDB: Started; log sequence number 0 297238
070309 8:41:27 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070309 8:41:27 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 2
mysqld process hanging, pid 13664 - killed
mysqld process hanging, pid 13664 - killed
070309 08:41:28 mysqld restarted
070309 8:41:28 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
070309 8:41:28 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070309 8:41:28 [ERROR] Aborting070309 8:41:28 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete070309 08:41:28 mysqld ended我现在,不知所措。各位老大,多多帮帮忙,看看什么原因。
gunzip < mysql-standard-5.0.27-pc-linux-i686-2.tar.gz | tar xvf -权限设置因为以前都设好了,所以我没有做任何操作。
直接启动mysql-5.0.27这个版本
mysqld_safe --user=mysql &
然后就出现以下错误[root@puppy bin]# mysqld_safe --user=mysql &
[1] 13424
[root@puppy bin]# Starting mysqld daemon with databases from /usr/local/mysql/dataNumber of processes running now: 0
070309 08:41:19 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13478 - killed
070309 08:41:20 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13509 - killed
070309 08:41:22 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13540 - killed
070309 08:41:23 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13571 - killed
070309 08:41:24 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13602 - killed
070309 08:41:25 mysqld restartedNumber of processes running now: 1
mysqld process hanging, pid 13633 - killed
070309 08:41:27 mysqld restartedNumber of processes running now: 2
mysqld process hanging, pid 13664 - killed
mysqld process hanging, pid 13664 - killed
070309 08:41:28 mysqld restarted
STOPPING server from pid file /usr/local/mysql/data/puppy.pid
070309 08:41:28 mysqld ended我又到log文件看了一下,如下。
070308 21:53:10 mysqld started
070308 21:53:13 InnoDB: Started; log sequence number 0 297238
070308 21:53:13 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070308 21:53:13 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 0
070308 21:53:14 mysqld restarted
070308 21:53:15 InnoDB: Started; log sequence number 0 297238
070308 21:53:15 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070308 21:53:15 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 1
070308 21:53:15 mysqld restarted
070308 21:53:16 InnoDB: Started; log sequence number 0 297238
070308 21:53:16 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070308 21:53:16 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 0
070308 21:53:16 mysqld restarted
070308 21:53:17 InnoDB: Started; log sequence number 0 297238
070308 21:53:17 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070308 21:53:17 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 1
mysqld process hanging, pid 13633 - killed
070309 08:41:27 mysqld restarted
070309 8:41:27 InnoDB: Started; log sequence number 0 297238
070309 8:41:27 [ERROR] /usr/local/mysql/bin/mysqld: Error writing file '/usr/local/mysql/data/puppy.pid' (Errcode: 28)
070309 8:41:27 [ERROR] Can't start server: can't create PID file: No space left on deviceNumber of processes running now: 2
mysqld process hanging, pid 13664 - killed
mysqld process hanging, pid 13664 - killed
070309 08:41:28 mysqld restarted
070309 8:41:28 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
070309 8:41:28 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070309 8:41:28 [ERROR] Aborting070309 8:41:28 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete070309 08:41:28 mysqld ended我现在,不知所措。各位老大,多多帮帮忙,看看什么原因。
中的
basedir
datadir
试试.