Search code examples
mysqlubuntuubuntu-server

MySQL dump does not properly dump

I first run the following command:

mysqldump -u root -p password --all-databases > dump.sql

Then when I run nano dump.sql I get the following.

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

I am not sure if this is right or if I am running the command wrong or something.

Solution

  • From mysqldump docs

    If you use the short option form (-p), you cannot have a space between the option and the password