PANIC> Tried to upgrade MySQL - Removed ALL psa related files

[BadenC]

After trying to install an update to mysql, I saw a stream of psa related files being deleated. Now, plesk is missing a bunch of files. What can I do? I have researched trying to reinstall psa, but no joy. Here what what I can share:

/sbin/service psa start
psa: unrecognized service

So psa is not really installed

/sbin/service httpd start
Starting httpd: Syntax error on line 88 of /var/www/vhosts/example.com/conf/13287818030.09460500_httpd.include:
Wrapper /var/www/cgi-bin/cgi_wrapper/cgi_wrapper cannot be accessed: (2)No such file or directory

So all of my domains are currently DOWN

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "select * from misc where param='version'"
returns:
+---------+--------+
| param | val |
+---------+--------+
| version | 010134 |
+---------+--------+

The version I use to have installed was 10.4

If this can be fixed, where do I begin? If not, is it possible to download all the databases? I am so lost and sick right now.

 

[VyReN LLC]

It sounds like your Plesk database is still there. That is...good, I guess. You're going to need to re-install Plesk, however you did it in the first place. If your host did it for you, they will probably only reprovision the server (reformat and start over).

Before re-installing you will need to grab dumps of all your databases, and that is just a pain in the *** via the command line. And frankly I don't know how to do that anymore. Did it once and it was a nightmare.

I think you will need to hire a professional familiar with Plesk, MySQL databases and the environment Plesk controls. If you just re-install Plesk, I would assume it will overwrite the old database. But even with the old database, all of the services need to be configured for each domain. From mail to the file structure.

If I were in your shoes, this is what I would do. It may not be the best way to solve your problem, but it will get you and your clients back online.

Get a new server. Setup each domain exactly as it was on the old machine (You do keep client records outside of Plesk, right?). Setup each database as well. Then kill your MySQL service. Copy the database files from the old machine to the new one (/var/mysql, if memory serves). Restart MySQL. Then copy each domain's files from the old server to the new one (httpdocs).

This is pretty much what I just got done doing to a Plesk install that the HDD got corrupted and wouldn't boot. Took us ~150 man hours to migrate 250 websites this way (This client did not have sufficient off-site backups). Maybe someone else here will have a better suggestion...but you're in a bad place right now.

Not that it matters, but I think what happened here is when you upgraded MySQL it first removed MySQL and it's dependencies...like Plesk. In the future, may I recommend you use the ART repo (Atomic Rocket Turtle, Google it) for future upgrades to a Plesk-based server. I just upgraded to MySQL 5.5 without so much as a hiccup and about 30 seconds of downtime for the database. But I also did a mirror backup of the server before starting.

If you walk away with anything from this -> Backup. Always.

I'm sorry I don't have a better fix, I understand the position you are in. It sucks...big time.