title: Import Full MySQL Dump
body: <p>I have exported a full backup of a database with HeidiSQL 7.</p>
  
  <p>Now when importing it via PHPMyAdmin, I noticed that I MUST select the database <code>information_schema</code>, because that's how the DB is exported (Or this is how HeidiSQL 7 exports databases as objects to an SQL file?).</p>
  
  <p>However, that is a problem because when I import (the exported file) with HeidiSQL 7 (instead of PHPMyAdmin), while selecting the <code>information_schema</code> database, and clicking on Import SQL file (from the tools menu), it says that access is denied for the root user. </p>
  
  <p>In PHPMyAdmin, the option to import is not available when selecting the database <code>information_schema</code>. </p>
  
  <p>How do I import my full database dump? (This is how I exported it: HeidiSQL > export database <strong>objects</strong> to SQL file)</p>
  
  <p>Edit:
  I tried it with the command line, but without luck:</p>
  
  <pre><code>C:\Programs\XAMPP\mysql\bin&gt;mysql --verbose --user=root Information_schema &lt; DT.
  sql
  --------------
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
  --------------
  
  --------------
  /*!40101 SET NAMES utf8 */
  --------------
  
  --------------
  /*!40014 SET FOREIGN_KEY_CHECKS=0 */
  --------------
  
  --------------
  /*!40000 ALTER TABLE `CHARACTER_SETS` DISABLE KEYS */
  --------------
  
  ERROR 1044 (42000) at line 13: Access denied for user 'root'@'localhost' to data
  base 'information_schema'
  
  C:\Programs\XAMPP\mysql\bin&gt;
  </code></pre>
  
  <p>This is a snippet of the SQL file:
  <a href="http://pastebin.com/6hwhK2CJ" rel="nofollow">http://pastebin.com/6hwhK2CJ</a></p>
  
  <p>Note: The password for my root user is blank.</p>
  
  <p>Maybe another solution for my problem:
  How do I import only the database I want, from the SQL file? For example a database with the name "Employees"? Because that SQL file should contain a few databases.</p>
  
  <p>Edit2:
  (answer to first comment)
  I downloaded MySQL Workbench, setup the connection...</p>
  
  <pre><code>03:23:08 Restoring C:\Files\DB.sql
  
  Running: mysql.exe --defaults-extra-file="c:\files\temp\tmplnjwd6.cnf"  --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments &lt; "C:\\Files\\DB.sql"
  
  ERROR 1046 (3D000) at line 13: No database selected
  
  
  Operation failed with exitcode 1
  
  03:23:08 Import of C:\Files\DB.sql has finished with 1 errors
  </code></pre>