add a user / admin to a existing db-dump

hello dear community,

i wonder which fields in the db contain user data!?
Background: i have got a db-dump that comes shipped with a fully flegede wp-installation

and additionally a db – dump
so i have to add a use – otherwise i cannot log in into the installation.
#
the question is: how to do that – which fields / tables do we need to add here!? – a user.

How to do that on a db-dump?

look forward to hear from you

-- Dumping data for table <code>wpsu_user_data</code>
--

LOCK TABLES <code>wpsu_user_data</code> WRITE;
/*!40000 ALTER TABLE <code>wpsu_user_data</code> DISABLE KEYS */;
/*!40000 ALTER TABLE <code>wpsu_user_data</code> ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table <code>wpsu_usermeta</code>
--

DROP TABLE IF EXISTS <code>wpsu_usermeta</code>;
/*!40101 SET @saved_cs_client ? ? = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE <code>wpsu_usermeta</code> (
? <code>umeta_id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
? <code>user_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
? <code>meta_key</code> varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
? <code>meta_value</code> longtext COLLATE utf8mb4_unicode_520_ci,
? PRIMARY KEY (<code>umeta_id</code>),
? KEY <code>user_id</code> (<code>user_id</code>),
? KEY <code>meta_key</code> (<code>meta_key</code>(191))
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table <code>wpsu_usermeta</code>
--

LOCK TABLES <code>wpsu_usermeta</code> WRITE;

--
-- Table structure for table <code>wpsu_users</code>
--

DROP TABLE IF EXISTS <code>wpsu_users</code>;
/*!40101 SET @saved_cs_client ? ? = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE <code>wpsu_users</code> (
? <code>ID</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
? <code>user_login</code> varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
? <code>user_pass</code> varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
? <code>user_nicename</code> varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
? <code>user_email</code> varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
? <code>user_url</code> varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
? <code>user_registered</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
? <code>user_activation_key</code> varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
? <code>user_status</code> int(11) NOT NULL DEFAULT '0',
? <code>display_name</code> varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
? PRIMARY KEY (<code>ID</code>),
? KEY <code>user_login_key</code> (<code>user_login</code>),
? KEY <code>user_nicename</code> (<code>user_nicename</code>),
? KEY <code>user_email</code> (<code>user_email</code>)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table <code>wpsu_users</code>
--

LOCK TABLES <code>wpsu_users</code> WRITE;

• This topic was modified 2 years, 8 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic