Re: How to migrate from MySQL 3 to MySQL 5 (installed from sources)
Never tried it with version 3 only 4.1 but it has a --compatible switch with a version 3.23 switch see command line --help so I assume the mysql guys are allowing you to dump 3.23. Try dumping it without the switch as you will be restoring to 5.0. The idea is to make sure the restore is done using a version 5 compatible dump. Keep us posted. thomas Armstrong wrote: Make sure you use the mysqldump from version 5 and not version 3. Also recheck all your application queries once you have restored the data the list of changes SQL syntax might haunt you. But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3? -- Mark Carson Managing Integrated Product Intelligence CC EMail : [EMAIL PROTECTED]/[EMAIL PROTECTED] snailmail : P.O. Box 36095 Menlo Park 0102, South Africa Cell : +27 83 260 8515 This e-mail may contain PRIVILEGED AND/OR CONFIDENTIAL INFORMATION intended only for use of the addressee. If you are not the addressee, or the person responsible for delivering it to the person addressed, you may not copy or deliver this to anyone else. If you received this e-mail by mistake, please do not make use of it, nor disclose it's contents to anyone. Thank you for notifying us immediately by return e-mail or telephone. INFORMATION PROVIDED IN THIS ELECTRONIC MAIL IS PROVIDED "AS IS" WITHOUT WARRANTY REPRESENTATION OR CONDITION OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO CONDITIONS OR OTHER TERMS OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. THE USER ASSUMES THE ENTIRE RISK AS TO THE ACCURACY AND THE USE OF THIS DOCUMENT. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to migrate from MySQL 3 to MySQL 5 (installed from sources)
> Make sure you use the mysqldump from version 5 and not version 3. Also > recheck all your application queries once you have restored the data the > list of changes SQL syntax might haunt you. But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to migrate from MySQL 3 to MySQL 5 (installed from sources)
Hi All Make sure you use the mysqldump from version 5 and not version 3. Also recheck all your application queries once you have restored the data the list of changes SQL syntax might haunt you. Mark thomas Armstrong wrote: 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? -- Mark Carson Managing Integrated Product Intelligence CC EMail : [EMAIL PROTECTED]/[EMAIL PROTECTED] snailmail : P.O. Box 36095 Menlo Park 0102, South Africa Cell : +27 83 260 8515 This e-mail may contain PRIVILEGED AND/OR CONFIDENTIAL INFORMATION intended only for use of the addressee. If you are not the addressee, or the person responsible for delivering it to the person addressed, you may not copy or deliver this to anyone else. If you received this e-mail by mistake, please do not make use of it, nor disclose it's contents to anyone. Thank you for notifying us immediately by return e-mail or telephone. INFORMATION PROVIDED IN THIS ELECTRONIC MAIL IS PROVIDED "AS IS" WITHOUT WARRANTY REPRESENTATION OR CONDITION OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO CONDITIONS OR OTHER TERMS OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. THE USER ASSUMES THE ENTIRE RISK AS TO THE ACCURACY AND THE USE OF THIS DOCUMENT. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to migrate from MySQL 3 to MySQL 5 (installed from sources)
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]
Re: How to migrate from MySQL 3 to MySQL 5 (installed from sources)
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]