-
-
Save trogwarz/34bb292c38e2916350cb to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* Gist created as answer to question in comments here: | |
* @see http://dba.stackexchange.com/questions/87121/why-mysql-imports-only-one-record-for-each-table#comment156392_87121 | |
*/ | |
-- MySQL dump 10.13 Distrib 5.5.40, for debian-linux-gnu (x86_64) | |
-- | |
-- Host: localhost Database: my_database | |
-- ------------------------------------------------------ | |
-- Server version 5.5.40-0ubuntu0.12.04.1 | |
/*!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 `cities` | |
-- | |
DROP TABLE IF EXISTS `cities`; | |
/*!40101 SET @saved_cs_client = @@character_set_client */; | |
/*!40101 SET character_set_client = utf8 */; | |
CREATE TABLE `cities` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
`main` tinyint(1) NOT NULL DEFAULT '0', | |
`country` int(11) unsigned NOT NULL DEFAULT '0', | |
`region` int(10) unsigned NOT NULL DEFAULT '0', | |
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
PRIMARY KEY (`id`), | |
KEY `idx_name` (`name`), | |
KEY `idx_region` (`region`), | |
KEY `idx_country` (`country`) | |
) ENGINE=InnoDB AUTO_INCREMENT=15789521 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
/*!40101 SET character_set_client = @saved_cs_client */; | |
-- | |
-- Dumping data for table `cities` | |
-- | |
LOCK TABLES `cities` WRITE; | |
/*!40000 ALTER TABLE `cities` DISABLE KEYS */; | |
INSERT INTO `cities` VALUES (6,0,4,5,'Балларат'),(7,0,4,5,'Бендиго'),/*... and so on thousands of items ... */,(15789520,0,582106,15789405,'Кингстон'); | |
/*!40000 ALTER TABLE `cities` ENABLE KEYS */; | |
UNLOCK TABLES; | |
/* | |
* Here bunch of same dump of tables and data for them. | |
*/ | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment