backing up SQL database not working ?

[exxos]

Code: Select all

mysqldump -u [user] -p [password] --all-databases > ./backup/all_databases.sql

This create this sql file

Code: Select all

Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

Anyone know what I did wrong ?!

[czietz]

man mysqldump:

• --password[=password], -p[password]

The password to use when connecting to the server. If you use the
short option form (-p), you cannot have a space between the option
and the password.

[exxos]

I figured it out, it didn't like the brackets in the username, thought they were supposed to be there

[rpineau]

on command help, the bracket are here to show you the parameter is optional, they are not part of the command options, so [user] mean that you should replace [user] by the username .
If you don't specify it at all , it'll ask for it.