Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysqldump information_schema - error
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Sun Dec 11, 2011 8:08 pm    Post subject: mysqldump information_schema - error Reply with quote

Is is possible to dump mysql information_schema database?

I'm restoring mysql on a new server, and to speedup the process I was trying to dump all databases including configuration, password etc. to a new server but I'm getting an error:
Code:
mysqldump -u root -pxxxxxx --databases information_schema asteriskcdrdb catalog_sys phpmyadmin > all_db.sql
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

_________________
#Thelma
Back to top
View user's profile Send private message
nixnut
Bodhisattva
Bodhisattva


Joined: 09 Apr 2004
Posts: 10974
Location: the dutch mountains

PostPosted: Sun Dec 11, 2011 8:38 pm    Post subject: Reply with quote

Maybe this helps
_________________
Please add [solved] to the initial post's subject line if you feel your problem is resolved. Help answer the unanswered

talk is cheap. supply exceeds demand
Back to top
View user's profile Send private message
Mad Merlin
Veteran
Veteran


Joined: 09 May 2005
Posts: 1155

PostPosted: Wed Dec 14, 2011 12:01 am    Post subject: Reply with quote

It doesn't make any sense to dump/restore information_schema, because you can't write to those tables, they're generated on the fly by MySQL so you can query database schema with SQL instead of trying to parse "show tables", etc.

Try --all-databases instead of listing them all manually.
_________________
Game! - Where the stick is mightier than the sword!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum