Dump MySQL database to a file

The below will backup the database databasename on localhost

mysqldump --add-drop-table -u username -p databasename | gzip -c > archivename.sql.gz

Be the first to like this post.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Not published)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

Angus Miller