/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

1 vote373 views1 answer
Mysql last year
SQL
9 votes340 views2 answers
Sql limit order by
SQL
1 vote345 views1 answer
Select if then postgresql
SQL
0 vote297 views1 answer
Calculate discount from original price sql
SQL
3 votes367 views3 answers
Stop mysql ubuntu
SQL
0 vote356 views1 answer
Not equal to blank in mysql
SQL
0 vote378 views1 answer
Como saber si tengo mysql instalado
SQL
-1 vote357 views2 answers
Postgresql user permissions to database
SQL
2 votes347 views1 answer
Sql update \
SQL
0 vote348 views3 answers
Insert or ignore postgres
SQL