Taking this large file and importing it to the database takes a very very long time (at least 40 minutes of plain waiting!). I will share with you the tutorials that I have found to be helpful in splitting text/csv files with GSplit.Ī large text file of 2.4 Gigabytes needs to be loaded into the SQL Database. I would like to share the tutorial below as I have personally encountered the critical need to split and restore a large text file of 44 million database records and restore it! Of course, next to this task is the complication of choking the production database as having it retrieve all 44 million records gobbles up the CPU and memory!! Wait a few more minutes while it does the import of the large database dump of 44 million records and it crashes the entire database! GSplit includes a lot of customization features for easily and safely splitting your files. It also creates a Self-Uniting program that automatically restores the original file with no requirement.
![gsplit portable gsplit portable](https://www.portablefreeware.com/screenshots/scrNRsjKa.gif)
GSplit is a powerful and free file splitter that lets you split your large files into a set of smaller files called pieces.
GSPLIT PORTABLE HOW TO
How to split large Code, Text, and Database files with GSplitĪre you a web developer working daily with hundreds to thousands of lines of code? Are you a web blogger and needing to backup, import and export your Wordpress databases? Are you an Analyst, needing to occasionally work with hundreds of megabytes of data exports an databases? Are you a Database Administrator and need to manage your ever growing database records?Įver had the nightmare of growing these data files so big that data export, import, and even recovery is impossible due to file size, and application limits!?