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

Problem after an upgrade in OS and Plesk

Discussion in 'Plesk for Linux - 8.x and Older' started by xcrap, Feb 16, 2006.

  1. xcrap

    xcrap Guest


    I have a dedicated server, the company who provided installed fedora and now we had to changed to CentOS so we could update the kernel and Plesk to the latest version.

    A backup was made of the entire server, we where using plesk 7.5.4 and now when trying to restore the backups we had the following problems

    First of all.. this one:
    Howerver i have two major problems that needs your help
    Restoring mysql database 'anfibios' ...ERROR 1064 at line 21: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5
    Restoring mysql database 'acores' ...ERROR 1064 at line 21: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 13

    All the databases of our domains couldn't be created. I think this has something to do with different mysql versions but i don't really know how to do now :(

    The other problem is that all the files and emails were recovered, the email is working but when trying to access domains i got the message saying... Forbidden Error.

    I don't have any ideia of how after that update this could get me this error, beside the mysql problems the recover went very well.

    Any help please ? :)
  2. wagnerch

    wagnerch Guest

    If you did a full backup then why are you having problems? Did you reinstall the OS and restore via psadump? Also if you had an newer version and downgraded mysql then you may want to upgrade mysql to the same version the dump was created with.

    You probably should strip off that CHARSET=latin1 unless you are using mysql 4.x (I believe).
  3. xcrap

    xcrap Guest

    The problem is that the OS has changed along with php, mysql and a updated plesk version.

    I don't know why, this happend me before when changing from mysql 3.?? to 4.?? but i still have mysql 3.23.58 so it's very strange.

    Anyway, the support in the hosting company don't know how to resolve this issue.

    My question is if there is any possibility to extract the sql from the dump file backup ? In the backup/restore pdf manual there isn't any mention to that.

    Any other ideia ?

    The second problem was resolved, it was a permission problem in some folders that lost the owernship of psaserv.