Shaun Adams schrieb: > 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 >
try the mysqldump-option --compatible=mysql40 Werner -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]