April 10, 2022 at 11:33 PM
Hi
Just reposting this cause I didn't see it on here, if it is on here let me know so ill take it down.
This database has over 50 million lines, I went ahead and split them into a million each, so there is over 50 files in the folder
total size 7.92 GB
Zipped: 2.3 GB
Use a text editor to open this SQL file
VALUES: -- Dumping structure for table influentia.abonne2
CREATE TABLE IF NOT EXISTS `abonne2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) DEFAULT NULL,
`idInsta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`nom` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`nbFollowers` int(11) DEFAULT NULL,
`nbFollowings` int(11) DEFAULT NULL,
`nbPosts` int(11) DEFAULT NULL,
`biography` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`lastUpdate` int(11) DEFAULT NULL,
`pro` int(11) DEFAULT NULL,
`private` int(11) DEFAULT NULL,
`city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`langue` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`genre` int(11) DEFAULT NULL,
`scriptGenrePasse` int(11) DEFAULT NULL,
`localisation` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`identifiant` bigint(20) DEFAULT NULL,
`usedScript4` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`grande_ville_id` int(11) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_A71E7E9AB96C1A39` (`idInsta`),
KEY `IDX_A71E7E9A12469DE2` (`category_id`),
KEY `IDX_A71E7E9AAFDEF94D` (`grande_ville_id`),
CONSTRAINT `FK_A71E7E9A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
CONSTRAINT `FK_A71E7E9AAFDEF94D` FOREIGN KEY (`grande_ville_id`) REFERENCES `grande_ville` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=340637866 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
#FREEYOUNGTHUG

Just reposting this cause I didn't see it on here, if it is on here let me know so ill take it down.
This database has over 50 million lines, I went ahead and split them into a million each, so there is over 50 files in the folder
total size 7.92 GB
Zipped: 2.3 GB
Use a text editor to open this SQL file
VALUES: -- Dumping structure for table influentia.abonne2
CREATE TABLE IF NOT EXISTS `abonne2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) DEFAULT NULL,
`idInsta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`nom` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`nbFollowers` int(11) DEFAULT NULL,
`nbFollowings` int(11) DEFAULT NULL,
`nbPosts` int(11) DEFAULT NULL,
`biography` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`lastUpdate` int(11) DEFAULT NULL,
`pro` int(11) DEFAULT NULL,
`private` int(11) DEFAULT NULL,
`city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`langue` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`genre` int(11) DEFAULT NULL,
`scriptGenrePasse` int(11) DEFAULT NULL,
`localisation` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`identifiant` bigint(20) DEFAULT NULL,
`usedScript4` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`grande_ville_id` int(11) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_A71E7E9AB96C1A39` (`idInsta`),
KEY `IDX_A71E7E9A12469DE2` (`category_id`),
KEY `IDX_A71E7E9AAFDEF94D` (`grande_ville_id`),
CONSTRAINT `FK_A71E7E9A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
CONSTRAINT `FK_A71E7E9AAFDEF94D` FOREIGN KEY (`grande_ville_id`) REFERENCES `grande_ville` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=340637866 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
#FREEYOUNGTHUG


