'. SQL' split and merge large data backup files

'. SQL 'Big data backup file segmentation and merge for several GB big data backup files, if we encounter many problems during the data import process, and want to avoid inserting duplicate records, you need to split the file and extract the database table structure. Www.2cto.com uses the software “SQLDumpSplitter.exe to cut the exported data backup file. We can customize the size of each file. This software does not separate each record, this guarantees the integrity of each record. However, if a table contains a large amount of data, the insert operation is divided into several small files. Therefore, if the data node parameter needs to be modified during the import process, we must first Delete the table record and re-import it, which will inevitably lead to repeated records. While cutting data files, SQLDumpSplitter also saves the database table structure independently to facilitate database initialization. However, we have determined that the data import problem has been solved, and it is very cumbersome to import small data backup files one by one. What if it is thousands? Www.2cto.com so we need to use "file splitting and merging V1.5.exe" to merge these small files again and import the data backup files at one time. Note: you cannot use file splitting and merging V1.5 to cut the data backup file. It will split a record. SQL data backup files are cut using the dedicated Cutting Tool SQLDumpSplitter.