Support » Fixing WordPress » moved site, WordPress only showing posts from bl_posts in SQL, not wp_posts

  • stc-rochester.org
    stc-rochester.org/spectrum

    I am in the process of moving two WordPress sites to a new hosting provider. One new site is working fine, the other is not showing any posts newer than 2011. When I looked at the database of the problem site using phpMyAdmin, I saw that there was a set of tables in the database with a bl_ prefix and a set with the expected wp_ prefix. The blog appears to be showing only the posts from bl_posts and not the posts or pages that are in the wp_ tables. The bl_ tables are in the current stc-rochester.org site, but it’s displaying the proper content.

    I tried deleting the bl_ tables. At that point, when I reloaded the site, I was prompted to install WordPress, which took me back to Hello World. I was able to get back to the nothing newer than 2011 situation by creating a new database and importing today’s backup from the current site.

    I believe the bl_ prefixes date back to a site hack in 2011 that used the thumbs.php exploit.

    How do I get the wp_ content to display?
    Thanks
    Ben

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi Ben, I used the Updraft Backup MIGRATOR which does cost $25 or so, but its worth evey penny. It contains a SEARCH AND REPLACE function that updates all settings to finetune with your new server… saves hours of work.
    Another way is to first export all posts with the post exporter built in WP.
    Once your new site is up, IMPORT the posts you downloaded to your computer.
    Works fine.
    Good luck!

    Thanks!
    Export and import restored the posts and pages. However, it did not restore any of the media or settings. Is there an easy way to do that or will I need to do that manually?
    Ben

    Hi Ben, if the media does not show up you could try to copy or move the whole uploads folder to your new site. FTP is best for that.
    Access your file manager on your Cpanel hosting account and upload the folder to the same location as the old file structure. If your URL of your site is the same, there should be no more problems.
    If you have changed the name of the site, you need to “replace the old URL with the new one” Try the WP plugin: Better Search Replace

    https://wordpress.org/plugins/better-search-replace/

    Good luck!

    The uploads folder and media files are all there.

    However, the SQL database looks odd.In addition to the wp_ tables, there’s a set of bl_ tables.

    bl_bad_behavior
    bl_blc_filters
    bl_blc_instances
    bl_blc_links
    bl_blc_synch
    bl_commentmeta
    bl_comments
    bl_links
    bl_ngg_album
    Ebl_ngg_gallery
    bl_ngg_pictures
    bl_options
    bl_postmeta
    bl_posts
    bl_terms
    bl_term_relationships
    bl_term_taxonomy
    bl_usermeta
    bl_users
    bl_woo_custom_nav_menus
    bl_woo_custom_nav_records
    wp_aiowps_events
    wp_aiowps_failed_logins
    wp_aiowps_global_meta
    wp_aiowps_login_activity
    wp_aiowps_login_lockdown
    wp_bad_behavior
    wp_blc_filters
    wp_blc_instances
    wp_blc_links
    wp_blc_synch
    wp_bwg_album
    wp_bwg_album_gallery
    wp_bwg_gallery
    wp_bwg_image
    wp_bwg_image_comment
    wp_bwg_image_rate
    wp_bwg_image_tag
    ewp_bwg_option
    wp_bwg_shortcode
    wp_bwg_theme
    wp_commentmeta
    wp_comments
    wp_links
    wp_mscr_intrusions
    wp_ngg_album
    wp_ngg_gallery
    wp_ngg_pictures
    wp_options
    wp_postmeta
    wp_posts
    wp_terms
    wp_term_relationships
    wp_term_taxonomy
    wp_usermeta
    wp_users
    wp_woocommerce_api_keys
    wp_woocommerce_attribute_taxonomies
    wp_woocommerce_downloadable_product_permissions
    wp_woocommerce_order_itemmeta
    wp_woocommerce_order_items
    wp_woocommerce_tax_rates
    wp_woocommerce_tax_rate_locations
    wp_woocommerce_termmeta
    wp_woo_custom_nav_menus
    wp_woo_custom_nav_records
    wp_woo_debug

    The current site is functional. Any ideas why there would be bl_ tables?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘moved site, WordPress only showing posts from bl_posts in SQL, not wp_posts’ is closed to new replies.