How to Dump Content using Mysqldump
Contributed by vaiism 
Tagged: MySQL This command dumps the content of a database in MySQL to a text file. This will prompt for password of account used with ‘-p’
Here is the formatting of the command:
mysqldump -u [username] -p [database_name] > /path/to/file.sql
Example:
mysqldump -u fred -p FredsAddresses > /tmp/addresses.sql
You may also like -
MySQL dump import -> Error 1217
Symfony: Rebuild from Schema.yml Without Loss of Data
Drop or delete a table in MySQL
Create a MySQL database
MySQL - Daily database dumps, all nicely sorted.
Display a list of databases on a MySQL server
Select a MySQL database to use
Describe the column structure of a MySQL table