本版FAQ中有此问题详细解答http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=3614
解决方案 »
- 求SQL语句处理办法
- 帮忙看下mysql的动态语句,不是很熟悉
- 天啊!linux 查询视图竟然用了16.40s
- 看看这个错误提示该怎么解决?
- MySQL如何实现定时任务?
- 最后10分了,求助一个问题:我如何用程序得知我的系统上是否安装了MYSQL,如果装了则如何获得它的版本号!
- windows下如何运行mysql
- 在mysql中显示返回同一表中一个编号和最大数量的记录,SQL语句怎么写?
- case when 中不认识别名?
- show full processlist 出现大量的mysql-connector-java-
- 关于auto increment的写法?
- 请问怎么修改mysql里的表啊?
---------------
1 kill -9 mysqld_pid
service mysqld stop
2 cp /var/lib/mysql /data
3 cp /etc/my.cnf /etc/my.cnfold
4 vi /etc/my.cnf
[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/data
...
5 service mysqld start
6 rm -f /etc/my.cnfold
rm -rf /var/lib/mysql // 若成功,执行这样两命令
-------------
1 kill -9 mysqld_pid
service mysqld stop
2 cp -r /var/lib/mysql /data
3 cp /etc/my.cnf /etc/my.cnfold
4 vi /etc/my.cnf
[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/data
...
5 service mysqld start
-------------------
运行 mysqladmin version 后出现以下错误提示:
mysqladmin: connect to server at 'localhost' failed
error: 'can't connect to local MySQL server throught socket '/var/lib/mysql/mysql.sock' (2)'
Chech that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!还有,我reboot系统时,stop MySQL 是 failed 的
-------------
1 ps -aux | grep mysqld
kill -9 mysqld_pid
service mysqld stop
2 cp -airx /var/lib/mysql /data // 注意不是/data/mysql
3 cp /etc/my.cnf /etc/my.cnfoldyymmdd
4 vi /etc/my.cnf
[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/data
...
[client] //此节为自己添加,非必须
# password=
port=3306
socket=/data/mysql/mysql.sock
# Here follows entries for some specific programs
5 vi /etc/rc.d/init.d/mysqld
datadir=/data/mysql
6 service mysqld start
7 mysqladmin version // 测试
8 rm -f /etc/my.cnfold
rm -rf /var/lib/mysql // 若成功,执行这样两命令