stabile/support/bootstrapper/support/dump_steamengine_db_info.sh @ master
| 1 |
#!/bin/bash
|
|---|---|
| 2 |
|
| 3 |
## Written by Kasper Eenberg on Sept. 30 - 2011 on behalf of Cabo Communications ##
|
| 4 |
|
| 5 |
DESTDIR="sql" |
| 6 |
DATABASE='steamregister' |
| 7 |
TABLES=`mysql -u root -D $DATABASE -e 'show tables;' -ss` |
| 8 |
|
| 9 |
if [ ! -e $DESTDIR ] |
| 10 |
then
|
| 11 |
/bin/mkdir $DESTDIR
|
| 12 |
fi
|
| 13 |
|
| 14 |
/usr/bin/mysqldump --skip-add-drop-table -u root $DATABASE documentation > $DESTDIR/documentation.sqldump |
| 15 |
|
| 16 |
for i in $TABLES; do |
| 17 |
`mysqldump -d --skip-add-drop-table -u root $DATABASE $i > $DESTDIR/$i.sql` |
| 18 |
done
|