Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : MySQL 4.1 or 4.0

[hamidhossain]

Hi,

I have an old server with MySQL 4.0 contains lot of websites. I got a new server supplied with MySQL 4.1.

I tried to transfer my sites from my old server the new one using WHM copy. It gave me that all sites are moved succesfully!

When I checked my sites, i got shocked that they are not reading from database. I checked db using phpmyadmin. Every thing is moved.

The problem is in CharSet (I guess).

Is there any way to make my sites to work with MySQL 4.1?

if no, how to install MySQL 4.0 instead of 4.1 on my server?

Regards,
Hamid

[wonderpoint]

how to install MySQL 4.0 instead of 4.1 on my server?

Assuming you have a good copy of the database in 4.0 format in the old server.

1. Terminate all accounts in the new server.
2. Take a dump of database mysql in 4.0 format from shell.
3. Select MySQL 4.0 in WHM->Tweak Settings and click save.
4. It will prompt you to click on a link after 30 seconds. Wait for 30 seconds and click on the link.
5. Once the downgrade is complete, run /scripts/easyapache from SHELL.
6. Import database mysql back.
7. Restart the mysql server.

That should downgrade you from 4.1 to 4.0

There may be other better methods to downgrade, but this one worked for me

[firestarter]

You can set the default character set "default-character-set" parameter in the my.cnf to fix the issue.

[david510]

Did you try giving old password in my.cnf ?

[hamidhossain]

Hi

wonderpoint,

I dont have the option 4.0 in my Tweek Settings. I have 5.0 and 4.1 only!

firestarter,

Any steps I can follow to change the charset? I tried using phpmyadmin but I couldn't find a way that i can change the charset.

david510,

I enabled old passwords in /etc/my.cnf => old_passwords=1

Waiting your help,
Hamid

[timdorr]

You don't want 4.0 anyways, that's really too old to be supporting them still. If anything, you should be moving to MySQL 5.0 (which you might as well do), which is the current production-quality version.

It sounds like you need to run EasyApache. Try building that with the Use System MySQL option under the PHP section. That might be able to fix it.

[hamidhossain]

timdorr,

You are right, going for newer versions is better.

Ok, if I used tweek settings and updated to MySQL 5. Do you think i will get the same problem again? I am using php 4 and I don't think it will be accepted to update to php 5 because all the scripts available in the server are going to STOP!

any suggestions?
Hamid

[LayerSolutions]

I dont think you need php5 to use MySQL 5 it works with php4.

[hamidhossain]

I used EasyApache from WHM and that refreshed the whole system. I checked some of the hosted sites and unfortunately, they still not working.

I am going to upgrade to mysql 5 but i don't think it is going to work smoothly.

Hamid

[LayerSolutions]

Pay a sys admin to revert your server back to mysql4

[LayerSolutions]

Check out this link:

http://forums.cpanel.net/showthread....ght=back+mysql

or

You can upgrade your old server to MySQL 4.1 and it will update the mysql databases automatically.

[hamidhossain]

FrozenHost,

Money is not an issue, I want to learn (smile).

Hamid

[LayerSolutions]

I gave you all the possible solutions.

[Chrysalis]

4.0 isnt been updated anymore but I wouldnt goto 5.0 just yet, 4.1 is your best bet.