migration from mysql4 to mysql5

Discussion in 'Server Operation' started by payne, May 20, 2007.

  1. payne

    payne New Member

    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)?
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Which Debian version do you use? Sarge or Etch?
     
  3. payne

    payne New Member

    Debian 3.1 Sarge
     
  4. falko

    falko Super Moderator ISPConfig Developer

    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
     
  5. payne

    payne New Member

    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 :confused:
     
    Last edited: May 22, 2007
  6. Hans

    Hans Moderator ISPConfig Developer

    @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.
     
  7. payne

    payne New Member

    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?
     
  8. Hans

    Hans Moderator ISPConfig Developer

    Hi Payne,

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

    payne New Member

    I think it's something with kernel.. :confused:
     
  10. falko

    falko Super Moderator ISPConfig Developer

    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
     

Share This Page