Re: Reading table structure and data from sql file.

2003-08-14 Thread Nils Valentin
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 mysqldump manual). mysqldump --help Or you edit the backup file you have directly and save it under

Re: Reading table structure and data from sql file.

2003-08-14 Thread Binay Agarwal
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 mysqldump manual). mysqldump --help Or you edit

Reading table structure and data from sql file.

2003-08-14 Thread Binay Agarwal
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

Re: Reading table structure and data from sql file.

2003-08-14 Thread Nils Valentin
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:13Binay Agarwal : Hi everybody, I

Re: Reading table structure and data from sql file.

2003-08-14 Thread Binay Agarwal
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, I see you want to use the original