1 缺少 组件
- [root@MySQL support-files]# mysql_convert_table_format -uroot -p123456 -e MyISAM USER ABC
- Cant 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
- Cant connect to database oldboy: Cant 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
来源: http://www.bubuko.com/infodetail-2516043.html