Dump a Table to a File with "mysqldump" Command in MySQL

Q

How To Dump a Table to a File with "mysqldump" in MySQL?

✍: FYIcenter.com

A

If you want to dump all rows in a table from the server to a file, you can use "mysqldump" with the "-f fileName" option as show in the following tutorial exercise:

>cd \mysql\bin
>mysqldump -u root -r \temp\links.txt test links
>type \temp\links.txt

>type \temp\links.txt | more
-- MySQL dump 10.10
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version       5.0.24-community
...

The dump file contains SQL statements that you can use to restore the table and its data content.

 

Administrator Tools for Managing MySQL Server

⇒⇒MySQL Database Tutorials

2016-10-16, 203👍, 0💬