search

sukria / Backup-Manager

Versatile yet easy to use command line backup tool for GNU/Linux. Suitable for desktop and servers.
http://www.backup-manager.org/
GNU General Public License v2.0
278 stars 91 forks source link

Invalid mysqldump option #64

Open cyber01 opened 8 years ago

cyber01 commented 8 years ago

The current version of MySQL (I work with 5.6) does not support the --defaults-extra-file using a password which is transmitted, resulting in a backup instead get "mysqldump: Got error: 1045:" Access denied for user ..... . "

Why not just use the standard option -p? such as: -p$BM_MYSQL_ADMINPASS

kissifrot commented 8 years ago

MySQL 5.6 supports this option ( manual ), does your password contain extended/reserved characters ?

cyber01 commented 8 years ago

Latin symbols + numbers, various register

P.S. The documentation did not find any mention of this option, at least for the mysqldump P.P.S. in what format to specify a list of databases? I need to selectively back up multiple databases. I tried by a space - making a backup copy of the first, stops on this (but the process is not interrupted)

kissifrot commented 8 years ago

Do you have a full debug output of the backup command?

BTW putting passwords in the command would make them visible in the process list, not that secure ;)

cyber01 commented 8 years ago

Regarding debug output - the process is going well (if you use -p instead of the default-extra-file), but after the completion of a backup database process is not completed (infinitely continues to reserve the database).

As for the password appear in the process list: I make a small script that cycle selects all the database names and reserves in each individual file, with the so-called mysqldump: mysqldump -uroot -p$ROOT_PASS $i > $DIR/$i.sql Do not pay attention to the variables, the password indicated earlier in the variable In the process list of: top / htop: http://puu.sh/lzt84/5f2d8e7784.png ps aux: http://puu.sh/lzt9k/ac7a54b42a.png

Password changes automatically on the "x", so do not agree with you that the password is visible in the processes

kissifrot commented 8 years ago

Well if you could provide a debug output with the original command (not the altered -p one), that would help.

cyber01 commented 8 years ago

Unfortunately, there is no possibility to check (no access to the server where installed). But it turned out like this: backup-manager -d -v He (backup-manager) tries to create a file ~ / .backup-manager.conf (file extension can not remember). It creates the file, writing in his section of the [client] and the password specified in the configuration file. He then tries to connect to mysql (mysqldump), eventually get access denied for user localhost using password yes Then the backup is stoped (since it is not able to connect to the database)