Current time: 11-25-2024, 09:45 PM Hello There, Guest! (LoginRegister)


Post Reply 
automysqlbackup: error 1044 database 'information_schema'
Author Message
Smallserver Offline
Junior Member
*

Posts: 38
Joined: Jan 2008
Reputation: 0
Post: #1
automysqlbackup: error 1044 database 'information_schema'
Hi all,

I get this error everyday:

mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

This error comes from automysqlbackup wich I use for making daily backups of my databases.

I've searched the internet but all I can find are old postings regarding an old bug in mysql. Since I use the latest version (server is a 2 month old install) that can not be the issue. I've had this error from day one, but not on the former installation.

Any hints?

Thanks,
Herman
01-03-2010 12:18 AM
Find all posts by this user Quote this message in a reply
kilburn Offline
Development Team
*****
Dev Team

Posts: 2,182
Joined: Feb 2007
Reputation: 34
Post: #2
RE: automysqlbackup: error 1044 database 'information_schema'
Ispcp has it's own backup system, so we don't support this automysqlbackup stuff. That said, I think that you've set it up with an incorrect password.
01-03-2010 04:58 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Smallserver Offline
Junior Member
*

Posts: 38
Joined: Jan 2008
Reputation: 0
Post: #3
RE: automysqlbackup: error 1044 database 'information_schema'
Then I have to look where those backups go, cause I did not know that.
Regarding the password, that one is not the problem, manually it goes.
But let's not discuss that here, thanks for your remarks!

Herman

(01-03-2010 04:58 AM)kilburn Wrote:  Ispcp has it's own backup system, so we don't support this automysqlbackup stuff. That said, I think that you've set it up with an incorrect password.
01-03-2010 05:16 AM
Find all posts by this user Quote this message in a reply
motokochan Offline
Member
***

Posts: 274
Joined: Jul 2008
Reputation: 1
Post: #4
RE: automysqlbackup: error 1044 database 'information_schema'
information_schema isn't a real database, it's virtual. You can't back it up.

Perhaps you need to update automysqlbackup to a version that supports MySQL 5.0 or higher?
(This post was last modified: 01-04-2010 01:45 PM by motokochan.)
01-04-2010 01:45 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)