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]
