• Resolved Cobb78

    (@cobb78)


    I have my entire WordPress database (posts, images, comments, etc…) saved as a sql database file, and even used MyPHPAdmin to import it. The problem is that I can’t get the posts to appear. And I can’t find an option to do it.

    The database is successfully imported, but how on earth do I get WordPress to recognize it?

    I have no plugins at all at this point, so that’s not a problem. I am using the default theme (2014), so that’s not an issue. This is also a fresh install of WordPress (best as I could figure, the previous install got corrupted somehow).

    So, can someone please tell me what to do to get this now-imported database (SQL) to be recognized and really imported so I can get my site up and running again?

    Thank you

    http://www.theCobbSix.com

Viewing 12 replies - 1 through 12 (of 12 total)
  • Moderator t-p

    (@t-p)

    The database is successfully imported, but how on earth do I get WordPress to recognize it?

    First, is the imported database from the same WP version, that is, 3.9.1?

    The reason I asked is that the database ( DB ) structure often changes between versions.

    You now need to link the database to your site inside of the wp_config.php

    You’ll need the databse name, username and password to link the two.

    Thread Starter Cobb78

    (@cobb78)

    Forgive my ignorance on the matter, but how do I do that?

    connect via FTP , edit the wp_config.php file.

    http://codex.ww.wp.xz.cn/FTP_Clients

    Thread Starter Cobb78

    (@cobb78)

    Ok, I guess I’m just showing my stupidity here…

    I’ve opened the wp_config.php file, and what exactly am I supposed to change? And what am I supposed to match it with?

    I’ve got the database name (same as what’s already there)

    I’ve got the database username (same as what’s already there)

    The password from the original database is different than what’s in the config file. But when I changed that and re-uploaded it via ftp, the entire website stopped showing up.

    Maybe I’m misunderstanding your question. If you’ve imported the database properly, and they are already linked up…what issue are you having??

    If the posts aren’t appearing int he dashboard, then you have not done the import properly and/or the old database is a different version than the current one.

    Thread Starter Cobb78

    (@cobb78)

    The database was exported as an sql yesterday, while running WordPress 3.9.1.

    Today, things were so screwy on WordPress (unable to post, or edit posts, and it was suggested that I do a fresh install of WordPress and then import the database. I did that, and according to MyphpAdmin, it was done successfully.

    What I’m saying is that they aren’t linking up.

    Am I correct in assuming that the database password for the previous install of WordPress is the one I need to insert into the config file in order to get it to recognize the imported database?

    If not, I guess I’m lost.

    Is it possible that the table prefix needs to be changed in the config file (someone suggested that)? If so, how do I find the database table prefix?

    Thanks for putting up with me.

    Thread Starter Cobb78

    (@cobb78)

    @esmi that was the original problem, and of the several suggestions I was given (and others I found for others experiencing the same problem), none worked. It was then stated by someone that the only resort was a fresh install.

    I would suggest that you just stick to one topic at a time.

    Thread Starter Cobb78

    (@cobb78)

    I marked the other one as [resolved], seeing as I’m starting over from scratch, no longer having the other problem.

    Thread Starter Cobb78

    (@cobb78)

    Found the problem. It was the table prefix that had to be changed. The posts are back.

    Thanks for putting up with me.

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

The topic ‘Database imported, but WordPress won't recognize it’ is closed to new replies.