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

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.