Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Mysql problem please help

[linuxlover]

Hello every one

please help me in this

My main hdd in linux server faild ( it is read only Now file system )

then DC put a new hdd for me and put the old one as secondary

But I faced one problem that Mysql in old hdd is 4.0 and in new is 4.1.18

then I have mysql folder

How I can upgrade mysql databases in old one ???

cause i need to copy it again to new hdd ( primary hdd )

Please help me with any idea or steps

[WebzPro]

Are you saying before the HD replacement that you were running MySQL 4.1.8 and they put on the new drive 4.0?

[linuxlover]

the new drive which it si primary now Mysql is 4.1

and old drive ( secondary one ) mysql is 4.0

I need to copy mysql databases from secondary drive to primary drive

[linuxlover]

control panel is cpanel

[wonderpoint]

Downgrade MySQL to 4.0 on the new primary.
Copy MySQL files from secondary.
Then upgrade mysql to 4.1 in primary.

[linuxlover]

I try to downgrade mysql in the past But I can't did that

How I can downgrade it ???

[wonderpoint]

This may help.

Downgrading MySQL 4.1 to MySQL 4.0

If you are not confident about it, its best to hire someone who can do it for you.

[linuxlover]

you can't downgrade mysql service to 4.0 from 4.1

you can downgrade only databases as dump file

[wonderpoint]

You can always remove MySQL server 4.1 and install MySQL server 4.0. I don't see any reason why this is not possible. I have done this myself on many cPanel servers.

[linuxlover]

I enter whm and tweak setting and I don't found version 4.0 in mysql

I only found 4.1 and 5.0

and check box ( Use old style (4.0) passwords with mySQL 4.1 (required if you have problems with php apps authenticating)

this will not downgrade mysql

do you have steps to downgrade mysql please ???

[wonderpoint]

You will have to downgrade cPanel to a stable build (i think 114 or before, I am not sure though) to get MySQL 4.0 option.

[linuxlover]

can I upgrade mysql databses with any way rather than do this ???

from olddrive/var/lib/mysql

If I can upgarde these databases folders I can copy it and evreything will done

any more help please

[linuxlover]

still can't complete this any more help

[madguy24]

The best way I can imagine would be to downgrade the cPanel MySQL to 4.0 (I have done that successfully) expecting a downtime of around 30 mins, copy the mysql dir and then then upping to 4.1.

Otherway would be to copy the DBs to your localmachine or so which runs 4.0 (with same mysql root pass) and do a mysqldump --alldatabases --result-file=mysql4.sql (ofcourse with the other extra and necessary parameters for the mysqldump) , upload the mysql4.sql to the server and then cat mysql4.sql | mysql

These commands assume you have mysql pass in /root/.my.cnf and you are logged in as root. my 2 cents..may be others have better solutions..

[linuxlover]

Thanks for this

the better is the old one and I know it But the problem here that my cpanel is new version stable and I don't found Mysql 4.0 in it

this is the problem sir

so my question how to downgrade mysql service from 4.1 to 4.0