• ADADADADAD

    MySQL修改数据引擎错误[ mysql数据库 ]

    mysql数据库 时间:2024-12-03 10:30:11

    作者:文/会员上传

    简介:

    1、缺少 组件[root@MySQL support-files]# mysql_convert_table_format -uroot -p123456 -e MyISAM USER ABCCan't locate DBI.pm in @INC (@INC contains: /usr/local/lib6

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    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修改数据引擎错误.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: mysql数据引擎