mysql: Dumping single database table and restoring

Sometimes you need to dump a single table from a mysql table and restore it somewhere else. Here's what you need:   1. Dump the table (compress it so it will take shorter to transfer over the network)   mysqldump -h <HOST> -u <USERNAME> -p <DATABASE> <TABLE> | gzip >… Continue reading