Dump Content using mysqldump

Contributor Icon Contributed by vaiism Date Icon October 5, 2003  
Tag Icon Tagged: MySQL

Dump content of a database in MySQL to a text file.

Will prompt for password of account used with ‘-p’


mysqldump -u [username] -p [database_name] > /path/to/file.sql

Example: mysqldump -u fred -p FredsAddresses > /tmp/addresses.sql

Previous recipe | Next recipe |
 
  • diverdennis
    Add the -e option for extended insert statements. This will make running the sql dump much faster.

    Example: mysqldump -e -u fred -p FredsAddresses > /tmp/addresses.sql
blog comments powered by Disqus