ได้เซอรเวอร์ มาใหม่ แรม 4 g ลง CentOs 5.4
ลง mysql 5.1.43 แล้วเกิด error ตามด้านล่างครับ
[root@snhosdatabase ~]# useradd mysql
useradd: user mysql exists
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# service mysql stop
mysql: unrecognized service
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# export TMP=/tmp
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# export TMPDIR=/tmp
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# rm -fr /var/lib/mysql
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# rm -f /etc/init.d/mysql*
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# rpm -ivh MySQL-shared-community-5.1.43-1.rhel5.x86_64.rpm --nodeps --force
Preparing... ########################################### [100%]
1:MySQL-shared-community ########################################### [100%]
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# rpm -ivh MySQL-client-community-5.1.43-1.rhel5.x86_64.rpm --nodeps --force
Preparing... ########################################### [100%]
1:MySQL-client-community ########################################### [100%]
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# rpm -ivh MySQL-server-community-5.1.43-1.rhel5.x86_64.rpm --nodeps --force
Preparing... ########################################### [100%]
******************************************************************
A MySQL server package (MySQL-server-community-5.1.43-1.rhel5) is installed.
The current MySQL server package is provided by a different
vendor (warning: cannot get shared lock on /var/lib/rpm/Packages
Sun Microsystems, Inc.) than MySQL AB or Sun Microsystems, Inc..
Some files may be installed to different locations, including log
files and the service startup script in /etc/init.d/.
Upgrading directly from MySQL <unrecognized version warning: cannot get shared lock on /var/lib/
rpm/Packages
5.1.43> to MySQL 5.1 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MySQL manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MySQL-shared-compat package.
- Install the new MySQL packages supplied by Sun Microsystems, Inc.
- Ensure that the MySQL server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MySQL manual, in the Upgrading section.
******************************************************************
error: %pre(MySQL-server-community-5.1.43-1.rhel5.x86_64) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping MySQL-server-community-5.1.43-1.rhel5
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# service mysql stop
mysql: unrecognized service
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]#
[root@snhosdatabase ~]# cp my.cnf /etc
cp: overwrite `/etc/my.cnf'
[root@snhosdatabase ~]#
หัวข้อ: ขอความช่วยเหลือครับ ลง MysQl ไม่ผ่าน (อ่าน 19931 ครั้ง)