Backup and restore a single MySQL 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
BEGIN {
  $table = shift @ARGV;
  $printing = 0;
}
$printing = 1 if /^create table $table\b/io;
exit if $printing && /^create table (?!$table)\b/io;
print if $printing;

Invocation:

perl gettablefromdump.pl tablename dumpfile.sql