资源描述：
《mysql备份恢复基础》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、基本语法，备份oldboy库mysqldump-uroot-poracleoldboy>/opt/oldboy_bak.sql[root@localhost~]#cat/opt/oldboy_bak.sql
2、grep-v^#
3、grep-v^$--MySQLdump10.13Distrib5.5.32,forLinux(i686)----Host:localhostDatabase:oldboy----------------------------------------------------------Serverversion5.5.32-log/*!40101SE
4、T@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT*/;/*!40101SET@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS*/;/*!40101SET@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION*/;/*!40101SETNAMESlatin1*/;/*!40103SET@OLD_TIME_ZONE=@@TIME_ZONE*/;/*!40103SETTIME_ZONE='+00:00'*/;/*!40014SET@OL
5、D_UNIQUE_CHECKS=@@UNIQUE_CHECKS,UNIQUE_CHECKS=0*/;/*!40014SET@OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0*/;/*!40101SET@OLD_SQL_MODE=@@SQL_MODE,SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
*/;/*!40111SET@OLD_SQL_NOTES=@@SQL_NOTES,SQL_NOTES=0*/;----Tablestructurefortable`course`-
6、-DROPTABLEIFEXISTS`course`;/*!40101SET@saved_cs_client=@@character_set_client*/;/*!40101SETcharacter_set_client=utf8*/;CREATETABLE`course`(`Cno`int(10)NOTNULLCOMMENT'课程号',`Cname`varchar(64)NOTNULLCOMMENT'课程号',`Ccredit`tinyint(2)NOTNULLCOMMENT'学分',PRIMARYKEY(`Cno`))ENGINE=InnoDBDEFAULTCHAR
7、SET=latin1;/*!40101SETcharacter_set_client=@saved_cs_client*/;----Dumpingdatafortable`course`--LOCKTABLES`course`WRITE;/*!40000ALTERTABLE`course`DISABLEKEYS*/;INSERTINTO`course`VALUES(1001,'linux中高级运维',3),(1002,'linux高级
架构师',5),(1003,'mysql高级Dba',4),(1004,'python',4),(1005,'javaweb开发
',3)
8、;/*!40000ALTERTABLE`course`ENABLEKEYS*/;UNLOCKTABLES;----Tablestructurefortable`sc`--DROPTABLEIFEXISTS`sc`;/*!40101SET@saved_cs_client=@@character_set_client*/;/*!40101SETcharacter_set_client=utf8*/;CREATETABLE`sc`(`SCid`int(12)NOTNULLAUTO_INCREMENTCOMMENT'主键',`Cno`int(10)NOTNULLCOMMENT'课
9、程号',`Sno`int(10)NOTNULLCOMMENT'学号',`grade`tinyint(2)NOTNULLCOMMENT'学生成绩',PRIMARYKEY(`SCid`))ENGINE=InnoDBAUTO_INCREMENT=61DEFAULTCHARSET=latin1;/*!40101SETcharacter_set_client=@saved_cs_client*/;----Dumpingdatafortable`sc`--LOCKTABLES`sc`WRITE;/*!40000ALTERTABLE`sc`
