MySQL.md

Import

https://dev.mysql.com/doc/refman/5.5/en/optimizing-myisam-bulk-data-loading.html

https://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html

START TRANSACTION;
ALTER TABLE tbl_name DISABLE KEYS;
LOAD DATA INFILE 'whatever' INTO TABLE tbl_name;
ALTER TABLE tbl_name ENABLE KEYS;
END TRANSACTION;

Export

https://stackoverflow.com/questions/13484667/downloading-mysql-dump-from-command-line

https://dba.stackexchange.com/questions/9306/how-do-you-mysqldump-specific-tables

http://webcheatsheet.com/sql/mysql_backup_restore.php

One table

# export
mysqldump -u "USER" -p "DB_NAME" | gzip > db_backup_(date +%s).sql.gz

# import
gunzip db_backup_file.sql.gz && mysqldump -u "USER" -p "DB_NAME" < db_backup_file.sql