Thanks Nils
Binay
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Binay Agarwal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 13, 2003 12:24 PM
Subject: Re: Reading table structure and data from sql file.
&
Hi Binary,
You could either make a new backup of only the table (see mysqldump manual).
mysqldump --help
Or you edit the backup file you have directly and save it under a new name and
use it.
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 13日 水曜日 03:13、Binay Agarwal さんは書きました:
> Hi everybo
t; From: "Nils Valentin" <[EMAIL PROTECTED]>
> To: "Binay Agarwal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, August 13, 2003 11:59 AM
> Subject: Re: Reading table structure and data from sql file.
>
> > Hi Binary,
> >
>
Hi everybody,
I have backed(backup.sql) up one Mysql database which contains 10 tables using
mysqldump.
Now I want to read just one table structure and it's data from backup.sql to another
database. How do i achieve it.
I have tried "mysql databasename < backup.sql" but it will populate
t; <[EMAIL PROTECTED]>
To: "Binay Agarwal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 13, 2003 11:59 AM
Subject: Re: Reading table structure and data from sql file.
> Hi Binary,
>
> You could either make a new backup of only the table (see
