Admin panel not recognizing correct account

If you’ve got two different databases or two different sets of WordPress tables, then look at your wp-config.php file to make sure you are using the correct database and the correct $table_prefix (if your posts table is called xyz_posts then the $table_prefix is xyz_.

here is my best guess
your 2nd install has the same database and tables as your 1st install
iow, your 2nd install wp-config.php has the same db info (which is fine) and also the same $table_prefix (which is bad)

so – change the 2nd wp-config.php‘s table prefix to something else like
wp2_ and you will need to run the installer again

otherwise both blogs will be trying to share info with each other

if you don’t think this is what happened…not sure

edit – some moderators are up way too early

Wow you guys are up early! Thanks for the quick replies. How do I even get to that-is it in mysql? Super clueless here unfortunately. ??

Hopefully your host offers something like phpMyAdmin that allows you to manage MySQL databases.

What the Hostia (my hosting company) guy said this:

Please note that you have two different installation of WordPress made by our Elefante installer which used the same database. In the future I would advise you to use a different databases for your blogs, because when you use only one database all of the blogs tables can be overwritten.

Ok noted… so what now? Ugh. LIke I said, I do have a backup zip. I do have PHPmyAdmin for that I just have never used it before.

In the future I would advise you to use a different databases for your blogs, because when you use only one database all of the blogs tables can be overwritten.

Okay reading that as saying your original tables are now overwritten with the new installation…so you would need to restore your backup of the database from before the 2nd install. If you don’t have a database backup, then ask your host if they have one.

WordPress can handle multiple installs (e.g. multiple domains) in the same database as long as the wp-config.php defines a different $table_prefix for each install. I guess the Elefante installer ‘ignores’ that…

I went into PHPmyAdmin and the only thing I see when I click databases is this:

wp_comments
Browse: (7 Rows) wp_links
Browse: (161 Rows) wp_options
Browse: (2 Rows) wp_postmeta
Browse: (4 Rows) wp_posts
Browse: (2 Rows) wp_terms
Browse: (10 Rows) wp_term_relationships
Browse: (2 Rows) wp_term_taxonomy
Browse: (9 Rows) wp_usermeta
Browse: (1 Rows) wp_users
Browse: (18 Rows) wp_wpsb_users

The hosting service said that I could upload a backup by finding the .sql file… I don’t even think I have that. I went to where my files were on my site management panel and zipped them. Like my plugins, my headers, etc.

Not sure how to find the wp_config file. THanks and sorry you’re having to spell it out.

Hi Michael,

My host says it doesn’t keep backups. I backed up my files but I don’t know if I backed them up correctly… I didn’t export from PhpmyAdmin as I now think I maybe should have? I think I used a plugin on WordPress to back up my stuff and then I manually downloaded my files too. on Hostia I can see that I have my collection of files (i’m looking from my file manager, not in mysql databases) and then there’s a zip file that is what I believe to be my backup. It’s titled housewifehacks.com.zip and it’s about 34356 KB. Not sure how to even use that.

Thanks

Backing up your files typically means backing up the WordPress programs, your themes, plugins, and uploads (images and the like).

Backing up your database means your posts, pages, categories, tags, comments, users, and links are saved.

Which do you have?

Browse: (7 Rows) wp_links
Browse: (161 Rows) wp_options
Browse: (2 Rows) wp_postmeta
Browse: (4 Rows) wp_posts
Browse: (2 Rows) wp_terms
Browse: (10 Rows) wp_term_relationships
Browse: (2 Rows) wp_term_taxonomy
Browse: (9 Rows) wp_usermeta
Browse: (1 Rows) wp_users
Browse: (18 Rows) wp_wpsb_users

That certainly looks like a new install!

yeah i’m pretty sure my backup is the plugins and such…

I’m looking at my zip file…

a bunch of php files… like wp-settings, wp-login, wp-load, wp-feed etc. (many more) and also 3 folders wp-includes, wp-content, wp-admin

Learning my lesson for sure here. DOes this mean I’ve lost all my content? If so, what now-how to at least point things back to be able to get my old admin panel and have Housewife Hacks not have WordPress think it is really the other blog? I couldn’t find that file when I looked at PhpmyADmin. ??

Also at this point if that’s the case that I’ve lost my things do I just go ahead and reinstall wordpress on my primary site to overwrite again and have wordpress recognize that as my default? Then do I have to upload all of my files again?

DOes this mean I’ve lost all my content?

if you dont have a backup of your database — yes, thats what that means.

I couldn’t find that file when I looked at PhpmyADmin. ??

Files are not accessed using phpmyadmin – your database is..

wp-config.php is a file. Its in the zip you keep mentioning – notice you said this:

a bunch of php files… like wp-settings, wp-login, wp-load, wp-feed etc. (many more) and also 3 folders wp-includes, wp-content, wp-admin

since its a file, its also located within your web space, presumably at the root of your website.

—

At this point youre starting over. login to your blog, and change the title — that which currently refers to fit frugal whatever …

If you have a backup of your files, then you might upload those to your host.

You don’t really have to start over–see what whooami said…

But, if you want to start over with a clean install, upload all your files as just suggested, drop your database tables using phpMyAdmin, then do the wp-admin/install.php thing.

Get a plugin to backup your database. Two good possibilities:
https://www.ads-software.com/extend/plugins/wp-dbmanager/
https://www.ads-software.com/extend/plugins/wp-db-backup/

Ugh alrighty. To note, you people were about 1000 times more helpful than the paid support from my hosting service. Thanks much. I’ve learned the hard way I suppose.