mysql 备份

安装以下两个MYSSQL软件

安装后如下图

打开查询分析器可看到相关数据库

打开管理工具

--
-- Create schema landordb
--

CREATE DATABASE IF NOT EXISTS landordb;
USE landordb;

--
-- Definition of table `tb1`
--

DROP TABLE IF EXISTS `tb1`;
CREATE TABLE `tb1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `itemno` varchar(45) NOT NULL,
  `desca` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;

--
-- Dumping data for table `tb1`
--

/*!40000 ALTER TABLE `tb1` DISABLE KEYS */;
INSERT INTO `tb1` (`id`,`itemno`,`desca`) VALUES 
 (1,'1111','哈哈'),
 (2,'4444','哈哈2');
/*!40000 ALTER TABLE `tb1` ENABLE KEYS */;


--
-- Definition of table `tb2`
--

DROP TABLE IF EXISTS `tb2`;
CREATE TABLE `tb2` (
  `aaa` int(10) unsigned NOT NULL,
  `bbb` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `tb2`
--

/*!40000 ALTER TABLE `tb2` DISABLE KEYS */;
INSERT INTO `tb2` (`aaa`,`bbb`) VALUES 
 (1,'afdafd'),
 (10,'afkdafd'),
 (100,'afkdaufd'),
 (1100,'afkdaufd');
/*!40000 ALTER TABLE `tb2` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;