On Wed, 2007-11-07 at 10:22 +0100, thomas Armstrong wrote: > Hi. Hello,
> Working on Linux, I've got installed MySQL 3.23.58, but I'm > experiencing some problems. For instance, I suffer "too many > connections" error but I cann't set 'max_connections' parameter to a > value bigger than 250. ... and does not compile on 64 bits, and... :) > I decided to migrate to MySQL 5.0, and I've got some questions: > - I installed MySQL from sources on '/usr/local/mysql'. Is it as easy > as installing it again on '/usr/local/mysql5'? Yep. Just change the '--prefix' com './configure' time. > - what must I back up to migrate data? '/usr/local/mysql/var' directory? > - is there any tutorial/webpage to carry out this migration? I would like to suggest that you do one dump on old database, stop the old and restore on newer database. Just copy the datafiles can work on small upgrades (mysql 3 -> 4) but I don't know what is the problem of this, I prefer the basic: dump and restore. -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]