OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
MySQL migration from 4.0.27 to 5.0.37

From: Michael Lueck (mluecklueckdatasystems.com)
Date: Tue Jul 24 2007 - 19:04:54 CDT

Greetings List-

I have heard that there are details to be worked out when backing up from MySQL 4.0.x and restoring to MySQL 5.0.x, specifically in the area of special characters. I know that at least one of my
databases has special characters.

Does anyone know the syntax and what commands I should back the 4.0.27 up with so that I can restore to a MySQL 5.0.37 server.

It appears as though the version of MySQL client we have is 5.0.16 and is used to connect to both database servers.

The 5.x server is at a point that it has a newly created database... empty... nadda.

TIA!
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql