惨了，升级mysql5.5，启动不了了
按admin的方法，wget http://down.wdlinux.cn/in/[b][color=#FF0000]mysql[/color][/b]_up55.shsh [b][color=#FF0000]mysql[/color][/b]_up55.sh
然后 改写mysqld
basedir=/www/wdlinux/[b][color=#FF0000]mysql[/color][/b]
datadir=/www/wdlinux/[b][color=#FF0000]mysql[/color][/b]/var
然后
。。。。。
150519 21:47:08 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql/var
/www/wdlinux/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
150519 21:47:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
150519 21:47:08 InnoDB: The InnoDB memory heap is disabled
150519 21:47:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150519 21:47:08 InnoDB: Compressed tables use zlib 1.2.3
150519 21:47:08 InnoDB: Initializing buffer pool, size = 2.0G
150519 21:47:08 InnoDB: Completed initialization of buffer pool
150519 21:47:08 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
150519 21:47:08 mysqld_safe mysqld from pid file /www/wdlinux/mysql/var/west11237.pid ended
怎样处理呢？求大神指教 努力抢修以后
变成这样了
150520 07:11:59 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql/var
150520 7:11:59 InnoDB: The InnoDB memory heap is disabled
150520 7:11:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150520 7:11:59 InnoDB: Compressed tables use zlib 1.2.3
150520 7:11:59 InnoDB: Initializing buffer pool, size = 2.0G
150520 7:11:59 InnoDB: Completed initialization of buffer pool
150520 7:11:59 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB:150520 7:11:59 InnoDB: Error: Write to file ./ib_logfile0 failed at offset 0 0.
InnoDB: 1048576 bytes should have been written, only -1 were written.
InnoDB: Operating system error number 28.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: Error in creating ./ib_logfile0: probably out of disk space
150520 7:11:59 [ERROR] Plugin 'InnoDB' init function returned error.
150520 7:11:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
/www/wdlinux/mysql/bin/mysqld: Error writing file '/www/wdlinux/mysql/var/west11237-slow.log' (Errcode: 28)
150520 7:11:59 [ERROR] Could not use /www/wdlinux/mysql/var/west11237-slow.log for logging (error 28). 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.
/www/wdlinux/mysql/bin/mysqld: Disk is full writing './mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
/www/wdlinux/mysql/bin/mysqld: Retry in 60 secs. Message reprinted in 600 secs [root@west11237 ~]# df -h
文件系统 容量 已用 可用 挂载点
/dev/sda1 9.9G 9.7G 0 100% /
tmpfs 1.9G 0 1.9G 0% /dev/shm
/dev/sdb1 483G 62G 397G 14% /home
发现空间满了 解决了
一个是mysql目录最好放在home里，很容易占满空间
二是/var/lib/mysql/目录权限不正确，造成sock文件无法创建
还做了几个修改，见招拆招，在服务商客服帮助下搞定了。 楼主好样的。 学习了不错
页:
[1]