Accidentally Reinstalled MySQL

[Pauli Jokela]

Hey everyone,

I was about to try an openvz GUI called SolusVM, when I noticed that I'd started their install script on the wrong box.

Now my Plesk box has had MySQL reinstalled by the script and apparently it also removed all the users and databases.

I do have full backups from a month or two ago and then there's the daily mysql dumps for domains aswell.

My question is, how would I go about restoring MySQL to it's previous condition?

I'd have to get quite a few MySQL users back in there, not to mention the databases.

Just looking for the "right way" to do this, so I won't mess anything up (further than this).

Thanks in advance!

 

[IgorG]

You can try to restore databases from lates available mysql dumps with something like

mysql -uadmin -p`cat /etc/psa/.psa.shadow` < dump.sql

 

[Pauli Jokela]

Yes, I know this much, thought as I mentioned the whole MySQL installation is back to the defaults, so no admin users, no Plesk databases.

I can connect to it just fine when I'm not using a password, but what my question was referring to, was on how to get the users AND databases back? Do any of the database dumps contain the users?

 

[IgorG]

Users contain in 'mysql' database.

 

[Pauli Jokela]

Thank you! I recovered mysql.preupgrade.dump and then mysql.daily.dump and after rebooting mysqld, I can now access the panel again. Now all that's left are the extra databases that I need to recover.
Everything seems to be fine now, though.