Backing Up and Restoring Databases - Learning MySQL and MariaDB - page 350

--
-- Dumping data for table `conservation_status`
--

LOCK TABLES `conservation_status` WRITE;
/*!40000 ALTER TABLE `conservation_status` DISABLE KEYS */;

INSERT INTO `conservation_status` VALUES
(1,'Extinct','Extinct'),
(2,'Extinct','Extinct in Wild'),
(3,'Threatened','Critically Endangered'),
(4,'Threatened','Endangered'),
(5,'Threatened','Vulnerable'),
(6,'Lower Risk','Conservation Dependent'),
(7,'Lower Risk','Near Threatened'),
(8,'Lower Risk','Least Concern'),
(9,NULL,'Unknown');
/*!40000 ALTER TABLE `conservation_status` ENABLE KEYS */;

UNLOCK TABLES;

-- [ snip ]

/*!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-09-15 6:48:27

This dump file will restore the conservation_status table. I added a couple of
comment lines with [ snip ] to indicate that this is where I cut lines of text from the
original dump file. I also added some hard returns so that the lines would fit on the printed
page. Otherwise, this is exactly the way a dump file would look if we had backed up only
the conservation_status table.

This method works, but it can be tedious and you might accidentally delete a line you
shouldn't or include a line you shouldn't. Other methods to restore just one table are
covered in thenext sections.