<[EMAIL PROTECTED]
m>, mysql@lists.mysql.com
Subject
Re: How to restore 1 database
A quick script solution:
create a dump pr. table in .
#!/bin/bash
for tbl in `echo "use ;show tables;"|mysql -s -u -p`
do
mysqldump -u p db $tbl > $tbl.sql
done
and the other way:
cat | mysql -u -p
On Tue, July 10, 2007 15:47, Rolando Edwards wrote:
> When the mysqldump ran against all
On Tue, 10 Jul 2007 [EMAIL PROTECTED] wrote:
=>Thanks for your response, Rolando. I know all the DML to create the
=>database is in the mysqldump. I was looking for a command or command
=>options, if there are any, to extract the DML for the database, like what
=>you can do with mysqlbinlog.
=>
ts.mysql.com
Subject: Re: How to restore 1 database from mysqldump of all databases
When the mysqldump ran
When the mysqldump ran against all databases, the USE 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 command.
Example: If you mysqldumped datab
