Hi All;
I have a script that generates nightly backups with mysqldump. It's run fine with MySQL4 but this week we updated to MySQL5.5 and now I get an error, "mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect"
The script runs fine when I run it at the command prompt (that is, as user "sc4arc") but I guess that mysqldump doesn't like user "nobody" knowing the secret password. Any suggestions on how to make this work?
Thanks!
Peter
I have a script that generates nightly backups with mysqldump. It's run fine with MySQL4 but this week we updated to MySQL5.5 and now I get an error, "mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect"
Code: Select all
#!/bin/sh
#
umask 077
DBNAME=sc4arc_wp55
DBPWRD=<password>
DBHOST=sc4arc-wp55.db.sonic.net
DBUSER=${DBNAME}-all
BACKUPDIR=${HOME}/Backup
BACKUPFILE=${BACKUPDIR}/Backup-DB55-`date +%y%m%d`.sql
if [ -r ${BACKUPFILE} ]
then
echo "File ${BACKUPFILE} already exists."
exit 1
fi
mysqldump -h ${DBHOST} -u ${DBUSER} -p${DBPWRD} ${DBNAME} > ${BACKUPFILE}
exit 0
Thanks!
Peter