Title: Two databases
Last modified: August 31, 2016

---

# Two databases

 *  [Perkin5](https://wordpress.org/support/users/perkin5/)
 * (@perkin5)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/two-databases-1/)
 * A site I built a couple of years ago has been hacked and was sending out spam
   but my ISP fortunately spotted this and disabled it. I have now reinstated it
   successfully but in doing so I noticed that I have two databases. One (called
   xxxx_wordpress)contains all the normal wp tables including wp_posts. The other
   is called xxxx_blog and contains one table just called ‘posts’. This table contains
   all the posts that show on the blog page.
 * Why do I have the extra db/extra table and how does wp know to use it rather 
   than wp_posts? I can’t find a setting for it or a forum post that covers it. 
   Was it required by one of my plugins maybe?
 * I have quite a few plugins including BackWPup, Contact Form 7, Google analytics
   dashboard, Google xml sitemap, HTML editor syntax highlighter, No image link,
   TinyMCE Advanced, WordPress Database Backup, WordPress Visual Icon Fonts, WP 
   Admin Bar Removal, WP Emmet and Yoast SEO, all up to date.
 * Site URL is [http://www.amyhelenbell.com/](http://www.amyhelenbell.com/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [jdmrgtnj](https://wordpress.org/support/users/jdmrgtnj/)
 * (@jdmrgtnj)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/two-databases-1/#post-7205640)
 * Is the xxx_wordpress database the one used in your config file?
 * It’s highly unlikely your site is running multiple databases. I’d assume the 
   second one is just a remnant of the spam bot. Try renaming it, or downloading
   it first and then just removing it entirely to test if it is actually being used.
   If it isn’t, then I would just go ahead and delete it.
 *  Thread Starter [Perkin5](https://wordpress.org/support/users/perkin5/)
 * (@perkin5)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/two-databases-1/#post-7205661)
 * The xxxx_wordpress file is the one used in the config file.
 * You are quite right – the other database was redundant and I have deleted it.
   I wasn’t confident enough to do that before your response so thank you – problem
   solved.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Two databases’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [posts](https://wordpress.org/support/topic-tag/posts/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [Perkin5](https://wordpress.org/support/users/perkin5/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/two-databases-1/#post-7205661)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics