gz

MySQL backup and restore from command line

Dragan Eror's picture
mysql logo

Backup

Simple backup
mysqldump --opt -u[user] -p[pass] [database] > [filename].sql
  • [user] Your database username
  • [pass] The password for your database (note there is no space between -p and the password)
  • [database] The name of your database
  • [filename].sql The filename for your database backup
  • [--opt] The mysqldump option
You're settling for good when there's awesome.  Upgrade to Firefox 3.5!