Answers.Body: <p>You can find the civicrm database listed in the civicrm.settings.php</p>
  
  <pre><code> &lt;wordpress&gt;/wp-content/uploads/civicrm/civicrm.settings.php
  </code></pre>
  
  <p>Apart from that , you have two possibilities</p>
  
  <p>1)Wordpress and Civicrm both use same database</p>
  
  <p>2) Civicrm has    separate database</p>
  
  <p>If wordpress and civicrm has same database , you can search in wordpress database tables which have prefix civicrm_*</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-04T16:37:59.587Z
Answers.Text: Thanks. That's what I thought, but there are no civicrm tables in the WP db. I found a database name in civicrm.settings.php, but I can't find a file with that name on the server. In theory, it shouldn't be that hard to find the file, but I don't know where I'm going wrong.
Answers.UserDisplayName: kzburn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-04T18:02:39.640Z
Answers.Text: If you want, I can help you figure that out.let me know
Answers.UserDisplayName: harshal
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-04T19:36:34.960Z
Answers.Text: I would appreciate any suggestions.
Answers.UserDisplayName: kzburn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-04T19:39:00.770Z
Answers.Text: @kzburn, I would have helped if I ws able to access your environment
Answers.UserDisplayName: harshal
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-04T20:14:10.773Z
Answers.Text: Hi @kzburn, check for r9Z99F_2_civicrm_* as prefix in your database list of tables
Answers.UserDisplayName: harshal
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-06T19:50:33.087Z
Answers.Text: Log in to phpmyadmin using the username/password listed in the same place in civicrm.settings.php where you found the database name. It might be different database users for wordpress and civi.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-04T15:44:50.653Z
Answers.LastActivityDate: 2018-03-04T15:44:50.653Z
Answers.UserDisplayName: harshal
Answers.Body: <p>If you are sure you are in the correct database for your wordpress your civi is installed on, you should see this.  </p>
  
  <p><a href="https://i.sstatic.net/QCBpP.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/QCBpP.jpg" alt="enter image description here"></a></p>
  
  <p>****EDIT****</p>
  
  <p>Go to wp-content/uploads/civicrm/civicrm.settings.php</p>
  
  <p>Look for this line</p>
  
  <pre><code>if (!defined('CIVICRM_UF_DSN') &amp;&amp; CIVICRM_UF !== 'UnitTests') {
  </code></pre>
  
  <p>define( 'CIVICRM_UF_DSN'           , 'mysql://<strong>YOUR CIVI DATABASE LOCATION SHOULD BE RIGHT HERE</strong>');</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-04T20:03:34.123Z
Answers.Text: When I go to phpMyAdmin, I only see one database.
Answers.UserDisplayName: kzburn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-05T13:24:43.070Z
Answers.Text: See my edits above.  That should help you find your civi database location.
Answers.UserDisplayName: fdarn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-05T15:36:54.480Z
Answers.Text: Thanks.....I found that and I know the name of the database, but when I ftp to our server, there isn't a file there with that name.  At least I'm on the right track. Thanks for your help!
Answers.UserDisplayName: kzburn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-06T19:49:04.223Z
Answers.Text: You won't see it with ftp, you would see it in phpmyadmin, but you might be logging in to phpmyadmin as a user that doesn't have access to the civi database. Use the user/pass that's listed in the CIVICRM_UF_DSN setting.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-04T19:22:00.070Z
Answers.LastActivityDate: 2018-03-05T13:23:42.563Z
Answers.LastEditDate: 2018-03-05T13:23:42.563Z
Answers.UserDisplayName: fdarn
Body: <p>I recently took over a website and I have missing tables in the civicrm database (under wordpress). I want look at the civicrm database but I don't know where the database is stored. How can I find the physical civicrm database file so I can download it and run some queries to see what's there?  When I go to phpMyAdmin on the server, it only lists the wordpress database.</p>
  
  <p>Below is what I see when I look at phpMyAdmin and this is the only db. I have looked at all of the table names in this db and there are no civicrm tables.</p>
  
  <p>Thanks</p>
  
  <p><a href="https://i.sstatic.net/8rEjC.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/8rEjC.jpg" alt="enter image description here"></a></p>
  
Tags: <database>
Title: Where is the civicrm database?
ThreadText: # Where is the civicrm database?
  
  (Asked by: username_0 on 2018-03-04)
  
  I recently took over a website and I have missing tables in the civicrm database (under wordpress). I want look at the civicrm database but I don't know where the database is stored. How can I find the physical civicrm database file so I can download it and run some queries to see what's there? When I go to phpMyAdmin on the server, it only lists the wordpress database.
  
  Below is what I see when I look at phpMyAdmin and this is the only db. I have looked at all of the table names in this db and there are no civicrm tables.
  
  Thanks
  
  [![enter image description here](https://i.sstatic.net/8rEjC.jpg)](https://i.sstatic.net/8rEjC.jpg)
  
  **Tags:** database
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-03-04. Score: 5
  
  You can find the civicrm database listed in the civicrm.settings.php
   /wp-content/uploads/civicrm/civicrm.settings.php
  
  Apart from that , you have two possibilities
  1)Wordpress and Civicrm both use same database
  2) Civicrm has    separate database
  If wordpress and civicrm has same database , you can search in wordpress database tables which have prefix civicrm_*
  
  > **Comments:**
  > **username_0**: Thanks. That's what I thought, but there are no civicrm tables in the WP db. I found a database name in civicrm.settings.php, but I can't find a file with that name on the server. In theory, it shouldn't be that hard to find the file, but I don't know where I'm going wrong.  
  > **username_1**: If you want, I can help you figure that out.let me know  
  > **username_0**: I would appreciate any suggestions.  
  > **username_1**: @username_0, I would have helped if I ws able to access your environment  
  > **username_1**: Hi @username_0, check for r9Z99F_2_civicrm_* as prefix in your database list of tables  
  > **username_2**: Log in to phpmyadmin using the username/password listed in the same place in civicrm.settings.php where you found the database name. It might be different database users for wordpress and civi.  
  
  ---
  
  ### Answer by username_3 on 2018-03-04. Score: 2
  
  If you are sure you are in the correct database for your wordpress your civi is installed on, you should see this.  
  
  ****EDIT****
  Go to wp-content/uploads/civicrm/civicrm.settings.php
  Look for this line
  if (!defined('CIVICRM_UF_DSN') && CIVICRM_UF !== 'UnitTests') {
  
  define( 'CIVICRM_UF_DSN'           , 'mysql://YOUR CIVI DATABASE LOCATION SHOULD BE RIGHT HERE');
  
  > **Comments:**
  > **username_0**: When I go to phpMyAdmin, I only see one database.  
  > **username_3**: See my edits above.  That should help you find your civi database location.  
  > **username_0**: Thanks.....I found that and I know the name of the database, but when I ftp to our server, there isn't a file there with that name.  At least I'm on the right track. Thanks for your help!  
  > **username_2**: You won't see it with ftp, you would see it in phpmyadmin, but you might be logging in to phpmyadmin as a user that doesn't have access to the civi database. Use the user/pass that's listed in the CIVICRM_UF_DSN setting.  
  
  ---
  
  