Help - Search - Members - Calendar
Full Version: I messed up my PSA mysql misc table
The Planet Forums > Control Panels > Plesk
tlchristensen
I was attempting to change the name of my host using the command:
update misc set val='whatever-you-want-to-call-your-server' where param='FullHostName';

Only I entered:
update misc set val='whatever-you-want-to-call-your-server'

So every thing in the misc table got renamed to my new servers name.

I was able to dump the psa mysql database and look at it in an editor. I know I can restore via the command line or by replacing the psa database. But I am not sure what all the settings or syntax should be in that table.

Can anyone copy that table, xxx out thesensitive stuff, and give me a reference point to restore? A couple of the parameters are a little tricky. I am using Plesk 6

Thanks, TLChristensen
4PSA
You can find daily backups of your psa database in /var/lib/psa. Just restore the latest version of misc.
tlchristensen
Thank you for the tip.
TL Christenesn
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.