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.
Many thanks! I’ll take a look