如何将一个较大的MySQL备份文件拆分为多个文件? [英] How do I split a large MySQL backup file into multiple files?

问题描述

我有一个 250 MB 备份 SQL 文件，但是对新主机的限制仅为 100 MB ...

是否有一个程序可以让您将一个SQL文件拆分为多个SQL文件?

解决方案

您可以在Eclipse中拆分大文件.我已经在Windows中成功尝试了一个105GB的文件:

只需将 MySQLDumpSplitter 库添加到您的项目中: http://dl.bintray.com/verace/MySQLDumpSplitter/jar/

有关如何导入的快速说明:

• 在Eclipse中，右键单击您的项目-> 导入
• 选择文件系统，然后选择下一步
• 浏览jar文件的路径，然后按确定
• 选择(加厚)MySQLDumpSplitter.jar文件，然后完成
• 它将被添加到您的项目中，并显示在Eclipse的Package Explorer中的项目文件夹中
• 双击Eclipse中的jar文件(在Package Explorer中)
• MySQL转储文件拆分器窗口打开，您可以指定转储文件的地址并继续进行拆分.

I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB...

Is there a program that let's you split an SQL file into multiple SQL files?

解决方案

You can split a large file in Eclipse. I have tried a 105GB file in Windows successfully:

Just add the MySQLDumpSplitter library to your project: http://dl.bintray.com/verace/MySQLDumpSplitter/jar/

Quick note on how to import:

• In Eclipse, Right click on your project --> Import
• Select File System and then Next
• Browse the path of the jar file and press Ok
• Select (thick) the MySQLDumpSplitter.jar file and then Finish
• It will be added to your project and shown in the project folder in Package Explorer in Eclipse
• Double click on the jar file in Eclipse (in Package Explorer)
• The MySQL Dump file splitter window opens which you can specify the address of your dump file and proceed with split.

这篇关于如何将一个较大的MySQL备份文件拆分为多个文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！