How to downgrade to MySQL 4.1.21

P

PaulM

Verified User
Joined
Nov 6, 2009
Messages
3
Hi guys, you helped me a lot in the previous thread. I faced another important questions. I updated mysql from 4.1.21 to mysql 5.1 using directadmin using custombuild like described there:
http://help.directadmin.com/item.php?id=240

But I didn't create a backup of my mysql databases. Some of my tables become "In use" (when I login into phpmyadmin I see that a few tables are in permanent "in use" status and I cannot repair them when I click "Repair" or "Optimize"). So I want to temporarily install MySQL 4.1.21 back. How can I do it?

I guess I cannot do it in /usr/local/directadmin/custombuild/options.conf because custombuild has just two options mysql 5 or 5.1. I tried to specify 4.1 but got some errors.

So guys, how can I install mysql 4.1.21 back? Which is the best way? Thanks.
 
Try this command in SSH (as root) for fix your tables:
Code: 
/usr/bin/mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --auto-repair --check --optimize --all-databases


Regards
 
You must log in or register to reply here.
Back
Top