femacourses

Alright, so just to summarize the solution I found for anyone having this same issue of deleting wp_options and not having a back up.

I went into wp-config.php. and changed the table prefix. I was using the prefix wpko_ before, and changed it to wp_ Then I fresh installed wordpress which created a new user. So now I had a site that I could access with my plugins, but no data for the plugins to work. I had to go back into phpymyadmin, and backed up the current version.

I DROPPED ALL TABLES FOR THE NEW WORDPRESS SITE **** EXCEPT**** FOR

wp_options
wp_users
wp_usermeta

Then I renamed all the tables for the old tables that used the wpko_prefix to the new prefix. *****EXCEPT***** FOR

wpko_options
wpko_users
wpko_usermeta

After that was all said and done, I had all my content. Then I had to go to each individual plugin settings and setup all again like I was setting up a new site.

remember if you reinstall wordpress keep the wp_options, wp_users, and wp_usermeta tables, and drop the old ones.

• This reply was modified 7 years ago by femacourses.
• This reply was modified 7 years ago by femacourses.

HUGE UPDATE

One of my experiments bore some fruit. So I went into wp-config file and then I changed the database prefix from wpko_ to wp_ like I did before, and used the install to see what would happen. Now I can enter the new site using an admin I created, and all my plugins are there.

BUT

I don’t have any of my plugin data. So should I import everything from wpko to wp? Or should I just rename all the prefixes?

Unfortunately my host says they don’t keep backups, I’m trying to find my backup of when I first installed the site in my email but I don’t see it. I’ve emailed google to restore all emails in the time period. Until then I have to actually fix the problem. I”m thinking just creating a fresh install of wordpress and manually importing everything other than the wp_options table? But I’ll wait until the person who was helping me replies.

From now on I’ll be writing in terms of experiments to try and help the expedition of debugging this problem.

I noticed that when I go to wp-content, themes, and then rename the folder twentynineteen, to twentynineteen.deactivate. Then I won’t get anything but blank pages when I log in using wp-login.php. So when that theme is active, I’m able to bring up a page that says “my blog” but I am not able to access the dashboard or any other settings.

Usring femacourses.com/wp admin during this time still says “sorry, you are not allowed to access this page.”

What can I do to access my dashboard?

http://prntscr.com/nq24lq

Now it shows this, with the new user I just created today.

ok I did wp-loging.php, using the new user and it says sorry you can’t access this page.