/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

2 votes313 views1 answer
Rails execute sql
SQL
0 vote294 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote287 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote268 views1 answer
Mysql find non alphanumeric characters
SQL
3 votes303 views1 answer
Sql insert inserted id
SQL
0 vote284 views1 answer
Mysql default uuid
SQL
11 votes276 views2 answers
Docker create postgres db
SQL
15 votes278 views2 answers
Open postgress in terminal mac
SQL
2 votes245 views1 answer
Mysql admin u root p password change password
SQL
0 vote280 views1 answer
Login phpmyadmin without password
SQL