Skip to content

Instantly share code, notes, and snippets.

@vpnwall-services

vpnwall-services/MySQL_mydumper_myloader.md

Last active July 12, 2023 13:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vpnwall-services/5778a872f9b7669e2e38af89364ce292 to your computer and use it in GitHub Desktop.
Save vpnwall-services/5778a872f9b7669e2e38af89364ce292 to your computer and use it in GitHub Desktop.
Download ZIP
[MySQL mydumper/myloader] MySQL mydumper/myloader #bash #mysql #mydumper #myloader #backup #restore
Raw
MySQL_mydumper_myloader.md

  • Backup mydumper -B my_db -l 60 -o my_backup_temp_folder

  • Restore #-d for backup folder, -B for destination database, -t for threads count, -o for overwriting tables myloader -d ./ -B my_db -t 2 -o

  • Manually import massive datas without blocking

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
use my_database;
source file.sql --Import your sql dump file
SET foreign_key_checks = 1; # Remember to enable foreign key checks when procedure is complete!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment