[opencms-dev] Problem upgrading mySQL version 3.23

[Christian Steinert]

> I've tried to update my sql version 3.23 to 4.0.21 as Gustavo says in
> http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html
> /etc/init.d/mysql stop
> rpm -Uvh MySQL-server-4.0.21-0.i386.rpm
> rpm -Uvh MySQL-devel-4.0.21-0.i386.rpm
> rpm -Uvh MySQL-client-4.0.21-0.i386.rpm
> /etc/init.d/mysql start
> But the mysql doesn't start anymore.
> Could you help me, please?


I don't know about the procedure you have in mind

But alternatively you could
- do a Database dump in 3.23 (with the tool mysqldump, see the documentation on this)
- do a clean install of 4.x, without any databases
- create an empty database of the correct name
- import the database dump (which is nothing but a big SQL file)
  by logging in as root and doing :
  cat myExportFile.sql | mysql <dbname>

Like this you can avoid the upgrade of the existing database files and import the database into a clean environment.

At least I had no problem with doing this. It worked even from Windows -> Linux.
I never tried upgrading from 3.23 to 4.x, so I have no experience with your actual problem


hope that helps somehow
christian
_____________________________________________________________________
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000071