Answers.Body: <p>If you planning to reinstall CiviCRM on separate database than you will need to delete the civicrm.settings.php file which holds all the db settings. </p>
  
  <p>Since you are using wordpress you can locate the file in one of the place below</p>
  
  <pre><code>wp-content/plugins/civicrm/civicrm.settings.php
  </code></pre>
  
  <p>or</p>
  
  <pre><code>wp-content/uploads/civicrm/civicrm.settings.php
  </code></pre>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-02T15:14:01.377Z
Answers.Text: thank you Pradeep.  I have found the setting file in the uploads folder.  All good now:)
Answers.UserDisplayName: dgk112
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-02T15:32:07.440Z
Answers.Text: Cool. Can you mark this as Answered so that it will be useful for others?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-02T13:13:50.810Z
Answers.LastActivityDate: 2018-08-02T13:13:50.810Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I'm just getting started with CiviCRM and trying to install on our WordPress site.</p>
  
  <p>I completed the initial install once, but accidentally used the existing WordPress database - I would prefer to install on separate database.</p>
  
  <p>So I have deleted the plugin, via WPadmin.  Removed CiviCRM tables from the database using the drop sql file.  Uploaded the CiviCRM files to server again and tried to activate the plugin.</p>
  
  <p>The plugin is activated, but clicking the CiviCRM button in the lhs menu gives me error message below.  Seems like CiviCRM is looking to the old install in the WordPress database?</p>
  
  <p>How to correct this please and reinstall in separate db?</p>
  
  <pre><code>Initialization Error
  
  Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; simpleHandler
          )
  
      [code] =&gt; -18
      [message] =&gt; DB Error: no such table
      [mode] =&gt; 16
      [debug_info] =&gt; SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
  FROM civicrm_setting
  WHERE (domain_id = 1) AND (is_domain = 1)
   [nativecode=1146 ** Table 'huWP_db.civicrm_setting' doesn't exist]
  </code></pre>
  
Tags: <database>
Title: db error reinstalling CiviCRM
ThreadText: # db error reinstalling CiviCRM
  
  (Asked by: username_0 on 2018-08-02)
  
  I'm just getting started with CiviCRM and trying to install on our WordPress site.
  
  I completed the initial install once, but accidentally used the existing WordPress database - I would prefer to install on separate database.
  
  So I have deleted the plugin, via WPadmin. Removed CiviCRM tables from the database using the drop sql file. Uploaded the CiviCRM files to server again and tried to activate the plugin.
  
  The plugin is activated, but clicking the CiviCRM button in the lhs menu gives me error message below. Seems like CiviCRM is looking to the old install in the WordPress database?
  
  How to correct this please and reinstall in separate db?
  
  ```
  Initialization Error
  
  Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => simpleHandler
          )
  
      [code] => -18
      [message] => DB Error: no such table
      [mode] => 16
      [debug_info] => SELECT id, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id
  FROM civicrm_setting
  WHERE (domain_id = 1) AND (is_domain = 1)
   [nativecode=1146 ** Table 'huWP_db.civicrm_setting' doesn't exist]
  
  ```
  
  **Tags:** database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-08-02. Score: 0 | Accepted answer
  
  If you planning to reinstall CiviCRM on separate database than you will need to delete the civicrm.settings.php file which holds all the db settings.
  
  Since you are using wordpress you can locate the file in one of the place below
  
  ```
  wp-content/plugins/civicrm/civicrm.settings.php
  
  ```
  
  or
  
  ```
  wp-content/uploads/civicrm/civicrm.settings.php
  
  ```
  
  HTH
  
  username_1
  
  > **Comments:**
  > **username_0**: thank you username_1.  I have found the setting file in the uploads folder.  All good now:)  
  > **username_1**: Cool. Can you mark this as Answered so that it will be useful for others?  
  
  ---
  
  