title: MariaDB 10.0 renames foreign keys on dump insert
body: <p>State:
  Two exact database setups with MariaDb 10.0</p>
  
  <p>One is full the other empty waiting for the dump to insert.</p>
  
  <p>Foreign key constraint exist on a table:</p>
  
  <pre><code>ALTER TABLE `rel_account_account` ADD CONSTRAINT `FK_Account` FOREIGN KEY (`InAccountID`) REFERENCES `t_account` (`ID`) ON DELETE RESTRICT ON UPDATE CASCADE;
  </code></pre>
  
  <p>If I dump the database by </p>
  
  <pre><code>mysqldump -uroot -p --default-character-set=utf8 livedb -r live.sql
  </code></pre>
  
  <p>and restore it on the other system by</p>
  
  <pre><code>mysql -uroot -p --default-character-set=utf8 livedb
  mysql&gt; SOURCE live.sql
  </code></pre>
  
  <p>Afterwards the foreign keys are renamed to a specific schema:</p>
  
  <pre><code>&lt;tablename&gt;_ifbk&lt;index&gt;
  </code></pre>
  
  <p>that means the FK: </p>
  
  <pre><code>FK_Account
  </code></pre>
  
  <p>has been renamed automatically to:</p>
  
  <pre><code>rel_account_account_ifbk_1
  </code></pre>
  
  <p>I did not find anything about such a possibility in the docs, so i ask this here. Is this a configurable feature, because if its done automatically i would assume that it could be very critical?</p>
  
  <p>Any ideas?</p>
  
  <p>EDIT: Please see answer.</p>