Dump a single table to a file in mysql.

For some reason I always find myself searching for a way to dump a single temp table out of mysql.

Backup a single table from the database:

mysqldump -u -p database_one table_name > /var/www/backups/table_name.sql

Restore the table into another database:

mysql -u -p database_two < /var/www/backups/table_name.sql

Installing and using MythTV: Checking prerequisites.

You must ensure that any firewalls (either hardware, or a software firewall installed by your distribution) will not block access to the ports that will be used by the MythTV clients and servers on the "inside" LAN. The ports for MySQL (TCP port 3306) and mythbackend (TCP ports 6543 and 6544) must be open. It is strongly recommended that you do not expose the MythTV and MySQL ports to the Internet or your "Outside" LAN.