Import/Export MySQL "rapide"
export.sh Les données sont exporté avec mysqldump et le paramètre -T
-T : Creates tab separated textfile for each table to given path. (creates .sql and .txt files). NOTE: This only works if mysqldump is run on the same machine as the mysqld daemon. Ce script doit donc etre exécuté directement sur le serveur MySQL
Export #!/bin/bash DST='/var/backup/mysql/dump for bdd in `mysql --skip-column-names -B -e "show databases;" | egrep -v "^information_schema$|^mysql$"`; do echo -ne $bdd mysql --skip-column-names -B -e "SHOW CREATE DATABASE $bdd;" | cut -d" " -f2- > $DST/create-$bdd.
[Lire]