CODEWITHSUNDEEP
mysqldatabaseubuntudatabase-backups
user5735796
user5735796

Reputation:

Unable to backup the databases

While trying to backup my database using the command:

mysqldump -u root -p root --all-databases > /var/www/html/temp/karooka.sql

all I get is the following in the sql dump:

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

What could be the reason for this?

Upvotes: 0

Views: 1372

Answers (1)

morre
morre

Reputation: 151

Don't specify the password in the command, use

mysqldump -u root -p --all-databases > /var/www/html/temp/karooka.sql

and enter the password when prompted.

Upvotes: 1

Related Questions