[mysql] backup/restore a single table

Dump a single table to a SQL file:

mysqldump -uuser -ppassword dbName tableName > backup.sql

If you want to get or restore a single table from a large MySQL dump file you can use the following methods:
Using AWK
Using Ruby
Using Perl:

#!/usr/bin/perl -wn
  $table = shift @ARGV;
  $printing = 0;
$printing = 1 if /^create table $table\b/io;
exit if $printing && /^create table (?!$table)\b/io;
print if $printing;


perl gettablefromdump.pl tablename dumpfile.sql