/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 vote178 views1 answer
Postgres drop type
SQL
4 votes215 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote182 views5 answers
Mode sql course
SQL
2 votes194 views1 answer
Oracle drop sequence if exists
SQL
1 vote210 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote221 views1 answer
Mysl like insert a variable
SQL
0 vote238 views1 answer
Insert query return id mysql
SQL
16 votes203 views5 answers
Select last row in sql
SQL
17 votes236 views6 answers
MySQL ORDER BY
SQL
3 votes307 views1 answer
Ssh check mysql version
SQL