kelliemaree

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.

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

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

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…

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

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

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

or did you mean this? copied from wp-config.php

* WordPress Database Table prefix.
*
* You can have multiple installations in one database if you give each a unique
* prefix. Only numbers, letters, and underscores please!
*/
$table_prefix = ‘wp_’;

govpatel, ive got no idea what you mean?
I’ve opened the wp-config.php but i dont know what i should be looking for in that file. Is this bit what you mean???

/** Database Charset to use in creating database tables. */
define(‘DB_CHARSET’, ‘utf8’);

thanks govpatel, permalinks are already set to default

site url https://www.kelliemaree.com/blog

thanks

and i’d try what pipeten suggested if i could understand the process…

only one db and i had my hosting company on the phone yesterday and we fixed the connections strings to make sure they were correct.

Ok, So i’ve got into phpmyadmin browsed the wp_h8lbjc_posts file and it shows all posts names etc, then backed up current db… then gone to import and gone through the import process using the file on my computer.

and it still it loads the default theme with zero posts… here is a link to a screen capture of the posts file :
https://www.kelliemaree.com/wp_h8lbjc_posts_snapshot.jpg

and the blog in question is https://www.kelliemaree.com/blog

it doesn’t look like they’ve actually restored the database file. ask them how to login to a database management tool like phpmyadmin and do it yourself.

I would be able to log into myphpadmin… but if i do i wouldn’t know where to go and what to change…?

Did you reset your .htaccess file after the move

Unless it’s done automatically… no i don’t believe so. What does that actually do/control?

when it comes to back end wp, i know very little