How to Save "Backup Records and Dump File" Into Text File in MySQL

In MySQL the database backups are stored as a large file and it is very necessary to backup our data. Here we have to show the backup data and export the tables into text files. The MySQL dump is used to quickly backup the MySQL database to text files.

In restoring the MySQL database or tables, we have to use the following commands.

Backup a selected table records into text file

It indicates the terminator by enclosing in a table with the where condition.

Command

mysql-> SELECT tablename, InStock, Category INTO OUTFILE 'Backup2.sql'
->   FIELDS
->   TERMINATED BY ','
->    ENCLOSED BY '*' FROM tables WHERE Category='Classical';

Backup records into a text file 

By the use of this command, records are converted into the text file.

Set OPTIONALLY ENCLOSED

Here we have to select the table into text file and set it to the optionally enclosed.

Location

The player text file is stored in the C drive and we find it as per this location.
                                                       

Set enclosed terminator on a table

We have to set the enclosed terminator, it is used for specifying the line termination. It is optional.

Escape sign

It works in standard mode but not in NO_BACKSLASH_ESCAPES mode.

Create dump file

Here we have to create a dump file by the use of the following command.

Location: The dump file 'player.DUMP' is stored in the C drive.

Dump data into a text file

Here we have to export dump data into a text file.

Location: In this figure we have to see that the location of the ' Players9.TXT ' file is stored in the C drive.

Resources

Here are some useful resources:

• Storing bulk tcp dump file into SQL Server 2005
• Automated Backup with NAnt
• SQL Server Backup file in standard Zip format
• FuliggineBackupper in C#
• Save PDF and MS Word File in C#