diff options
author | lvw <lvw@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-08-29 14:07:53 +0000 |
---|---|---|
committer | lvw <lvw@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-08-29 14:07:53 +0000 |
commit | 27a9843da016ffb5d2d36f03b3ae20776528989b (patch) | |
tree | 9ca981bc30cd4e6ff536b0902c987788aa3c8e20 /scripts/make-empty-db | |
parent | e287c9b102fe10877f19f7b3c3e10c62209adbce (diff) | |
download | vdr-plugin-muggle-27a9843da016ffb5d2d36f03b3ae20776528989b.tar.gz vdr-plugin-muggle-27a9843da016ffb5d2d36f03b3ae20776528989b.tar.bz2 |
Cleaned up input helper scripts
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@126 e10066b5-e1e2-0310-b819-94efdf66514b
Diffstat (limited to 'scripts/make-empty-db')
-rwxr-xr-x | scripts/make-empty-db | 13 |
1 files changed, 5 insertions, 8 deletions
diff --git a/scripts/make-empty-db b/scripts/make-empty-db index 59d2c21..3acb512 100755 --- a/scripts/make-empty-db +++ b/scripts/make-empty-db @@ -1,22 +1,19 @@ #!/bin/sh -export SCRIPTDIR=/home/lvw/Development/muggle-plugin/scripts -cd $SCRIPTDIR - echo "creating db" mysql -u root < createdb.mysql echo "creating tables" -mysql -u root < $SCRIPTDIR/createtables.mysql +mysql -u root < createtables.mysql echo "reading genres" -echo " use GiantDisc; load data local infile '$SCRIPTDIR/genres.txt' into table genre;"| mysql -u root --local-infile=1 +echo " use GiantDisc; load data local infile 'genres.txt' into table genre;"| mysql -u root --local-infile=1 echo "reading languages" -echo "use GiantDisc; load data local infile '$SCRIPTDIR/languages.txt' into table language;" | mysql -u root --local-infile=1 +echo "use GiantDisc; load data local infile 'languages.txt' into table language;" | mysql -u root --local-infile=1 echo "reading musictypes" -echo "use GiantDisc; load data local infile '$SCRIPTDIR/musictypes.txt' into table language;" | mysql -u root --local-infile=1 +echo "use GiantDisc; load data local infile 'musictypes.txt' into table language;" | mysql -u root --local-infile=1 echo "reading sources" -echo "use GiantDisc; load data local infile '$SCRIPTDIR/sources.txt' into table language;" | mysql -u root --local-infile=1 +echo "use GiantDisc; load data local infile 'sources.txt' into table language;" | mysql -u root --local-infile=1 |