Support » Fixing WordPress » Which database is the right one?

  • [ Moderator note: moved to Fixing WordPress. ]

    I had an old installation of wp with issues. It resides at www/.

    I installed a new copy of wp which is working fine and its at www/wordpress_2/.

    How do I move my data? Do I simply:

    1. database export dump and download to my local computer (done)
    2. upload db to the new installation somehow?
    3. upload wp-content folder

    THanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Damon Cook

    (@colorful-tones)

    Hi marciokoko,

    I had an old installation of wp with issues.

    Curious, what were the issues? If they were database related then you might want to fix that first obviously.

    In theory, you can just copy the database credentials in your old WordPress install’s (at www/) wp-config.php, and place them in the new site’s wp-config.php

    Something like this:

    
    // ** MySQL settings - You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define( 'DB_NAME', 'database_name_here' );
    
    /** MySQL database username */
    define( 'DB_USER', 'username_here' );
    
    /** MySQL database password */
    define( 'DB_PASSWORD', 'password_here' );
    
    /** MySQL hostname */
    define( 'DB_HOST', 'localhost' );
    

    Here is a bit more info from the Codex: https://codex.wordpress.org/Editing_wp-config.php#Configure_Database_Settings

    Hit us up if you still need help. Enjoy your day!

    Well I went with the option of making an export file from the old install and importing it into the new install. It worked like a charm except for a couple of warnings related to plugins. Could you tell me what they mean in practical terms? All my posts are there and the website looks fine at www/wordpress_2/ Im just wondering what they mean because maybe I just have to reinstall those 2 plugins on my new site:

    Failed to import “Arduino Internet of Things:” Invalid post type advanced_ads
    Failed to import “Premium1Subscriptor” Invalid post type pms-subscription

    Damon Cook

    (@colorful-tones)

    Those error messages imply that you had two previous plugins (or one maybe) that created/registered custom post types: advanced_ads and pms_subscription. If you had the associated plugin(s) Deactivated, or not installed at all when you imported the old data then it didn’t recognize that those custom post types existed and just failed to import them.

    It is not an issue if you do not need those post types and their data. Otherwise, I would suggest you install them again, Activate them, and then re-import the data.

    Let us know how it works out.

    As for advanced_ads, this is the post type for ads of my Advanced Ads plugin.

    As Damon said, just activate it on the other blog if you also want to import the ads.

    Thomas

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Which database is the right one?’ is closed to new replies.