关于MySQL Innodb数据库误删ibdata1后导致数据库表结构损坏
1.从idb文件中恢复数据,需要用到mysqkfrm工具,需要安装MySQL Utilities。
[root@caixin mysql]# tar -xvf mysql-utilities-1.5.5.tar.gz
[root@caixin mysql]# cd mysql-utilities-1.5.5
[root@caixin mysql-utilities-1.5.5]# python ./setup.py build
[root@caixin mysql-utilities-1.5.5]# python ./setup.py install
2.提取frm文件的表结构信息。
[root@caixin mysql]# service mysql stop
[root@caixin mysql]# /usr/bin/mysqlfrm --basedir=/usr/local/mysql --port=3306 --user=root /data/mysql/akjk1/ > test_frm.sql
[root@caixin mysql]# more test_frm.sql
# Spawning server with --user=root.
# Starting the spawned server on port 3306 ... done.
# Reading .frm files
#
# Reading the think_cache.frm file.
ERROR: The server version