List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:July 10 2007 11:25pm
Subject:Re: How to restore 1 database from mysqldump of all databases
View as plain text  
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" <waldo_tumanut@stripped>
> To: mysql@stripped
> 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 emailnotification@stripped
> 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/mysql?unsub=1
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
> --
> 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.

Thread
How to restore 1 database from mysqldump of all databaseswaldo_tumanut10 Jul
  • Re: How to restore 1 database from mysqldump of all databasesRolando Edwards10 Jul
    • Re: How to restore 1 database from mysqldump of all databasesMogens Melander11 Jul
      • Re: How to restore 1 database from mysqldump of all databaseswaldo_tumanut11 Jul
Re: How to restore 1 database from mysqldump of all databaseswaldo_tumanut10 Jul
  • Re: How to restore 1 database from mysqldump of all databasesDwalu Z. Khasu10 Jul