db backup/restore issue

[Jonj1611]

Hi,

I installed 1.5 then the 2.0 upgrade then 2.02

No problems, all set up now, however when I go to either db backup/restore or backup database now I receive this error :-

Server: localhost
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

The thing is my site doesnt use localhost to connect to the mysql database I have to use something different, so how do I fix this problem or change it to the mysql server that I use? The one I use goes like this :

mysql25.myhostingcompany.com


Thanks
Jon

[jeronimo]

In your admin folder there you'll find backup/ee_backup_prefs/preferences.php

There you have to setup your database connection also.

[Jonj1611]

Hi,

Many thanks, I don't have a backup folder though?

Thanks
Jon

[Jonj1611]

Actually their is one in admin, will try that.

Thanks
Jon

[Jonj1611]

ok, edited the settings but it says Access denied for user, but these are the same settings that the site is running from, and the site runs fine. Odd

Jon

[Jonj1611]

I noticed this error in the installation check, not sure how to enter them manually :-

Tables
ERROR: ee_backup is MISSING!
ERROR: ee_backup_info is MISSING!

Jon

[Pekka]

I noticed this error in the installation check, not sure how to enter them manually :-

Tables
ERROR: ee_backup is MISSING!
ERROR: ee_backup_info is MISSING!

Jon

They will be added automatically the first time you actually use EE Backup.

[Jonj1611]

Hi,

Thanks for the help everyone, not too sure why the the database user is being refused even though I am using the same details for the site, will contact the server host and see if they know. Thanks again

Jon

[Pete]

Double check the username and password for the database user account. I had the same issue, but found that I had the username and password reversed in the script.

[Jonj1611]

Ok, will do, thanks.

Jon

[yosemite]

do you have phpMyAdmin through your hosting company? you can also back up the db through that.