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.
⇒ What Is "mysqlimport" Command in MySQL
⇐ What Is "mysqldump" Command in MySQL
2018-05-19, 1569🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...