[Ilugc] Mysql database backup

  • From: srikrishna.innovations@xxxxxxxxx (krish)
  • Date: Thu, 7 Jul 2011 19:20:43 +0530

On Thu, Jul 7, 2011 at 6:51 PM, Vijay Kumar <vijayakumarnkdr at gmail.com>wrote:

Dear all,

I want to take backup mysql database through cron, I have executed this
command

/usr/bin/mysqldump -u root -p(xxxxx) king | gzip > /backups/king_`date
+%y_%m_%d`.gz

It shows this error -

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost'
(using
password: YES) when trying to connect



Try

/usr/bin/mysqldump -u ${MYSQL_USER} -p${MYSQL_PASS} --result-file
"${DUMP_DIR}/${db}.sql" --databases "${db}"

Dont forget to substitute variable names in the above command ^

-- 
krish

Other related posts:

  1. Home
  2. ilugc
  3. Archive
  4. 07-2011