PHP / MySQL Problem

Datcrack · Unread post by **Datcrack** » Sat Jun 03, 2006 3:08 pm

I made a mistake and updated from ART repos my php and mysql. I use Plesk 7.0.3 and before the update the version was mysql 3.23.58-1.9.

4.1.x update broke Plesk and unfortunately I had to go back. Which did not go very well either. Except for the fact that I backed up everything beforehand.

The problem is this:

At 4.1 I backed up my mysql files and mysqldumped my db normally and with the --compatible option. Unfortunately to my surprise mysqldump had a bug which did not add autoincrement when used with the --compatible option. So I went back and forth to make some try and now I have no idea what to do.

Here are the questiong that I have:

1. Which is the lowest version of mysql that I can use with Plesk 7.0.3 ?
2. How can convert my 4.1 db to 4.0x or 3.23 versions ? Is there a bypass using mysqldump ?
3. I downgraded php to 4.3.11. and my info.php page shows "Client API version 3.23.58" Is this php rpm only compatible with mysql 3.23 ?

Thanks for all your help..

Unread post by **scott** » Sun Jun 04, 2006 8:19 am

1. Mysql 4.0 (the version created by me, not the mysql.com one)
2. PSA will keep a 7 day backup of your DB's in /var/lib/psa, you should be able to roll back from there
3. The client library is used to connect to mysql, it is compatible with mysql 3 through mysql 5