Title: Need help fixing wp_usermeta table
Last modified: January 7, 2017

---

# Need help fixing wp_usermeta table

 *  Resolved [Lisa](https://wordpress.org/support/users/lisafoxnet/)
 * (@lisafoxnet)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/need-help-fixing-wp_usermeta-table/)
 * Hi-
 * I moved a site from GoDaddy to A2hosting and now I can not access my admin area.
   When I try to log in, all I see is the Dashboard bar across the top (like you
   are editing the front end, or if you are only a subscriber). I do not see the
   WP dashboard that an administrator would see.
 * I moved the site by exporting the database in .sql format on GoDaddy. Then I 
   installed WP on A2 server, emptied the database and imported the GoDaddy SQL 
   file. Everything on the front end of the site is fine.
 * This is a single site, not a multisite.
 * Here is what I have tried so far:
    -deactivate/reactive both plugins and themes
   via FTP -uploaded a fresh copy of the wp-admin folder -got new SALT keys and 
   deleted browser cache/cookies -verified that my admin profile in wp_usermeta 
   does have user level 10
 * I put in a support ticket to A2hosting and they couldn’t figure it out either.
   They suggested I hire an expert WP developer. I’ve worked with WP for several
   years now and I’m not quite ready to throw in the towel. 🙂
 * Linux server using MYSQL 5.6 and PHP5.5.38
 * I’m comfortable navigating the tables in the database using PHPMyAdmin. Does 
   anyone have any idea what has gone wrong?

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/need-help-fixing-wp_usermeta-table/#post-8628067)
 * Is this the WP codex guide you followed:
    [https://codex.wordpress.org/Moving_WordPress](https://codex.wordpress.org/Moving_WordPress)
 *  Thread Starter [Lisa](https://wordpress.org/support/users/lisafoxnet/)
 * (@lisafoxnet)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/need-help-fixing-wp_usermeta-table/#post-8628076)
 * Hi, thanks for the quick response.
 * Yes, I did follow the recommended protocol if you are not changing URLs or directories.
   I did update the wp-config file with the new database name, user and password.
   I manually uploaded the files in the plugins, uploads and themes directories.
 *  Moderator [t-p](https://wordpress.org/support/users/t-p/)
 * (@t-p)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/need-help-fixing-wp_usermeta-table/#post-8628103)
 * please do not publish your personal info in these public forums.
 * I have deleted the screenshot.
 * Try [Enabling debugging ](http://codex.wordpress.org/Debugging_in_WordPress)and
   post the results.
 *  Thread Starter [Lisa](https://wordpress.org/support/users/lisafoxnet/)
 * (@lisafoxnet)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/need-help-fixing-wp_usermeta-table/#post-8628199)
 * Since it didn’t contain my username/password, I felt it was safe. Thanks for 
   looking out for me.
 * I enabled debug mode and there were 2 errors with plugins. I deleted those plugins
   and the error messages went away, but the problem of not seeing the admin dashboard
   remains.
 *  Thread Starter [Lisa](https://wordpress.org/support/users/lisafoxnet/)
 * (@lisafoxnet)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/need-help-fixing-wp_usermeta-table/#post-8628222)
 * Figured it out….
 * When I imported the GoDaddy SQL file into the new database, the table prefixes
   were not the standard wp_xxxx. I knew this, but decided to go ahead and change
   the table prefixes themselves, rather than change the wp-config file to match
   what the database table prefix actually was. Why I chose the harder route, I’m
   not sure. Maybe because it was late and I should have been in bed?
 * Anyway….
 * So I dumped the database, re-uploaded the GoDaddy SQL file and changed the wp-
   config file where it has the $table_prefix = xxxxx
 * Problem solved. I can now access the admin dashboard. Marking this topic closed.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Need help fixing wp_usermeta table’ is closed to new replies.

## Tags

 * [user](https://wordpress.org/support/topic-tag/user/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 2 participants
 * Last reply from: [Lisa](https://wordpress.org/support/users/lisafoxnet/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/need-help-fixing-wp_usermeta-table/#post-8628222)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics