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]