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
did you figure out the problem? i’m having same issue
Yes I found a Solution by chance.
Solution
- Go into Local Dashboard
- Click on ADMIN
- Still in Local dashboard - go the the Menu - DATABASE
- Then Click on Open Adminer
- Click on Select wp—usermeta
- Then in the menu above - click on Select Data
- 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
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?
Sorry for this late Reply, unfortunately I dont get flagged with local there is a message for me.
The Answer is YES
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
Hi @pirla - welcome to the Local community! 
Glad you got this sorted with the solution shared by another Local user!
Sam
This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.