mysqldump -R -u user -ppassword --skip-add-drop-table dbname tablename | gzip -c > /tmp/tablename.sql.gz
テーブル定義を変更
zcat /tmp/tablename.sql.gz | mysql -u user -ppassword dbname
mysqldump -R -u user -ppassword --skip-add-drop-table dbname tablename | gzip -c > /tmp/tablename.sql.gz
テーブル定義を変更
zcat /tmp/tablename.sql.gz | mysql -u user -ppassword dbname