Hi Nils , Thanks for quick reply.
I know already about the selective Backup using mysqldump and then use it. But what i want is restoring the selective backup i.e restore just one table out of say 10 tabels structure and data. Binay ----- Original Message ----- 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, > > 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 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 the > > databasename with all the 10 tables present in backup.sql which i don want. > > > > Please help me out. > > > > Mysql verison : 3.23.52 > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
