database - MySQL import is incomplete -
i have sql file (6gb) result of mysqldump. want import new database on same server.
i needed change basic text references within db used sed make replacements in dumped sql file.
whenever import dumped sql file resulting database missing last several tables. frustrating because takes hour import sql file , problem near end of import.
does have suggestions why import stop @ same table every time?
this point @ import stops every time -- table never created.
-- table structure table `port_schemas` -- drop table if exists `port_schemas`; /*!40101 set @saved_cs_client = @@character_set_client */; /*!40101 set character_set_client = utf8 */; create table `port_schemas` ( `extension_id` int(11) not null, `version_id` varchar(20) not null, primary key (`extension_id`,`version_id`) ) engine=myisam default charset=utf8; /*!40101 set character_set_client = @saved_cs_client */; -- -- dumping data table `port_schemas` -- lock tables `port_schemas` write; /*!40000 alter table `port_schemas` disable keys */; insert `port_schemas` values (700,'2.5.4-2012-03-19'),(10056,'1.9.0'),(10075,'3.6.13546'); /*!40000 alter table `port_schemas` enable keys */; unlock tables;
Comments
Post a Comment