Export OpenPanel mysql database tables

export_openpanel_mysql.sh

#!/bin/bash
mysql --database=panel -e "SHOW TABLES;" -s --skip-column-names | \
while read table; do
    echo "Dumping $table"
    echo "SHOW CREATE TABLE \`$table\`;" >> panel_full_dump.sql
    mysql --database=panel -e "SHOW CREATE TABLE \`$table\`\G" | \
        grep -v '^\*\*\*' >> panel_full_dump.sql
    mysql --database=panel -e "SELECT * FROM \`$table\`;" --skip-column-names | \
        awk -v tbl="$table" 'BEGIN {print "INSERT INTO `" tbl "` VALUES"} \
        {printf "("; for(i=1; i<=NF; i++) { printf "\"%s\"", $i; if(i<NF) printf ","; } print "),"} END {print ";"}' >> panel_full_dump.sql
done