1. Missing components
[Email protected] 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.
Solve:
[Email protected] support-files]# Rpm-qa|grep PERL-DBD
[[email protected] support-files]# Yum install perl-dbd-mysql-y installation component
2. Unable to connect to MySQL
[Email protected] 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)
Resolve (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
MySQL modifies data engine errors
