MySQL Programming Question:

Download Job Interview Questions and Answers PDF

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

MySQL Programming Interview Question
MySQL Programming Interview Question

Answer:

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 mysqlin
>mysqldump -u root -r emplinks.txt test links
>type emplinks.txt

>type emplinks.txt | more
<pre>-- MySQL dump 10.10
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 5.0.24-community
...</pre>
The dump file contains SQL statements that you can use to restore the table and its data content.

Download MySQL Programming Interview Questions And Answers PDF

Previous QuestionNext Question
What Is "mysqldump"?What Is "mysqlimport"?