Two databases

  • 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 https://www.amyhelenbell.com/

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

  • 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

    (@perkin5)

    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.