EE failing to backup database during "ee site update"


#1

I’m trying to run sudo ee site update domain.com --wp --pagespeed and also sudo ee site update domain.com --wp --hhvm

I get the following when I check the logs.

root@domain:/var/www/domain.com# ee site update domain.com --wp --pagespeedEnter your name:
Enter your email:

PageSpeed is experimental feature and it may not work with all CSS/JS/Cache of your site.
You can disable it by passing --pagespeed=off later.
Do you wish to enable PageSpeed now for domain.com?
Type "y" to continue [n]:Not using Pagespeed for given site
y
Running pre-update checks, please wait...
Backup location : /var/www/domain.com/backup/03Jul2015123813
Backing up database 		[Fail]
Check logs for reason `tail /var/log/ee/ee.log` & Try Again!!!
root@domain:/var/www/domain.com# y
y: command not found
root@domain:/var/www/domain.com# sudo tail /var/log/ee/ee.log
2015-07-03 12:38:19,979 (INFO) ee : Backup location : /var/www/domain.com/backup/03Jul2015123813
2015-07-03 12:38:19,979 (DEBUG) ee : Copying file, Source:/etc/nginx/sites-available/domain.com, Dest:/var/www/domain.com/backup/03Jul2015123813
2015-07-03 12:38:19,980 (INFO) ee : Backing up database
2015-07-03 12:38:19,980 (DEBUG) ee : Running command: mysqldump domain_com > /var/www/domain.com/backup/03Jul2015123813/domain_com.sql
2015-07-03 12:38:19,991 (DEBUG) ee : Command Output: ,
Command Error: mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: NO)" when trying to connect

2015-07-03 12:38:19,991 (INFO) ee : [Fail]
2015-07-03 12:38:19,991 (DEBUG) ee : 'mysqldump failed to backup database'
2015-07-03 12:38:19,992 (INFO) ee : Check logs for reason `tail /var/log/ee/ee.log` & Try Again!!!

I’ve already checked ~/.my.cnf and the root password in there is the correct mysql root password.


#2

@adrianocorterea

logs infers that you have no .my.cnf file at ~/.my.cnf location so database backup is getting failed


#3

Hi @adrianocorterea

I hope your issue has been satisfactorily resolved, If not, please revert back or else this topic will be closed after a duration of 48 hours.

Thanks.


#4