首页 > 数据库技术 > 详细

MySQL修改数据引擎错误

时间:2018-03-05 11:57:59      阅读:319      评论:0      收藏:0      [点我收藏+]
1、缺少 组件
[root@MySQL support-files]# mysql_convert_table_format -uroot -p123456 -e MyISAM USER ABC
Can‘t locate DBI.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /application/mysql/bin/mysql_convert_table_format line 20.
BEGIN failed--compilation aborted at /application/mysql/bin/mysql_convert_table_format line 20.
解决:
[root@MySQL support-files]# rpm -qa|grep perl-DBD
[root@MySQL support-files]# yum install perl-DBD-MySQL -y 安装组件
2、无法连接到mysql
[root@MySQL support-files]# mysql_convert_table_format --user=root --password=123456 --engine=MyISAM oldboy ABC
Can‘t connect to database oldboy: Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)
解决(缺少sock参数):
vim /etc/my.cnf
socket = /application/mysql-5.5.32/tmp/mysql.sock
mysql_convert_table_format --user=root --password=123456 --sock=/application/mysql-5.5.32/tmp/mysql.sock --engine=MyISAM USER ABC

MySQL修改数据引擎错误

原文:http://blog.51cto.com/11037252/2082988

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!