Shulou(Shulou.com)06/01 Report--

1. Missing components

[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.

Resolve:

[root@MySQL support-files] # rpm-qa | grep perl-DBD

[root@MySQL support-files] # yum install perl-DBD-MySQL-y installation component

2. Unable to connect to 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)

Resolution (missing sock parameter):

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.