How to Dump Content using Mysqldump

Posted by vaiism in 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

The Conversation

Follow the reactions below and share your own thoughts.