Atitit. Software GUI button and dashboard -- db database zone -- Solution to importing mysql SQL errors, atitit -- db
Atitit. Software GUI button and dashboard -- db database zone -- Solution to importing mysql SQL errors
Keyword: part after intercepting a text file
View the restriction of max_allowed_packet prompt
Target Server versions: 50524
3. mysql max_allowed_packet restrictions [phpmyadmin | source]
Show vari like '%'
Set max .. = 111111
Set global maxxx = 1111
Author: old wow's paw Attilax iron, EMAIL: 1466519819@qq.com
Reprinted please indicate Source: http://blog.csdn.net/attilax
In the middle, the big part of haolan, and Korean style have a tile behind it... no table is imported completely... access the table that says the child is not dead...
The Train of Thought in Russia is to take part of the SQL file and import it again... the intermediate file goes through Monkey blue... good import ..
The last part of the screenshot, 3. There is no software available on the Internet...
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 ("= ");
}
}
Iii. No import class k III. Click "OK...
Refer reference
Mysql5.5 SQL Backup File Import error Summary-Jingjing's blog .htm
Paip. mysql import error, prompt syntax exception .txt _ Unitils learning notes. htm
Atitit. sqlserver2008 export and import large table files to the database... oraclemysql-other comprehensive-red/Black Union .htm
Paip. navicat form mysql 100% CPU usage when importing text files-mysql database column-red/Black Union .htm
Paip. oracle query export to insert SQL-attilax column-blog channel-CSDN.NET.htm
Paip. oracle10g dmp File Import Summary-attilax column-blog channel-CSDN.NET.htm
How to import the SQL code in the dbsql file to the MYSQL database
Phpmyadmin: You can simply copy the code. Select a database, click SQL, and copy the database.
How to import SQL files to the mysql database
Open cmd first and then enter the mysql bin directory:
Cd D: \ soft \ wamp \ bin \ mysql \ mysql5.0.51b \ bin press ENTER
Mysql-u username-p password press ENTER
Source d: \ abc. SQL (pointing to your own directory) Press ENTER
OK!