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

plesk not working after updating mysql 4.1

Discussion in 'Plesk for Linux - 8.x and Older' started by wonderworld, Aug 24, 2006.

  1. wonderworld

    wonderworld Guest

    i recently upgraded mySQL to 4.1 not knowing it would affect plesk so i didn't keep a backup although i still have the old mysql folder with me which has all the database and tables in it. i could recover the other database/tables by simply copy/pasting them in the new mysql root folder /usr/local/mysql/var.

    i tried to do the same thing with the psa database for plesk.. but i can't make it work. i think its to do with innodb or something. i can see the tables in the mysqlshell but when i try to select * in a table i get this error..

    mysql> select * from web_users;
    ERROR 1016: Can't open file: 'web_users.ibd' (errno: 1)

    the error where i am supposed to see the plesk CP is as follows...

    ERROR: Unable to query: Can't open file: 'misc.ibd' (errno: 1) 0: /usr/local/psa/admin/plib/common_func.php3:203 psaerror(string "Unable to query: Can't open file: 'misc.ibd' (errno: 1)") 1: /usr/local/psa/admin/plib/common_func.php3:390 db_query(string "select param, val from misc") 2: /usr/local/psa/admin/plib/class.Session.php:113 get_param(string "login_timeout") 3: /usr/local/psa/admin/auto_prepend/auth.php3:139 Session->Session()

    please guide me through a solution. i have been looking at a solution for 2 days now and haven't really got a solid answer. i have searched the forums as well...

    any help would be appreciated.

    and yes, i have uncommented the innodb codes in /etc/my.cnf files.

    thank you for you time.