title: How to load already built in Magento project to localhost with database?
body: <p>I have to customize some of the things in already built in magento project. I copied the source file and pasted in htdocs folder and loaded the sql file in database. Modified host,username,password,dbname in the xml file which is situated in app/etc/local.xml folder. Which is as follows</p>
  
  <pre><code>&lt;config&gt;
  &lt;global&gt;
      &lt;install&gt;
          &lt;date&gt;&lt;![CDATA[Thu, 20 Dec 2012 04:20:32 +0000]]&gt;&lt;/date&gt;
      &lt;/install&gt;
      &lt;crypt&gt;
          &lt;key&gt;&lt;![CDATA[1dba174377df948cc045234de2d2d959]]&gt;&lt;/key&gt;
      &lt;/crypt&gt;
      &lt;disable_local_modules&gt;false&lt;/disable_local_modules&gt;
      &lt;resources&gt;
          &lt;db&gt;
              &lt;table_prefix&gt;&lt;![CDATA[]]&gt;&lt;/table_prefix&gt;
          &lt;/db&gt;
          &lt;default_setup&gt;
              &lt;connection&gt;
                  &lt;host&gt;&lt;![CDATA[localhost]]&gt;&lt;/host&gt;
                  &lt;username&gt;&lt;![CDATA[root]]&gt;&lt;/username&gt;
                  &lt;password&gt;&lt;![CDATA[]]&gt;&lt;/password&gt;
  
                  &lt;dbname&gt;&lt;![CDATA[btrweb]]&gt;&lt;/dbname&gt;
                  &lt;initStatements&gt;&lt;![CDATA[SET NAMES utf8]]&gt;&lt;/initStatements&gt;
                  &lt;model&gt;&lt;![CDATA[mysql4]]&gt;&lt;/model&gt;
                  &lt;type&gt;&lt;![CDATA[pdo_mysql]]&gt;&lt;/type&gt;
                  &lt;pdoType&gt;&lt;![CDATA[]]&gt;&lt;/pdoType&gt;
                  &lt;active&gt;1&lt;/active&gt;
              &lt;/connection&gt;
          &lt;/default_setup&gt;
      &lt;/resources&gt;
      &lt;session_save&gt;&lt;![CDATA[files]]&gt;&lt;/session_save&gt;
  &lt;/global&gt;
  &lt;admin&gt;
      &lt;routers&gt;
          &lt;adminhtml&gt;
              &lt;args&gt;
                  &lt;frontName&gt;&lt;![CDATA[admin]]&gt;&lt;/frontName&gt;
              &lt;/args&gt;
          &lt;/adminhtml&gt;
      &lt;/routers&gt;
  &lt;/admin&gt;
  </code></pre>
  
  <p></p>
  
  <p>Now when I load the file as localhost/btrweb(projectname) it is throwing an error like </p>
  
  <p><strong>SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'directory_country' already exists</strong></p>
  
  <p>Could you please help me out from this.</p>
  
  <p>Thanks in advance.</p>