title: How to restore the information_schema database with a backup
body: <p>I have a backup from a WAMP server MYSQL database from home and I need to install it on my work WAMP setup.</p>
  
  <p>I currently don't have access to my original database and so, can't just export specific tables.</p>
  
  <p>Here is the phpmyadmin message:</p>
  
  <pre><code>SQL query:
  
  --
  -- Database: `information_schema`
  --
  CREATE DATABASE  `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  
  
  MySQL said: 
  
  #1044 - Access denied for user 'root'@'localhost' to database 'information_schema' 
  </code></pre>
  
  <p>The information_schema database appears to be locked and the restore fails in phpmyadmin. In the MYSQL Workbench it carries on through the backup ignoring the "access denied" messages but crashes halfway through.</p>
  
  <p>I have tried removeing the database_schema lines in the sql file but it just looks like a mess of text and can't figure out how to remove it.</p>
  
  <p>Another thing is will I actually need it? Or can I remove it. I'm not too sure what information is stored there.</p>
  
  <p>Thank you.</p>