|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Need Help Migrating DB from MySQL 5.0.x to MySQL 4.0.x
From: Shaun Adams (shaun
hypraze.net)
Date: Fri Sep 05 2008 - 10:58:52 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
Does anyone know how I can resolve this?
QUERY (windows server from the cmd prompt)
mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
--password=[PASSWORD] --host=[HOST] [TARGET DB]
ERROR MESSAGE RETURNED
ERROR 1193 (00000) at line 23: Unknown system variable
'character_set_client'
mysqldump: Got errno 22 on write
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]