-
Notifications
You must be signed in to change notification settings - Fork 297
Mysqldump output
Diego Torres edited this page Jan 24, 2015
·
1 revision
# mysqldump -uroot test001 --no-autocommit --extended-insert=false --hex-blob=true
-- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: test001
-- ------------------------------------------------------
-- Server version 5.5.31-0+wheezy1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `test000`
--
DROP TABLE IF EXISTS `test000`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test000` (
`id` int(11) DEFAULT NULL,
`col01` bit(6) DEFAULT NULL,
`col02` tinyint(4) DEFAULT NULL,
`col03` tinyint(4) unsigned DEFAULT NULL,
`col10` bigint(20) DEFAULT NULL,
`col11` bigint(20) unsigned DEFAULT NULL,
`col15` double DEFAULT NULL,
`col27` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test000`
--
LOCK TABLES `test000` WRITE;
/*!40000 ALTER TABLE `test000` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test000` VALUES (1,0x21,-128,255,-9223372036854775808,18446744073709551615,-2.2250738585072014e-308,'0abcde');
/*!40000 ALTER TABLE `test000` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test001`
--
DROP TABLE IF EXISTS `test001`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test001` (
`id` int(11) DEFAULT NULL,
`col` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test001`
--
LOCK TABLES `test001` WRITE;
/*!40000 ALTER TABLE `test001` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test001` VALUES (1,NULL);
INSERT INTO `test001` VALUES (2,0x00);
INSERT INTO `test001` VALUES (3,0x01);
/*!40000 ALTER TABLE `test001` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test002`
--
DROP TABLE IF EXISTS `test002`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test002` (
`id` int(11) DEFAULT NULL,
`col` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test002`
--
LOCK TABLES `test002` WRITE;
/*!40000 ALTER TABLE `test002` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test002` VALUES (1,NULL);
INSERT INTO `test002` VALUES (2,-128);
INSERT INTO `test002` VALUES (3,0);
INSERT INTO `test002` VALUES (4,127);
/*!40000 ALTER TABLE `test002` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test003`
--
DROP TABLE IF EXISTS `test003`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test003` (
`id` int(11) DEFAULT NULL,
`col` tinyint(4) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test003`
--
LOCK TABLES `test003` WRITE;
/*!40000 ALTER TABLE `test003` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test003` VALUES (1,NULL);
INSERT INTO `test003` VALUES (2,0);
INSERT INTO `test003` VALUES (3,255);
/*!40000 ALTER TABLE `test003` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test010`
--
DROP TABLE IF EXISTS `test010`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test010` (
`id` int(11) DEFAULT NULL,
`col` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test010`
--
LOCK TABLES `test010` WRITE;
/*!40000 ALTER TABLE `test010` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test010` VALUES (1,NULL);
INSERT INTO `test010` VALUES (2,-9223372036854775808);
INSERT INTO `test010` VALUES (3,0);
INSERT INTO `test010` VALUES (4,9223372036854775807);
/*!40000 ALTER TABLE `test010` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test011`
--
DROP TABLE IF EXISTS `test011`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test011` (
`id` int(11) DEFAULT NULL,
`col` bigint(20) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test011`
--
LOCK TABLES `test011` WRITE;
/*!40000 ALTER TABLE `test011` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test011` VALUES (1,NULL);
INSERT INTO `test011` VALUES (3,0);
INSERT INTO `test011` VALUES (4,18446744073709551615);
/*!40000 ALTER TABLE `test011` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test015`
--
DROP TABLE IF EXISTS `test015`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test015` (
`id` int(11) DEFAULT NULL,
`col` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test015`
--
LOCK TABLES `test015` WRITE;
/*!40000 ALTER TABLE `test015` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test015` VALUES (1,NULL);
INSERT INTO `test015` VALUES (2,-1.7976931348623157e308);
INSERT INTO `test015` VALUES (3,-2.2250738585072014e-308);
INSERT INTO `test015` VALUES (4,0);
INSERT INTO `test015` VALUES (5,2.2250738585072014e-308);
INSERT INTO `test015` VALUES (6,1.7976931348623157e308);
/*!40000 ALTER TABLE `test015` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test027`
--
DROP TABLE IF EXISTS `test027`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test027` (
`id` int(11) DEFAULT NULL,
`col` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test027`
--
LOCK TABLES `test027` WRITE;
/*!40000 ALTER TABLE `test027` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test027` VALUES (1,NULL);
INSERT INTO `test027` VALUES (2,'');
INSERT INTO `test027` VALUES (3,'0');
INSERT INTO `test027` VALUES (4,'2e308');
INSERT INTO `test027` VALUES (5,'999.99');
INSERT INTO `test027` VALUES (6,'-2e-30');
INSERT INTO `test027` VALUES (7,'-99.99');
INSERT INTO `test027` VALUES (8,'0');
INSERT INTO `test027` VALUES (9,'0abcde');
INSERT INTO `test027` VALUES (10,'123');
/*!40000 ALTER TABLE `test027` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test029`
--
DROP TABLE IF EXISTS `test029`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test029` (
`id` int(11) DEFAULT NULL,
`col` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test029`
--
LOCK TABLES `test029` WRITE;
/*!40000 ALTER TABLE `test029` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test029` VALUES (1,0x00010203040506070809909192939495969798A9);
INSERT INTO `test029` VALUES (2,'');
/*!40000 ALTER TABLE `test029` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Table structure for table `test033`
--
DROP TABLE IF EXISTS `test033`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test033` (
`id` int(11) DEFAULT NULL,
`col` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test033`
--
LOCK TABLES `test033` WRITE;
/*!40000 ALTER TABLE `test033` DISABLE KEYS */;
set autocommit=0;
INSERT INTO `test033` VALUES (1,'test test test');
/*!40000 ALTER TABLE `test033` ENABLE KEYS */;
UNLOCK TABLES;
commit;
--
-- Temporary table structure for view `test100`
--
DROP TABLE IF EXISTS `test100`;
/*!50001 DROP VIEW IF EXISTS `test100`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `test100` (
`id` tinyint NOT NULL,
`col01` tinyint NOT NULL,
`col02` tinyint NOT NULL,
`col03` tinyint NOT NULL,
`col10` tinyint NOT NULL,
`col11` tinyint NOT NULL,
`col15` tinyint NOT NULL,
`col27` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
--
-- Temporary table structure for view `test127`
--
DROP TABLE IF EXISTS `test127`;
/*!50001 DROP VIEW IF EXISTS `test127`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `test127` (
`id` tinyint NOT NULL,
`col` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `test200`
--
DROP TABLE IF EXISTS `test200`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test200` (
`id` int(11) DEFAULT NULL,
`col` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test200`
--
LOCK TABLES `test200` WRITE;
/*!40000 ALTER TABLE `test200` DISABLE KEYS */;
set autocommit=0;
/*!40000 ALTER TABLE `test200` ENABLE KEYS */;
UNLOCK TABLES;
commit;
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = '' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER before_test200_insert
BEFORE insert ON `test200`
FOR EACH ROW set NEW.col = NEW.col + 1 */;;
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection = @saved_col_connection */ ;
--
-- Final view structure for view `test100`
--
/*!50001 DROP TABLE IF EXISTS `test100`*/;
/*!50001 DROP VIEW IF EXISTS `test100`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8 */;
/*!50001 SET character_set_results = utf8 */;
/*!50001 SET collation_connection = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `test100` AS select `test000`.`id` AS `id`,`test000`.`col01` AS `col01`,`test000`.`col02` AS `col02`,`test000`.`col03` AS `col03`,`test000`.`col10` AS `col10`,`test000`.`col11` AS `col11`,`test000`.`col15` AS `col15`,`test000`.`col27` AS `col27` from `test000` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
--
-- Final view structure for view `test127`
--
/*!50001 DROP TABLE IF EXISTS `test127`*/;
/*!50001 DROP VIEW IF EXISTS `test127`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8 */;
/*!50001 SET character_set_results = utf8 */;
/*!50001 SET collation_connection = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `test127` AS select `test027`.`id` AS `id`,`test027`.`col` AS `col` from `test027` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2014-10-02 22:14:10