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, 1582🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...