1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

How can I upgrade the PSA database tables?

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by DanielVF, Nov 19, 2010.

  1. DanielVF

    DanielVF Guest

    0
     
    How do I go about upgrading just the psa database tables?

    I had a server hardware failure.

    The hosting company elected to give us a new box, with a newer version of plesk on it, and reattach the old hard drive as secondary drive. To get our customers up and running as fast as possible, I copied over /var/www/vhosts, /var/named, /var/qmail, /var/lib/mysql and few files in /etc. At this point the box is serving websites, dns, and email.

    What we don't have is Plesk working. Since the old psa database was for plesk 8.6.0, and the new server is running plesk 9.2.3, the mysql psa tables need upgrading. How do I go about upgrading these tables?
     
    Last edited by a moderator: Nov 20, 2010
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,539
    Likes Received:
    1,239
    Location:
    Novosibirsk, Russia
    Affiliate:
    https://plesk.com/?a_aid=59ae552b0731c
    Not sure that it is possible manually. Do not understand why you did not perform normal Plesk upgrade procedure?
     
  3. DanielVF

    DanielVF Guest

    0
     
    We didn't upgrade, because when we got the new server with the new version of plesk, the old server, with the old version of plesk was already dead.

    Can I just run the upgrade process on the new server, even though it already contains the latest RPM's etc? In this case will it just bring the database up to date? What command would I run?
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,539
    Likes Received:
    1,239
    Location:
    Novosibirsk, Russia
    Affiliate:
    https://plesk.com/?a_aid=59ae552b0731c
    Look at output of following commands:

    Not sure but maybe it will help.
     
  5. DanielVF

    DanielVF Guest

    0
     
    Thanks! Looks like the SQL statements that I need to run are here:

    /usr/local/psa/etc/db/psa_db_upgrade_860.sql
    /usr/local/psa/etc/db/psa_db_upgrade_900.sql
    /usr/local/psa/etc/db/psa_db_upgrade_920.sql
     
Loading...