No WP Dashboard after clicking on Admin Button

WordPress Questions
1

After importing a life website - content folder and sql file that was zipped.
All works except when trying to access the WP Dashboard throught local Admin, I see the website
but no WP dashboard for me to do changes etc.

any help would be great

2

did you figure out the problem? i’m having same issue

3

Yes I found a Solution by chance.

Solution

  1. Go into Local Dashboard
  2. Click on ADMIN
  3. Still in Local dashboard - go the the Menu - DATABASE
  4. Then Click on Open Adminer
  5. Click on Select wp—usermeta
  6. Then in the menu above - click on Select Data
  7. Change all wp---- name to the same as your original SQL database

Example your sql data base was wpuser_ users
but local is wpUser_user - click on edit and change it back to wpuser_user

Make sure you change all the wp to match your sql database

Hope this works for you.
Cheers
Ronninet

1 Like
4

so do I have to go into my Wordpress website and see what my sql database names are and change it on local to the same names as my wordpress database?

5

Sorry for this late Reply, unfortunately I dont get flagged with local there is a message for me.
The Answer is YES

6

Thanks for this hidden trick !
I don’t understand why. (Maybe a case pb in local, nginx, db or wpress or php … to investigate ).

As I find difficult to change each nnE_ to nne_(nne is the prefix of my db as define in wp-config.php $table_prefix ) by hand, i do the following :
With VSC i copy/paste from the global sql the part relative to nne_usermeta starting at CREATE TABLE nne_usermeta into a new user_meta.sql file .
With vscode i replace all “nnE_” by “nne_” .
Then i go to adminer within local .
SQL request : DROP TABLE nne_usermeta
Import .file user_meta.sql
execute
And all my dashboard is back !

HTH
Thanks again .

1 Like
7

Hi @pirla - welcome to the Local community! :wave:

Glad you got this sorted with the solution shared by another Local user!

Sam

8

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.