Hi All,

I updated my version of mysql from 4.1.22 to 5.0.45 and found that my
tables are not being read now. I tried to go back to the older
version. Now it seems that I have two versions of mysql installed.
When I login to the server and do a SELECT version(), it shows my
version as 4.1.22 while phpinfo shows the version as 5.0.45 . I am
still not able to access the tables.

How can I get back to the older version and retrieve the tables. My DB
is huge and I cannot do a mysqldump

TIA
Pankaj

On Fri, 9 May 2008 09:23:37 -0700 (PDT), Pankaj
<panahuja@gmail.com> wrote:

>Hi All,
>
>I updated my version of mysql from 4.1.22 to 5.0.45 and found that my
>tables are not being read now. I tried to go back to the older
>version. Now it seems that I have two versions of mysql installed.
>When I login to the server and do a SELECT version(), it shows my
>version as 4.1.22 while phpinfo shows the version as 5.0.45 . I am
>still not able to access the tables.

Did you read the upgrade instructions?

>How can I get back to the older version and retrieve the tables.

Stop the mysqld service/daemon (=new version).
Uninstall the new mysql version.
Install the old mysql version.
Check if your my.ini file is correct, it should point
to the directory where your databases used to be.
Start the mysqld service/daemon (=old version).
Try to access your data.
If that doesn't work:
Stop the mysqld service/daemon.
Restore your most recent backup of all database files.
Check your my.ini file again.
Start the mysqld service/daemon (=old version).
Now it should work.
If it still doesn't, you're out of luck.

>My DB is huge and I cannot do a mysqldump

Then you can't upgrade. Unless you mimic the behaviour
of mysqldump (for making a backup) and mysql (for
restoring it) with your own scripts / programs.

>TIA
>Pankaj
--
( Kees
)
c[_] Fish come in many shapes and sizes. (#527)