Not the answer you need?
Register and ask your own question!

password in --defaults-extra-file

gilmcgrathgilmcgrath ContributorInactive User Role Beginner
I want to put the backup password in a defaults extra file, but I do not know the syntax for doing this. What do I use as the delimiter.

[WHAT IS THE DELIMITER]
password=password

Can someone tell me the syntax?

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    If you want to put backup user/pass in default extra file you can do like
    [client]
    user=user
    password=password

    FYI: For Innobackupex, defaults-file should have client section with above details and mysqld section with datadir option. i.e

    [client]
    user=user
    password=password

    [mysqld]
    datadir=/var/lib/mysql
  • davidchildersdavidchilders Contributor Current User Role Beginner
    niljoshi is correct - but I believe you may have extended or reserved characters in your password. If this is the case, use single quotes to delimit the password.

    [client]
    password='[email protected]!'

    I hope this helps . . .

    /David C.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.