When the mysqldump ran against all databases, the USE <db-name> command should have appeared above each section of that databases dump. Try using Perl or the head or tail Unix command to hunt down the Database you are dumping. Read all lines until the next USE <db-name> command.
Example: If you mysqldumped databases DB1, DB2 (copyright IBM), DB3, DB4, and DB5 and you want ot restore just DB3, locate the string "USE DB3" (say its line 200000) and "USE DB4" (say its line 250000). Copy lines 200000 to 250000 to another SQL script. Then run that new script. ----- Original Message ----- From: "waldo tumanut" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Tuesday, July 10, 2007 9:34:28 AM (GMT-0500) America/New_York Subject: How to restore 1 database from mysqldump of all databases Question: How do I restore 1 database from amysqldump of all databases? Obviously a newbie. I've searched the list but couldn't find the answer. Can someone help? Waldo Tumanut Database Analyst ------------------------------------------------------------ CONFIDENTIALITY NOTICE: This electronic mail transmission (including any accompanying attachments) is intended solely for its authorized recipient(s), and may contain confidential and/or legally privileged information. If you are not an intended recipient, or responsible for delivering some or all of this transmission to an intended recipient, be aware that any review, copying, printing, distribution, use or disclosure of the contents of this message is strictly prohibited. If you have received this electronic mail message in error, please contact us immediately by electronic mail at [EMAIL PROTECTED] and destroy the original and all copies of this transmission (including any attachments). Thank you. ------------------------------------------------------------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
