'. SQL' split and merge large data backup files

Source: Internet
Author: User


'. 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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.