Why don't you use the mysqldump program to dump only those tables you
want and not the entire database?
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Cheers,
--V
Buchibabu wrote:
Hi,
Please let me know how to extract few tables from a dump file, which is taken with
mysqldump. I know it
They dump files are just mysql CREATE TABLE and INSERT statements. You
can you a perl script to read the dump file line by line and switch
output files when it hits a 'CREATE TABLE tablename'
On Fri, 8 Oct 2004 23:14:07 +0530, Buchibabu [EMAIL PROTECTED] wrote:
Hi,
Please let me know how to
The actual problem is we maintain regular all-databases mysqldump.it is a
automated script and after taking complete backup we purged data later we
identified that some required data is missed in a particular table. so we
require restore of only that particular table. we tried extracting only
There is no MySQL-supplied utility for this purpose. Perl, awk, or some
other scripting language will have to be called into play.
--V
Anil Doppalapudi wrote:
The actual problem is we maintain regular all-databases mysqldump.it is a
automated script and after taking complete backup we purged
Anil Doppalapudi wrote:
The actual problem is we maintain regular all-databases mysqldump.it is a
automated script and after taking complete backup we purged data later we
identified that some required data is missed in a particular table. so we
require restore of only that particular table. we
On Friday 08 October 2004 20.39, Anil Doppalapudi wrote:
we want to know is
there any mysql utility to extract only specified table from entire dump
This script will probably mess up on binary data and stuff but it works fine
for plain text dumps... try mysqldumpgrep mysql user a_dump.sql.