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