diff options
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/gdgentools.pm | 2 | ||||
| -rwxr-xr-x | scripts/gdimport.pl | 3 | ||||
| -rwxr-xr-x | scripts/make-empty-db | 16 |
3 files changed, 10 insertions, 11 deletions
diff --git a/scripts/gdgentools.pm b/scripts/gdgentools.pm index 3522302..aadc5c7 100755 --- a/scripts/gdgentools.pm +++ b/scripts/gdgentools.pm @@ -12,7 +12,7 @@ package gdgentools; ### General tool routines -use lib '/home/andi/muggle/import'; +use lib '/home/lvw/Development/muggle-import/scripts'; use gdparams; use IO::Socket; diff --git a/scripts/gdimport.pl b/scripts/gdimport.pl index 6c8f548..438b07c 100755 --- a/scripts/gdimport.pl +++ b/scripts/gdimport.pl @@ -16,7 +16,8 @@ # inclusion of mp3 tracks and a proper update of the database. -use lib '/home/andi/muggle/import'; +use lib '/home/lvw/Development/muggle-plugin/scripts'; +#use lib '/home/andi/muggle/import'; use gdparams; use gdgentools; use gddb; diff --git a/scripts/make-empty-db b/scripts/make-empty-db index 7157539..59d2c21 100755 --- a/scripts/make-empty-db +++ b/scripts/make-empty-db @@ -1,24 +1,22 @@ #!/bin/sh -export SCRIPTDIR=/home/andi/muggle/import +export SCRIPTDIR=/home/lvw/Development/muggle-plugin/scripts cd $SCRIPTDIR echo "creating db" -mysql < createdb.mysql +mysql -u root < createdb.mysql echo "creating tables" -mysql < $SCRIPTDIR/createtables.mysql +mysql -u root < $SCRIPTDIR/createtables.mysql echo "reading genres" -echo " use GiantDisc; load data local infile '$SCRIPTDIR/genres.txt' into table genre;"| mysql --local-infile=1 - +echo " use GiantDisc; load data local infile '$SCRIPTDIR/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 --local-infile=1 +echo "use GiantDisc; load data local infile '$SCRIPTDIR/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 --local-infile=1 - +echo "use GiantDisc; load data local infile '$SCRIPTDIR/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 --local-infile=1 +echo "use GiantDisc; load data local infile '$SCRIPTDIR/sources.txt' into table language;" | mysql -u root --local-infile=1 |