MySQL Forums
Forum List  »  Backup

Re: Restore backup leaves one database with no access
Posted by: marc fromm
Date: November 18, 2014 01:43PM

Thanks for the correction with the qzip.

I'm not sure what the force option would provide since the restore is not stopping on an error.

Is it possible to do a restore from a mysqldump --all-databases (or the mysql.sock as in my case) and exclude the actual mysql database so it doesn't alter the one on the other server, or is there necessary information in the mysql database about the user created databases? (assuming the only thing changing in the data in the user created databases).


Options: ReplyQuote

Written By
Re: Restore backup leaves one database with no access
November 18, 2014 01:43PM

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.