Dashboard Not Available, possible fix?

[AndyT]

WHAT?
After new migration
Log into admin page
It should have gone straight to the dashboard.
Instead, website home page shows with wordpress menu bar across the top with no dashboard option to select.

HOW?
In Adminer (database tab in Localwp dashboard)
I checked out xx_usermeta and xx_users (xx= table prefix) as I had read on the net a possible fix to this issue is to add a new admin user via the database.
However I noticed that in xx_usermeta for the proper admin that some of the meta_key values that reference other tables had the the table prefix capitalised. Sure enough SQL is case sensitive.

FIX
I went through and edited all the appropriate meta_key values returning the table prefix to lower case, saved, and the normal admin now works as it should going straight through to the dashboard.

BUGFIX
add a crosscheck routine after import?

[ben.turner]

Hey @AndyT – yeah, it doesn’t happen often, but I’ve been bitten by case sensitivity related to MySQL table and column names.

This reply has more info and a link to documentation:

Database tables case issue

I’ve been taking a closer look at things and I think I have more information to help out with this issue. Thanks for you patience with this, and sorry for the delay – it’s been a tricky thing to zero in on. It looks like the general issue has to do with the fact that Windows’ file system is case-insensitive, while the remote, UNIX-y file system is case sensitive. Because Windows is case-insensitive, this can cause problems with MySQL when changing environments. The MySQL documentation goes int…

As I understand it, Windows is case insensitive, but issues can arise when changing to a different, unix-y environment and back.

As a general rule of thumb to allow maximum portability, I’d recommend having all the table names for your WordPress sites default to lowercase letters.

Hope that gives you some more context around this wacky issue!