Re: Restore backup leaves one database with no access

[Rick James]

> 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.