Sometimes you need to dump a single table from a mysql table and restore it somewhere else. Here's what you need:<\/p>\n
<\/p>\n
1. Dump the table (compress it so it will take shorter to transfer over the network)<\/p>\n
<\/p>\n
mysqldump -h <HOST> -u <USERNAME> -p <DATABASE> <TABLE> | gzip > <DUMP_FILENAME>.gz<\/p>\n
<\/p>\n
HOST is the hostname or IP address of the mysql server<\/p>\n
USERNAME is a user with access to the database and table<\/p>\n
DATABASE and TABLE are self explanatory<\/p>\n
DUMP_FILE is the name you want for the file containing the compressed dump<\/p>\n
<\/p>\n
2. Transfer the file where you need it to be, with "cp" or "scp"<\/p>\n
<\/p>\n
<\/p>\n
cp <DUMP_FILENAME>.hz folder\/new_name<\/p>\n
scp <DUMP_FILENAME>.hz user@machine:folder<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
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