/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 vote214 views1 answer
Alasql delete column
SQL
2 votes256 views1 answer
Postgresql group by month and year
SQL
0 vote225 views1 answer
Varchar2 length in oracle
SQL
0 vote207 views1 answer
How many columns can be used for creating index?
SQL
0 vote213 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote356 views1 answer
The differnece between to values in sql
SQL
0 vote245 views2 answers
Postgresql variable in query
SQL
1 vote209 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote216 views1 answer
Plsql find location of procedure
SQL
24 votes209 views4 answers
How to add column sql
SQL