mysql backup/restore using CSV files

gistfile1.txt

mysql backup/restore using CSV files
====================================

backup
------

#!/usr/bin/env bash
mysqldump -u root -p... database --no-data > /tmp/backup/database-schema.sql
mysqldump -u root -p... -t -T/tmp/backup database --fields-enclosed-by=\" --fields-terminated-by=,


restore
-------

#!/usr/bin/env bash
mysql -u root -p... database < /tmp/backup/database-schema.sql

if [ $? != 0 ]; then
        echo "error importing scheme"
        exit 1
fi

for i in `ls -1 /tmp/backup/*.txt`; do
        table=`basename $i .txt`

        echo $table
        mysql -u root -p... -e "USE database;
              SET SESSION character_set_database=utf8;
              SET SESSION character_set_server=utf8;
              SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
              LOAD DATA LOCAL INFILE '$i' INTO TABLE $table
              FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n';"
done