export mysql tables and schema

diff --git a/export-csv.sh b/export-csv.sh
new file mode 100755 (executable)
index 0000000..35572e0
--- /dev/null
+++ b/export-csv.sh
@@ -0,0 +1,27 @@
+#!/bin/sh -e
+
+table=aqorders
+
+mysql() {
+       echo $1 | koha-mysql ffzg > $2
+}
+create_table() {
+       test -e sql/$1.sql && return
+       echo "set sql_mode=ansi ; show create table $1\G" | koha-mysql ffzg | \
+               grep -v -E '(^\*|^ *Table: )' | sed 's/Create Table: //' > sql/$1.sql
+       ls --full-time sql/$1.sql
+}
+
+csv_dump() {
+       test -e /var/lib/mysql/koha/$1.csv && return
+       echo "SELECT * INTO OUTFILE '$1.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM $1" | koha-mysql ffzg
+       ls --full-time /var/lib/mysql/koha/$1.csv
+}
+
+create_table $table
+csv_dump $table
+
+grep REFERENCES sql/*.sql  | sed 's/^.*REFERENCES "\([^"]*\)".*$/\1/' | while read table ; do
+       create_table $table
+       csv_dump $table
+done