Migrating tables, which ones?

Hi,

I am building a new site in Drupal. Once built I want to import the user information from another site into the new site. This will allow users to login and view their information. Initially as a test I just want to migrate user information and roles. I have migrated the following:

tables:

  • users
  • users_roles
  • role
  • role_permission

I can successfully login, but I don’t get the admin menu. I have checked the ERD diagram at https://www.drupal.org/files/drupal7-db-schema.png, but I think I am missing something. I have checked the UID against the RID and I definately have administrator rights.

What am I missing? Can you help?

Thanks

Drupal version: 


Source: https://www.drupal.org/taxonomy/term/21/feed