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我现在,不知所措。各位老大,多多帮帮忙,看看什么原因。
解决方案 »
- MySQL 还原后缀为.bak的数据库文件
- mysql求某段时间内的平均值问题求砖家指教.
- shell 脚本 如何调用带有参数的存储过程
- 怎样在MYSQL_RES中获得指定行的数据?
- 如何判断表存在?不存在则创建表?
- mysql创建存储过程不成功,求解答
- 求一条select语句!!!!!!!!
- 画了一个EER model,但是导出的SQL脚本有语法错误
- 建立一个C/S模式的应用,server端是否可以使用国外的某些免费空间?比如一些支持php/mysql的空间?
- MYSQL从库占用内存持续增高,不释放,项目服务器带宽波动较大
- 求救:phpmyadmin中显示表在使用中的情况
- 请教两个表之间的怎样建立条件关系问题
中的
basedir
datadir
试试.