pajtaiWhen I looked at my site this morning there was a message that the database could not be accessed. I could not see my site or get into the admin panel. I had somehow accidentally deleted the hostname for my database. This may have happened because I moved my site from a subdomain and deleted the subdomain. I think the hostname was associated with the subdomain. My database, however appeared fine, but it had no associated host name. I created a new hostname and put it into the wp-config.php file. This brought me to a page that looked like I was just installing WP for the first time.
When I look at my DB it turns out I have two sets of tables. One set begins w/ "wp_dgmboj_" and in my wp-config.php file the $table_prefix was set for this. I don't know how this happened, since all the wp_dgmboj_ tables are essentially the ones for a new install. Looking at the times they were created when I created my new hostname.
There is a second set of tables that begins w "wp_y736ch_" these contain my pre existing site.
When I set $table_prefix to wp_y736ch_ my original homepage became accessible and I can now log in to my admin page and see all my old posts, pages, media, comments, etc........ but I can't access any of my site pages except for my home page!
I'm not sure how to track the problem down. All the settings in my adming panel are unchanged, my posts and pages are visible through my adming panel, but not through my site. I still have to sets of tables in my database, which seems odd.
Thanks for any help / suggestions,
Peter.
------------------------------
UPDATE:
Well, everything works now. I guess it took some time for the new hostname to propagate.
Do the table prefixes have any sort of significance? I guess I'll just delete the second set of tables.
I'm still not sure I understand why this happened. The transfer from the subdomain was fine. And the delete of the subdomain also happened without a hitch. But then about 12 hours later all the problems occurred.
Sorry about all the commotion... the whole thing was sort of odd. If anyone can answer the question of why creating a new host name created a second set of tables (as far as I can tell) that'd be great.
