Dump and restore a single table in MySQL

BySam

Dump

mysqldump db_name table_name > table_name.sql

Dumping from a remote database

mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql

Restore

mysql -u <user_name> -p db_name
mysql> source <full_path>/table_name.sql

or in one line

mysql -u username -p db_name < /path/to/table_name.sql

Dump and restore a single table from a compressed (.sql.gz) format

Dump

mysqldump db_name table_name | gzip > table_name.sql.gz

Restore

gunzip < table_name.sql.gz | mysql -u username -p db_name

Similar Posts

How to Check Apache Concurrent Connections in Linux Using netstat and ss Command?

BySam

What’s ss Command? ss stands for socket statistics. It is used to dump socket statistics about network/socket connections. It’s showing information similar to netstat, it works better and faster compared with netstat. It can display more TCP and state information than other tools. Since the ss command gets all the information directly from kernel space…

How to configure the passive ports range for ProFTPd on a Plesk server behind a firewall

BySam

Question How to configure the passive ports range for ProFTPd on a server behind a firewall? Answer Note: When configuring the passive port range, a selected port range must be in the non-privileged range (e.g., greater than or equal to 1024). It is strongly recommended that the chosen range should be large enough to handle…