diff options
| author | lvw <lvw@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-08-23 06:36:25 +0000 |
|---|---|---|
| committer | lvw <lvw@e10066b5-e1e2-0310-b819-94efdf66514b> | 2004-08-23 06:36:25 +0000 |
| commit | 622c22ea45654d4741a900fa078bafa947b24177 (patch) | |
| tree | 3bb91389c820abd1f793bfa7f26bbf145856e707 /scripts/make-empty-db | |
| parent | 37ce84e62b46619cc0bfc5733159c07b88556754 (diff) | |
| download | vdr-plugin-muggle-622c22ea45654d4741a900fa078bafa947b24177.tar.gz vdr-plugin-muggle-622c22ea45654d4741a900fa078bafa947b24177.tar.bz2 | |
Initial version of an import module added
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@114 e10066b5-e1e2-0310-b819-94efdf66514b
Diffstat (limited to 'scripts/make-empty-db')
| -rwxr-xr-x | scripts/make-empty-db | 16 |
1 files changed, 7 insertions, 9 deletions
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 |