55GB, (10GB compressed) Tiktok user sql users dump

Good luck



DROP TABLE IF EXISTS `author`;
/*!40101 SET @saved_cs_client    = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `author` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tiktok_id` bigint(20) unsigned NOT NULL,
  `uniqueId` varchar(1024) NOT NULL,
  `nickname` varchar(1024) NOT NULL,
  `avatarLarger` varchar(2048) NOT NULL,
  `signature` varchar(2048) NOT NULL,
  `verified` varchar(8) NOT NULL,
  `secUid` varchar(2048) NOT NULL,
  `relation` int(11) NOT NULL,
  `grabTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `searchBase` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tiktok_id` (`tiktok_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32065358 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

Thanx for this share...

but can you provide any sample?
what`s inside,date???

(May 6, 2022, 07:00 PM)cy0dagga77 Wrote: Thanx for this share...

but can you provide any sample?
what`s inside,date???

I am still importing the sql on my box right now lol

thanks

(May 6, 2022, 07:22 PM)GildaZZZ Wrote: thanx

enjoy :)

sample plz

its just a scrape usless

sample plz

can you provide any sample?

INSERT INTO `author` VALUES (9112,6731603630543504389,'chriscartertiktok','Chris Carter','https://p16-amd-va.tiktokcdn.com/img/musically-maliva-obj/70bc71bbfa4275f3571e01c5502fb7e0~c5_1080x1080.jpeg','I post what I like..Funny.Sad. Enlightenment. Subscribe to my YouTube  👆🏾 🎯SC','False','MS4wLjABAAAAYk0gsa3aULQKiyZfmvEpPFSzFc8rUGrxmxmxQE9d3VdNIsYRJgTL7D8OIFl883jo',0,'2020-08-19 14:47:40','trending'),(9113,6801922511212397573,'itsmynatural','Melody','https://p16-amd-va.tiktokcdn.com/img/musically-maliva-obj/1660626433464326~c5_1080x1080.jpeg','Proud Mama
Natural Hair Lover
27K?? 👀','False','MS4wLjABAAAAib4JV3QN6s2RO8PdljCsrXv0ys9t9hwP0T3sVCtsc7wBwQDi5K88hxiCtgUfGDCo',0,'2020-08-19 14:47:41','trending'),

just users profile scrape

DROP TABLE IF EXISTS `author`;
/*!40101 SET @saved_cs_client    = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `author` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tiktok_id` bigint(20) unsigned NOT NULL,
  `uniqueId` varchar(1024) NOT NULL,
  `nickname` varchar(1024) NOT NULL,
  `avatarLarger` varchar(2048) NOT NULL,
  `signature` varchar(2048) NOT NULL,
  `verified` varchar(8) NOT NULL,
  `secUid` varchar(2048) NOT NULL,
  `relation` int(11) NOT NULL,
  `grabTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `searchBase` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tiktok_id` (`tiktok_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32065358 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;