restored database file (.sql) not showing posts from previous hosting site

not sure what you mean govpatel… but those 6 lines were copied from the wp-config.php file.

please explain what you’re asking me to do/check/change?

Thanks!
Kellie

Ok, so i’ve now discovered where the problem might lie…

this is a screen shot i’ve taken from phpmyadmin of the database content…
and i imagine that the reason my url only displays the default welcome post and comment because the wp_posts file only contains 3 records… whereas the wp_h8lbjc_posts file contains 1101 records.

If this is what is wrong, how do i rename the file with the posts in it without causing more problems?

Thanks

In wp-config.php file change prefix from wp_ to wp_h8lbjc and see if this solves your problem

doing that caused me to be directed to a login url that failed…
https://kelliemaree.com/blog/wp-admin/install.php

so i reverted to the wp_ prefix for now

did you ever use wpmu or any other multi site as looks like you the default tables created with the install that has wp_ prefix and then you another set of tables wp_h8lbjc prefix so matter fact you must be sharing the database for two wordpress

nope, though i have uninstalled and reinstalled wp a few times while trying to fix this problem

doing that caused me to be directed to a login url that failed…
https://kelliemaree.com/blog/wp-admin/install.php

so i reverted to the wp_ prefix for now

I would try and go through install setups by renaming wp-config.php to say wp-config-hold.php for backup in case it does not work.
When you go to https://kelliemaree.com/blog/wp-admin/install.php
you will asked to create config file go ahead create the file
on next step will ask you enter your data base info go enter them but in prefix enter wp_h8lbjc once you done that next step you should have that wordpress is installed as wordpress should pick up your wp_h8lbjc tables.

the same thing happened to my previous comment…
whenever i put the h8lbjc at the end of the prefix, i save the file then go to the url for the blog and it just re-directs to the wp_admin/install.php but fails to load the page…

ok, so i think i’ve made headway myself…
i’m renaming the original tables with _hold at the end and removing the h8lbjc from the imported tables… and the data is now showing in the admin panel of wp. I’ve done the posts and comments so hopefully that the rest will respond accordingly

Is there ay way we can meet in skype ID govindjip so that i can see what you have on desk top sharing and direct you accordingly.

might have been helpful… but think i’ve got it all now… please check… https://www.kelliemaree.com/blog

if you see any abnormalities let me know via skype… my user kelkelp thanks

I knew there was problems with prefixes as when reinstalled wordpress tables were created with wp_ while you had database tables with wp_h8lbjc

Kellimarie, what was the problem? I seem to be having the same problem as you…except that my wp_posts has 500 posts and none of them are showing up ??

Hi Krama757,

i’m not sure exactly how the problem occurred, but I came to the conclusion that the database was opening the wp_ tables instead of my backed up and installed wp_h8lbjc.
So how I fixed it was by going into my phpmyadmin selecting the database, and editing the names of the standard wp_ prefix ie: wp_posts to wp_posts_hold then i renamed my wp_h8lbjc_posts to wp_posts

I did that with posts, comments links etc. A couple of the changes did cause other problems, so i reverted back to the original (took of the _hold one by one and tested the blog in between) wp_ file and it still loaded my posts fine.

hope that helps… However if your wp_posts has 500 lines/posts, i’m not sure if this will fix your problem.