Posts Tagged 'mysqldump'

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