您的位置:程序门 -> 其他数据库开发 -> mysql/postgresql



linux上mysql数据库,比较急得问题。各位老大,多多帮帮忙,看看什么原因


[收藏此页] [打印本页]选择字色:背景色:字体:[][][]


linux上mysql数据库,比较急得问题。各位老大,多多帮帮忙,看看什么原因
发表于:2007-03-09 08:17:22 楼主
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/data

number   of   processes   running   now:   0
070309   08:41:19     mysqld   restarted

number   of   processes   running   now:   1
mysqld   process   hanging,   pid   13478   -   killed
070309   08:41:20     mysqld   restarted

number   of   processes   running   now:   1
mysqld   process   hanging,   pid   13509   -   killed
070309   08:41:22     mysqld   restarted

number   of   processes   running   now:   1
mysqld   process   hanging,   pid   13540   -   killed
070309   08:41:23     mysqld   restarted

number   of   processes   running   now:   1
mysqld   process   hanging,   pid   13571   -   killed
070309   08:41:24     mysqld   restarted

number   of   processes   running   now:   1
mysqld   process   hanging,   pid   13602   -   killed
070309   08:41:25     mysqld   restarted

number   of   processes   running   now:   1
mysqld   process   hanging,   pid   13633   -   killed
070309   08:41:27     mysqld   restarted

number   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   device

number   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   device

number   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   device

number   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   device

number   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   device

number   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]   aborting

070309     8:41:28   [note]   /usr/local/mysql/bin/mysqld:   shutdown   complete

070309   08:41:28     mysqld   ended

我现在,不知所措。各位老大,多多帮帮忙,看看什么原因。
发表于:2007-03-09 10:20:591楼 得分:0
老大帮帮忙啊
发表于:2007-03-09 14:32:012楼 得分:0
怎么没有人回答啊,着急啊!看样子这个问题难啊
发表于:2007-03-09 14:32:493楼 得分:0
同志们,都过来看看,
发表于:2007-03-09 15:21:424楼 得分:0
修改mysql5的my.cnf
中的
basedir
datadir
试试.
发表于:2007-03-09 18:26:535楼 得分:0
还是不行啊


快速检索

最新资讯
热门点击