Atitit. Software GUI buttons and dashboards--db database area--the solution to importing MySQL SQL errors

Source: Internet
Author: User
Tags import database mysql import

Atitit. Software GUI buttons and dashboards--db database area-- the solution to importing mysql SQL errors

Keyword:: Intercept text file after section

View Tips Max_allowed_packet Restrictions

Target Server version:50524

3. mysql max_allowed_packet limit "phpMyAdmin | Source

Show vari like '% '

Set Max: =111111

Set Global maxxx=1111

Author:: Old Wow's paw attilax Ayron, email:[email protected]

Reprint please indicate source: Http://blog.csdn.net/attilax

In the middle, the big part good orchid,,, Korea has the back of a watt not ... Not a table has not been imported completely ... Access to say that the heart is not dead behind the table ...

The Russian idea is to intercept the SQL file after part, and then import: Intermediate file Go Naan monkey orchid. Good import:

After the interception section, three, the internet has not been a software, son good GA self-write LAN ...

Public class filesplitor {

Static Integer counter=0;

/**

 *  @param args

 *  @throws IOException

*/

Public  static void main (string[] args) throws IOException {

//  TODO auto-generated Method Stubart

Final int start = 252686;

String s = "D:\\website\\watchestank\\public_html\\watchestank_0422.sql" ;

Final Filex c= New Filex ("C:\\sql2.sql");

Filex. read_hp (S, "Utf-8", new Closure() {

@Override

Public Object Execute (object arg0) throws Exception {

//  TODO auto-generated Method Stub

if (counter<100)

System. out . println (Arg0.tostring ());

counter ++;

if (counter>=start)

c.append_hp (arg0.tostring () +"\ r \ n");

return null;

}

});

C.close ();

System. out . println ("= =");

}

}

Three, not an import class K three, a hanging off OK lan ... The Day monster ...

Refer Reference

Mysql5.5 Summary of error issues with importing SQL backup files-jingjing's blog. htm

Paip.mysql import error, prompting syntax exception. Txt_unitils study notes __ script Blackstone. htm

atitit.sqlserver2008 Export Import Database Large table file ... oraclemysql-Other synthesis-red and black alliance. htm

Paip.navicat form MySQL Import text file when CPU occupied 100% resolution-MySQL database column-Red and Black alliance. htm

Paip.oracle query Export to insert sql-attilax column-Blog channel-CSDN.NET.htm

paip.oracle10g DMP File Import Summary-attilax's Column-Blog channel-CSDN.NET.htm

Atitit. Software GUI buttons and dashboards--db database area--the solution to importing MySQL SQL errors

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.