MySQL修改数据引擎错误!

  • 时间:
  • 浏览:2

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

版权声明:本文内容由互联网用户自发贡献,版权归作者所有,本社区不拥有所有权,假如承担相关法律责任。并且 您发现本社区带有涉嫌抄袭的内容,欢迎发送邮件至:

进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容。