Thanks to all who have replied. Since this thread has evolved into
discussing the dump, I would like to ask the group what are their practices
for backup and recovery on Windows platform.
Waldo Tumanut
Database Analyst
"Mogens
Melander"
<[EMAIL PROTECTED] To
oft.dk> "Rolando Edwards"
<[EMAIL PROTECTED]>
07/10/2007 cc
06:25 PM "waldo tumanut"
<[EMAIL PROTECTED]
m>, mysql@lists.mysql.com
Subject
Re: How to restore 1 database
from mysqldump of all databases
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>
------------------------------------------------------------
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]
