How To Back Up A MySQL Database From a Command Prompt

I just upgraded my WordPress installation to 2.6.3 and have some tips for you future Googlers.

To back up your database from the command prompt, type:

mysqldump –user=username –password=password databasename > filename

Example:

mysqldump –user=foo –password=123456 foodb > foodb.bak

Advertisements

0 Responses to “How To Back Up A MySQL Database From a Command Prompt”



  1. Leave a Comment

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





%d bloggers like this: