recover table structure from .frm files with MySQL Utilities

Posted Jul 30, 2018 Updated Oct 17, 2022

By 2pc

1 min read

数据崩溃了，仅剩下.frm文件

python ./setup.py build
python ./setup.py install

恢复表结构

 mysqlfrm --diagnostic /var/lib/mysql/afsbak/y004_f_import_info.frm 

This post is licensed under CC BY 4.0 by the author.