Skip to content

Instantly share code, notes, and snippets.

@palpalani

palpalani/larg-dump-import.sql

Last active August 31, 2017 12:13
Show Gist options
  • Save palpalani/0875e10d13e3b6005d6332ef4461f058 to your computer and use it in GitHub Desktop.
Save palpalani/0875e10d13e3b6005d6332ef4461f058 to your computer and use it in GitHub Desktop.
Download ZIP
Import a large sql dump file to a MySQL database from command line
Raw
larg-dump-import.sql
#!/bin/sh
#Refer https://cmanios.wordpress.com/2013/03/19/import-a-large-sql-dump-file-to-a-mysql-database-from-command-line/
# store start date to a variable
imeron=`date`
echo "Import started: OK"
dumpfile="/home/bob/bobiras.sql"
ddl="set names utf8; "
ddl="$ddl set global net_buffer_length=1000000;"
ddl="$ddl set global max_allowed_packet=1000000000; "
ddl="$ddl SET foreign_key_checks = 0; "
ddl="$ddl SET UNIQUE_CHECKS = 0; "
ddl="$ddl SET AUTOCOMMIT = 0; "
# if your dump file does not create a database, select one
ddl="$ddl USE jetdb; "
ddl="$ddl source $dumpfile; "
ddl="$ddl SET foreign_key_checks = 1; "
ddl="$ddl SET UNIQUE_CHECKS = 1; "
ddl="$ddl SET AUTOCOMMIT = 1; "
ddl="$ddl COMMIT ; "
echo "Import started: OK"
time mysql -h 127.0.0.1 -u root -proot -e "$ddl"
# store end date to a variable
imeron2=`date`
echo "Start import:$imeron"
echo "End import:$imeron2"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment