An error occurred during the backup - seems to be wrong database user

S

schabotte

Verified User
Joined
Apr 19, 2007
Messages
22
This is the message I get. What is puzzling is that anything associated with "tesla" would be for a different user account than the one I'm backing up. This user account is thehisto. I also tried a backup for user account tesla and it worked fine.


I'm the admin on the machine so I can check/get any info that you might need to look at to suggest a solution...




Error while backing up database thehisto_aff
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'tesla_wp'@'localhost' to database 'thehisto_aff' when selecting the database

Error while backing up database thehisto_art
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'tesla_wp'@'localhost' to database 'thehisto_art' when selecting the database

Error while backing up database thehisto_blog
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'tesla_wp'@'localhost' to database 'thehisto_blog' when selecting the database

Error while backing up database thehisto_ebay
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'tesla_wp'@'localhost' to database 'thehisto_ebay' when selecting the database

Error while backing up database thehisto_ebay_research
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'tesla_wp'@'localhost' to database 'thehisto_ebay_research' when selecting the database

Error while backing up database thehisto_footer
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'tesla_wp'@'localhost' to database 'thehisto_footer' when selecting the database

Error while backing up database thehisto_lm
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'tesla_wp'@'localhost' to database 'thehisto_lm' when selecting the database

Error while backing up database thehisto_main
mysqldump error output: mysqldump: Got error: 1044: Access denied for user 'tesla_wp'@'localhost' to database 'thehisto_main' when selecting the database


Error Compressing the backup file /home/thehisto/backups/backup/home.tar.gz : /bin/tar: DBI-1.623: Cannot open: Permission denied
/bin/tar: Exiting with failure status due to previous errors
 
You posted under User-Level Difficulties but you appear to have access to multiple users. Hence the following question:

What kind of backup are you doing? Reseller Level, Admin Level, or User Level?

Jeff
 
Check for either of these files:
/root/.my.cnf
/home/thehisto/.my.cnf

and remove them if they exist.

John
 
Somehow this all did a bad thing.

I found one in both directories and removed them.

I then logged into directadmin as user thehisto and scheduled a backup.

After not getting a notification for a while, I logged out and attempted to login as admin to check running processes and was denied. IN fact, all my DA logins were denied.

I rebooted and that basically killed all the DA type functions (i.e. no websites, etc.)

I manually restarted httpd and got back websites.
I manually restarted DA but it doesn't give access
I manually restated mysql and it failed: ERROR! The server quit without updating PID file (/var/lib/mysql/server1.chabotte.com.pid)

I looked and saw that I didn't have a my.cnf in /etc so I copied an old version to that.

Then when I tried to start mysql again (using /etc/init.d/mysqld start), it got past that error but just keeps giving .... across the screen endlessly.

This gave me back the home page of DA but I still can't login and domain based DB functions aren't working.

I'm going to have my hosting company see if they can get it running again.
 
You probably have bin logging enabled in my.cnf and huge bin files, that's may cause mysql to take long time to load.

You should check for those files and remove them (with mysql stopped and only if you arent using mysql replication)

DA is not useing MySQL to start, so MySQL is not related to failed login, just for MySQL DB manage at user level.

Also, you should manually run dataskq in debug mode just after set a backup to see how is going.

Regards
 
Ya.. that is what the support folks at the hosting company found... except it was the backup files from a few days ago that has supposedly failed that were taking up the space. Anyways, I'm back up and running.
 
You must log in or register to reply here.
Back
Top