title: Export and import data from PHPMYADMIN
body: <p>I exported data with phpMyAdmin, but when I import the data I get this error:</p>
  
  <blockquote>
    <p>#1452 - Cannot add or update a child row: a foreign key constraint fails</p>
  </blockquote>
  
  <p>I can set the data accordingly and then I don't get the error. But is there a better way to do this? Something like disabling some options in phpMyAdmin or adding some query to SQL?</p>