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]