/SQL/Mysql db dump restore max file size issue

Mysql db dump restore max file size issue

mysql -u root -p

set global net_buffer_length=1000000; --Set network buffer length to a large byte number

set global max_allowed_packet=1000000000; --Set maximum allowed packet size to a large byte number

SET foreign_key_checks = 0; --Disable foreign key checking to avoid delays,errors and unwanted behaviour

source file.sql --Import your sql dump file

SET foreign_key_checks = 1; --Remember to enable foreign key checks when procedure is complete!

Source: stackoverflow.com

Similar codes

0 vote444 views1 answer
How to get number of months between 2 dates sql server
SQL
-1 vote409 views4 answers
Full outer join in sql
SQL
0 vote361 views1 answer
Mysql root permission denied lost
SQL
1 vote343 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote375 views1 answer
My sql data file extention
SQL
0 vote345 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
3 votes367 views2 answers
Oracle privileges users
SQL
54 votes577 views6 answers
Sql rename column
SQL
5 votes317 views1 answer
Postgres upsert
SQL
1 vote366 views1 answer
Sql select contem uma palavra
SQL