title: MySQL import/export version incompatibilty
body: <p>I have taken a dump from my mysql database on my own server (version 5.0.67) and I have tried to import it to my other database (version 5.0.54). However, I get the error:</p>
  
  <pre><code>ERROR 1193 (00000) at line 23: Unknown system variable 'character_set_client'
  </code></pre>
  
  <p>I think it refers to this part:</p>
  
  <pre><code>SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  </code></pre>
  
  <p>I have tried removing all the above lines but that made the error worse:</p>
  
  <pre><code>ERROR 1064 (00000) at line 23: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 10240 kB; (`member
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>
  
  <h2>UPDATE</h2>
  
  <p>I used the compatibility option like so but when importing I still get the same error!? WTF</p>
  
  <pre><code>mysqldump -u root -p dbname --compatible=mysql40  &gt; mrdb.sql
  </code></pre>