/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 vote328 views1 answer
Sql check roles
SQL
1 vote325 views1 answer
How to fetch alternate records from two tables
SQL
0 vote322 views1 answer
How to find the most occuring in SQL
SQL
14 votes318 views3 answers
Alter foreign key
SQL
0 vote304 views1 answer
Odd record sql query
SQL
0 vote347 views1 answer
Mysql where sum > 0
SQL
1 vote259 views1 answer
Strict in postgres SQL
SQL
4 votes300 views1 answer
Create table if not exist in sqlite
SQL
0 vote313 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
17 votes323 views4 answers
Postgres list users
SQL