Db_dump.sql取出指定create table和Insert into

1.从Db_dump.sql 备份文件中取 CREATE TABLE 表结构:


sed -e '/./{H;$!d;}' -e 'x;/CREATE TABLE `big_table`/!d;q' gamedb_1_20141117.sql 


2.从Db_dump.sql 备份文件中取INSERT INTO 语句:


cat gamedb_1_20141117.sql | grep --ignore-case 'INSERT INTO `big_table`' > ./big_table.sql


grep -v "INSERT INTO \`big_table\`" gamedb_1_20141117.sql > dump_big_table.sql