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]
