/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

21 votes255 views3 answers
Sql average
SQL
2 votes309 views1 answer
Sql compare strings
SQL
0 vote264 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote254 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote257 views1 answer
With_for_update sqlalchemy
SQL
0 vote259 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote261 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote241 views5 answers
Linq cheat sheet
SQL
7 votes240 views1 answer
Query delete duplicates
SQL
8 votes276 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL