restoring one table from a mysqldump --all

Is there an easy way to restore just one table from a mysqldump of all the tables? Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

RE: restoring one table from a mysqldump --all

On 28-Jun-01 Dave Brown wrote: Is there an easy way to restore just one table from a mysqldump of all the tables? If the (empty) table already exists: grep INTO table VALUES backup.dmp | mysql dbname If it doesn't then use awk to create it: awk '/^CREATE TABLE table/,/^);/' backup.dmp |