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