diff options
| author | lvw <lvw@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-05-28 15:30:48 +0000 |
|---|---|---|
| committer | lvw <lvw@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-05-28 15:30:48 +0000 |
| commit | 2370a13b7f6512147550e5eec8a773e69d49119b (patch) | |
| tree | dcf92a706d71b2c21cebef1969298c761f74de2c /scripts/make-empty-db | |
| parent | 616adfc77dc1d08f3bfcd79991a78c6350e4e2f6 (diff) | |
| download | vdr-plugin-muggle-2370a13b7f6512147550e5eec8a773e69d49119b.tar.gz vdr-plugin-muggle-2370a13b7f6512147550e5eec8a773e69d49119b.tar.bz2 | |
Merged and added import scripts
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@99 e10066b5-e1e2-0310-b819-94efdf66514b
Diffstat (limited to 'scripts/make-empty-db')
| -rwxr-xr-x | scripts/make-empty-db | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/scripts/make-empty-db b/scripts/make-empty-db new file mode 100755 index 0000000..7157539 --- /dev/null +++ b/scripts/make-empty-db @@ -0,0 +1,24 @@ +#!/bin/sh + +export SCRIPTDIR=/home/andi/muggle/import +cd $SCRIPTDIR + +echo "creating db" +mysql < createdb.mysql + +echo "creating tables" +mysql < $SCRIPTDIR/createtables.mysql + +echo "reading genres" +echo " use GiantDisc; load data local infile '$SCRIPTDIR/genres.txt' into table genre;"| mysql --local-infile=1 + + +echo "reading languages" +echo "use GiantDisc; load data local infile '$SCRIPTDIR/languages.txt' into table language;" | mysql --local-infile=1 + +echo "reading musictypes" +echo "use GiantDisc; load data local infile '$SCRIPTDIR/musictypes.txt' into table language;" | mysql --local-infile=1 + + +echo "reading sources" +echo "use GiantDisc; load data local infile '$SCRIPTDIR/sources.txt' into table language;" | mysql --local-infile=1 |