MySQL Forums
Forum List  »  Backup

Re: Restore backup leaves one database with no access
Posted by: Rick James
Date: November 18, 2014 09:48AM

> mysql.sock to --all-databases?

I think they are talking about different things.

Your last example:
mysqldump ... > x | gzip ...
is not quite right. "> x" will redirect STDOUT to the file x. "| gzip ..." will redirect STDOUT to gzip's STDIN. You can't do both at the same time (unless you use the 'tee' command).

>> I am told mysql is already upgraded are you sure you want to run it again.

See the --force option.

Look in your .sql file -- you will see stuff going into mysql.users (and related tables) that relates to the GRANTs. It may also "DROP TABLE users", then proceed to "INSERT INTO users". This may be how you lost access.

Options: ReplyQuote

Written By
Re: Restore backup leaves one database with no access
November 18, 2014 09:48AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.