tip@trylinux:~/blog$ cat dumping-a-single-record-or-query-in-mysql.md
# Dumping a single record or query in MySQL
Author: admin
Date: 2017-10-25 00:00:00

I usually use phpMyAdmin to dump my table to SQL, but sometimes it is easier to do it from the command line. Use the following syntax to dump a table to SQL.

mysqldump -p -e --no-create-info -r table.sql dbname table -w"id=1234"

Warning: The --add-drop-table will cause it to drop the existing table when you import.

You can import this with the command

mysql -p dbname < table.sql

EOF