dump failed! Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release.

  • tcl@cunotech.dk
  • 06/12/08
  • Offline
Posted: Tue, 2013-10-29 06:30

Hi,

when doing backups these errors are showing up:

Dumping MySQL database kb_montage .. .. dump failed! Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.

What to do?

This is running on a Ubuntu Linux 12.04.2 Webmin version 1.631 Virtualmin version : 4.01 pro


Howdy, Do you have the file

  • andreychek
  • 01/05/09
  • Offline
  • Tue, 2013-10-29 10:43

Howdy,

Do you have the file /root/my.cnf? And in it, do you see a pass= parameter?

If so, you may want to try changing that to the full password=.

-Eric


It seems to do the trick. But

  • tcl@cunotech.dk
  • 06/12/08
  • Offline
  • Tue, 2013-10-29 11:18

It seems to do the trick. But I haven't changed this file.

Ive only installed Ubuntu, and then Virtualmin?


Howdy, That file isn't used

  • andreychek
  • 01/05/09
  • Offline
  • Tue, 2013-10-29 14:53

Howdy,

That file isn't used by Virtualmin... something else likely installed that on your system.

If you didn't set it up manually, it's possible that some other package that was installed onto your system had set that up.

You should be able to rename, or delete, that file if you aren't using it though.

-Eric


also not working on Debian 7.6

  • chgerwig
  • 12/16/12
  • Offline
  • Thu, 2014-08-21 07:17

I have the same problem on Debian 7.6 - exact Debian 4.6.3-14 and I have no pass nor password in the my.cnf file which is stored in /etc/mysql Maybe the pass parameter is user in the backup script and should be corrected?

I use Virtualmin 4.09GPL

Regards, Christian


Howdy, Virtualmin's backup

  • andreychek
  • 01/05/09
  • Offline
  • Thu, 2014-08-21 10:49

Howdy,

Virtualmin's backup script doesn't pass in the "pass" parameter, and the issue you're seeing doesn't occur by default.

Do you happen to have a file named ".my.cnf" (note the "." on the front) in your /root? If so, could you try renaming it and then re-attempting the backup?

-Eric


GREAT! this solved my problem

  • chgerwig
  • 12/16/12
  • Offline
  • Thu, 2014-08-21 18:07

I just found the .my.cnf file in the root folder. Changed pass to password and the backups works.

Thank you for your quick help.

Regards, Christian