MySQL Forums
Forum List  »  Backup

Problem Backup with Automatic Password - mysqldump
Posted by: Claudinei Silva
Date: August 26, 2016 03:21PM

Group

See who could help me in doubt below:

a) What could be going on in my routine mysql back up, because when I leave the password blank it asks for a password and it works without any problems.

c:\progra~1\mysql\mysqls~1.1\bin\mysqldump.exe -h 127.0.0.1 -u root -p --hex-blob --databases projeto > c:\bak_sis\backup\projeto.sql

b) But when I put the password, it does not work, giving the following message below.

c:\progra~1\mysql\mysqls~1.1\bin\mysqldump.exe -h 127.0.0.1 -u root -pgf%nm$kj@2 --hex-blob --databases projeto > c:\bak_sis\backup\projeto.sql


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

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem Backup with Automatic Password - mysqldump
1545
August 26, 2016 03:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.