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 backup file, but just restore a part of > it. > > Unfortunately mysqlimport doesnt work that way. It must have the tables name > as filename. > > I also don't remember havin seen that option with the mysql client. > > All I found was "-o, --one-database" which does what is says only one database > will be updated (default database). > > Seems like for now editing the backup file is the fastest solution (on a > command line). > > Best regards > > Nils Valentin > Tokyo/Japan > > > > 2003年 8月 13日 水曜日 03:54、Binay Agarwal さんは書きました: > > 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] > > -- > --- > 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]