/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

12 votes317 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote328 views1 answer
Oracle step procedure
SQL
6 votes329 views1 answer
T-sql test if table exists
SQL
3 votes325 views1 answer
Pl sql escape &
SQL
0 vote317 views1 answer
Mysql check datetime equals date
SQL
1 vote340 views1 answer
Sql dcl
SQL
2 votes368 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote303 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote327 views1 answer
Firebird where
SQL
0 vote324 views1 answer
Create table sql generator
SQL