Hi Tiago. Thank you very much for your answer. > > 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.
ok > > > > - 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. So you're suggesting to: - install MySQL 5 from sources on '/usr/local/mysql5' without starting it - dump data from MySQL 3 - stop MySQL 3 - start MySQL 5 - restore data in MySQL 5 - delete MySQL 3 is it right? > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]