一:备份数据库:
mysql/bin目录下
mysqldump -q -uroot -p --add-drop-table --all-databases > 备份位置/all.sql
二:关闭数据库
三:删除表空间和redo日志
ibdata1 ib_logfile0 ib_logfile1
删除非mysql自带的数据库
[root@localhost data]# rm -rvf bird
removed `bird/checking.frm'
removed `bird/Customer.frm'
removed `bird/Store_Information.frm'
removed `bird/db.opt'
removed `bird/Sales_Information.frm'
removed `bird/Geography.frm'
removed `bird/savings.frm'
removed directory: `bird'
[root@localhost data]#
四:在mysql配置文件中添加如下配置:
innodb_file_per_table = 1
五:重启mysql
六:恢复数据
mysql -uroot -p < ../backup/all.sql