MySQL - Export and Import free of troubles with Foreign Key Restriction From innoDB Tables

gistfile1.sh

# Export and pack
mysqldump -uUSER -pPASSWORD database_name --compact --host=HOST_IP_ADDRESS | gzip > mysqlbackup.sql.gz

# Unpack
gunzip mysqlbackup.sql.gz

# Importing free of troubles with Foreign Key Restriction From innoDB Tables
mysql -uUSER -pPASSWORD
# MySQL terminal
mysql> CREATE DATABASE database_name CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> USE database_name
mysql> SET foreign_key_checks = 0;
mysql> SOURCE mysqlbackup.sql
mysql> SET foreign_key_checks = 1;

# done! :-)