mysql全备文件 恢复,mysql如何从全备文件中恢复单个库或者单个表

[root@pre ~]# sed -n '/^-- Current Database: `db_log`/,/^-- Current Database: `/p' all_database_bak_471_2017-12-04_15_36_38.sql > db_log.sql &

# 导入库中

[root@pre ~]# /home/mysql/mysql55_3310/bin/mysql -uroot -p < db_log.sql &

mysql> use db_log;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

+------------------------+

| Tables_in_db_log |

+------------------------+

| api_online_logs |

| onlinegame |

| onlinegame_gamestats |

| onlinegame_playerstats |

| onlinegame_type |

| osa_menu_url |

| osa_module |

| osa_quick_note |

| osa_sys_log |

| osa_system |

| osa_user |

| osa_user_group |

| sample |

| user_online |

| user_psw_audit |

+------------------------+

15 rows in set (0.00 sec)

mysql>

# 数据已经恢复了