Collections:
Dump a Table to a File with "mysqldump" Command in MySQL
How To Dump a Table to a File with "mysqldump" in MySQL?
✍: FYIcenter.com
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.
2018-05-19, 859👍, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Rela...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...