1、创建超级管理员账号
GRANT ALL PRIVILEGES ON *.* TO "adminroot"@"localhost" IDENTIFIED BY "kunxu@game" WITH GRANT OPTION
1、抽取某个表的信息
mysqlbinlog --database=db_name--start-position=102655866 mysql1-bin.000312> restore.sql
2、导出SQL
grep -B3-w table_name restore.sql | egrep -v '^--$' > restore_table.sql