MySQLDatabase Backup及增量備份

一.MySQL資料庫的備份1.建立測試資料庫create database xscj CHARACTER SET utf8  COLLATE utf8_general_ci;2.建立表create table student(Sno int(10) NOT NULL COMMENT '學號',Sname varchar(16) NOT NULL COMMENT '姓名',Ssex char(2) NOT NULL COMMENT '性別',Sage tinyint(2)  NOT NULL default '0' COMMENT '學生年齡',Sdept varchar(16)  default NULL  COMMENT '學生所在系別', PRIMARY KEY  (Sno) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;3.插入資料set names gbk;INSERT INTO student values(0001,'陸亞','男',24,'電腦網路');INSERT INTO student values(0002,'kqzj','男',26,'computerapplication');INSERT INTO student values(0003,'xiaozhang','男',28,'物流管理');INSERT INTO student values(0004,'脈動','男',29,'computerapplication');INSERT INTO student values(0005,'ydds','男',26,'電腦科學與技術');mysql> use xscjDatabase changedmysql> show tables;+----------------+| Tables_in_xscj |+----------------+| student        | +----------------+1 row in set (0.00 sec)mysql> select * from student;+-----+-----------+------+------+------------------+| Sno | Sname     | Ssex | Sage | Sdept            |+-----+-----------+------+------+------------------+|   1 | 陸亞    | 男   |   24 | 電腦網路       | |   2 | kqzj      | 男   |   26 | computerapplicat | |   3 | xiaozhang | 男   |   28 | 物流管理         | |   4 | 脈動      | 男   |   29 | computerapplicat | |   5 | ydds      | 男   |   26 | 電腦科學與技術 | +-----+-----------+------+------+------------------+5 rows in set (0.00 sec)

1 2 3 下一頁