title: Import WordPress database into MySQL from an XML file, locally
body: <p>I'm working on Ubuntu 16.04, with MySQL 14:14, Nginx, PHP 7.0.33 and WordPress 5.0.9.</p>
  
  <p>I want to set up a copy of a WordPress site on my development machine. I have exported an XML file from the production site using:</p>
  
  <pre><code>Tools &gt; Export &gt; (o) All content &gt; [ Download Export File ]
  </code></pre>
  
  <p>The file is 341 MB.</p>
  
  <p>If I use WordPress's built-in Tools > Import > WordPress [Install Now] button, I see a dialog which asks for FTP credentials (Hostname, FTP username, FTP password), but I'm working directly on the machine on which I wish to install the data.</p>
  
  <p>What values can I provide for this?</p>
  
  <p>Looking for an alternative solution, I have tried importing it into the WordPress database using PHPMyAdmin, after having increased the memory allocation, but this fails. I looked at ways of importing an entire database in XML format through the MySQL command line, but I have only found ways of using <code>LOAD XML</code> to import data to a specific table.</p>