Putting large .txt files with a common delimiter separating the info into an SQL database

Hi! I have around 180GB of data that I need to put into a database, it is all in text files and the info is separated by a colon (Username:email). The files are around 300MB in size so I don’t really know how to go about it, I have looked everywhere. Does anyone know how I can achieve this? And if so could you help me? Many thanks!

For Mysql/MariaDB, Load Data Infile is your friend.

https://dev.mysql.com/doc/refman/8.0/en/load-data.html

1 Like

Many thanks! I’ll take a look :slight_smile:

Sponsor our Newsletter | Privacy Policy | Terms of Service