migration from mysql4 to mysql5

maybe somewhere is step by step instruction for debain OS how to migrate from mysql4 to mysql5 without any data loose(mysql databases,users,root pasword,etc)?

 

Which Debian version do you use? Sarge or Etch?

 

Debian 3.1 Sarge

 

There are no official Sarge packages for MySQL 5, but you can install MySQL 5 from www.dotdeb.org.

Please put

Code:

deb http://packages.dotdeb.org [B][COLOR="Red"]sarge[/COLOR][/B] all

into /etc/apt/sources.list and run

Code:

apt-get update

Afterwards, you can search for MySQL packages like this:

Code:

apt-cache search mysql

 

I'm getting errors when upgrading mysql ;/

Code:

serveris:~# apt-get install mysql-client mysql-server mysql-common
Reading Package Lists... Done
Building Dependency Tree... Done
mysql-common is already the newest version.
The following extra packages will be installed:
  libmysqlclient15off lsb-base mysql-client-5.0 mysql-server-5.0
Suggested packages:
  mysql-doc tinyca
The following NEW packages will be installed:
  libmysqlclient15off lsb-base mysql-client-5.0 mysql-server-5.0
The following packages will be upgraded:
  mysql-client mysql-server
2 upgraded, 4 newly installed, 0 to remove and 17 not upgraded.
Need to get 35.5MB of archives.
After unpacking 95.8MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://dotdeb.pimpmylinux.org sarge/all mysql-server 5.0.41-1.dotdeb.0 [49.0kB]
Get:2 http://dotdeb.pimpmylinux.org sarge/all mysql-client 5.0.41-1.dotdeb.0 [46.8kB]
Get:3 http://dotdeb.pimpmylinux.org sarge/all libmysqlclient15off 5.0.41-1.dotdeb.0 [1806kB]
Get:4 http://ftp.de.debian.org sarge/main lsb-base 2.0-7 [8662B]
Get:5 http://dotdeb.pimpmylinux.org sarge/all mysql-client-5.0 5.0.41-1.dotdeb.0 [7269kB]
Get:6 http://dotdeb.pimpmylinux.org sarge/all mysql-server-5.0 5.0.41-1.dotdeb.0 [26.3MB]
Fetched 35.5MB in 22s (1585kB/s)
Preconfiguring packages ...
mysql-server-5.0 template parse error: Template #1 in /tmp/mysql-server-5.0.template.218820 does not contain a 'Template:' line

(Reading database ... 32794 files and directories currently installed.)
Preparing to replace mysql-server 4.0.24-10sarge2 (using .../mysql-server_5.0.41-1.dotdeb.0_all.deb) ...
Stopping MySQL database server: mysqld.
Stopping MySQL database server: mysqld.
Unpacking replacement mysql-server ...
dpkg: warning - unable to delete old file `/etc/logcheck/ignore.d.paranoid': Directory not empty
Preparing to replace mysql-client 4.0.24-10sarge2 (using .../mysql-client_5.0.41-1.dotdeb.0_all.deb) ...
Unpacking replacement mysql-client ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.41-1.dotdeb.0_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.41-1.dotdeb.0_i386.deb) ...
Selecting previously deselected package lsb-base.
Unpacking lsb-base (from .../lsb-base_2.0-7_all.deb) ...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.41-1.dotdeb.0_i386.deb) ...
Template #1 in /var/lib/dpkg/tmp.ci/templates does not contain a 'Template:' line
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.41-1.dotdeb.0_i386.deb (--unpack):
 subprocess pre-installation script returned error exit status 9
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.0_5.0.41-1.dotdeb.0_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

Now mysql is stopped and even command /etc/init.d/mysql start not working

Code:

serveris:~# /etc/init.d/mysql start
serveris:~#

I need to correct it as faster as i can

 

@payne,

Why don't you update to Debian 4.0 (Etch)?
Etch comes with php5 and mysql 5 by default.
Probably, you have special reasons for not updating to Etch.
However, you must realise that after one year (from the release date from Etch) that there will be no security updates for Sarge anymore.

 

Hans,
now i want to get back online my mysql server. After that we can talk about update to Etch

Is that a problem why i'm getting those errors?

 

Hi Payne,

No that's not the reason.
I had a look at your errors and i do not understand what's happening...

 

I think it's something with kernel..

 

No, it has nothing to do with your kernel.
Please try this:

Code:

wget http://packages.dotdeb.org/dists/sarge/mysql-5.0/binary-i386/mysql-server-5.0_5.0.41-1.dotdeb.0_i386.deb
dpkg -i mysql-server-5.0_5.0.41-1.dotdeb.0_i386.deb