Atitit. Software GUI button and dashboard -- db database zone -- Solution to importing mysql SQL errors, atitit -- db

Source: Internet
Author: User
Tags mysql import

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!

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.