A quick script solution: create a dump pr. table in <db>.
#!/bin/bash for tbl in `echo "use <db>;show tables;"|mysql -s -u <user> -p<password>` do mysqldump -u <user> p<password> db $tbl > $tbl.sql done and the other way: cat <tbl.sql>| mysql -u <user> -p<password> <db> On Tue, July 10, 2007 15:47, Rolando Edwards wrote: > 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] > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
