How to setup mysqldump without password in cronjob

advertisement

mysql, mysql databaseIf you execute mysqldump manually, mysqldump will prompt you for password. If you setup mysqldump via cronjob, you need to find a solution to disable the password. I’ve setup mysqldump to backup my db via cronjob without password. All you need to do is just to add a file in your home directory and it will disable the mysqldump password prompting.

To setup mysqldump without password in Cronjob, follow the steps below:-

  • Start your terminal and login to your server
  • Create a .my.cnf file in the home directory
  • Copy the content below and replace with your mysql username and password.
  • Now change the file permission to 600 to prevent other user from reading it
  • Now you can try to execute mysqldump and system will not prompt you for password by now
  • To setup the cronjob

    Append the line below to your crontab and it will run mysqldump every night at 12:00am

* for more information on mysql backup, refer to how to backup mysql database

Related posts:

How to flush DNS cache in Linux / Windows / Mac
How to create mailing list in Thunderbird
How to show line number in vi / vim editor
How to do string replace (str_replace) in MySQL
How to create bootable Linux USB drive - UNetbootin
Symfony Filter: Change ForeignKey drop down to Text field
SVN: How to commit only modified files via command line
WordPress: How to open rss links in new window?






5 Responses to “How to setup mysqldump without password in cronjob”

  1. Brennero says:

    Thanks, simple and a life saver

  2. littleguy says:

    Excellent tutorial, thank you!

  3. Jody says:

    Great & simple post. Thanks.

  4. littleguy says:

    Excellent post, thanks!

  5. sivawut srithammawut says:

    This is very useful.

    Cheers,
    -Pipe

Leave a Reply