MySQL Backup Techniques Using mysqldump and SELECT INTO OUTFILE
Backup Tools
The mysqldump utility can be used on both the client and server sides.
The SELECT INTO OUTFILE command is limited to writing data directly to the server side.
Backup by Table
a. Backing up a single table
mysqldump -uusername -p database table1 >tableback.sql
mysql> select * into outfile 'D:/someBookes/mysql/pracitce/mysql_ ...
Posted on Mon, 15 Jun 2026 16:53:52 +0000 by phatgreenbuds