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 | 254990b15f584578aeca3d361010d2bfa5f3d111 (patch) | |
| tree | 9b87e2064fbb0b0ccbdb43563150052c66ec8a69 /muggle-plugin/scripts/make-empty-db | |
| parent | a165f982bed4670c9f3f99ca141227a6ca7f5b85 (diff) | |
| download | vdr-plugin-muggle-254990b15f584578aeca3d361010d2bfa5f3d111.tar.gz vdr-plugin-muggle-254990b15f584578aeca3d361010d2bfa5f3d111.tar.bz2 | |
Cleaned up input helper scripts
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk@126 e10066b5-e1e2-0310-b819-94efdf66514b
Diffstat (limited to 'muggle-plugin/scripts/make-empty-db')
| -rwxr-xr-x | muggle-plugin/scripts/make-empty-db | 13 |
1 files changed, 5 insertions, 8 deletions
diff --git a/muggle-plugin/scripts/make-empty-db b/muggle-plugin/scripts/make-empty-db index 59d2c21..3acb512 100755 --- a/muggle-plugin/scripts/make-empty-db +++ b/muggle-plugin/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 |