diff options
| author | wr61 <wr61@e10066b5-e1e2-0310-b819-94efdf66514b> | 2005-02-21 13:29:47 +0000 |
|---|---|---|
| committer | wr61 <wr61@e10066b5-e1e2-0310-b819-94efdf66514b> | 2005-02-21 13:29:47 +0000 |
| commit | d30fd8db8384ffe6c86a5c177798d60e581e8a17 (patch) | |
| tree | fb940ac1ab11a68b2c01f9188c5351554b418901 /scripts/make-empty-db | |
| parent | af1c206e1611651e5b0f714e38c5451a00efbbd8 (diff) | |
| parent | 3472518951059dd1b81330f54152534488c0d3c2 (diff) | |
| download | vdr-plugin-muggle-d30fd8db8384ffe6c86a5c177798d60e581e8a17.tar.gz vdr-plugin-muggle-d30fd8db8384ffe6c86a5c177798d60e581e8a17.tar.bz2 | |
git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/branches/0.1.3-wr@506 e10066b5-e1e2-0310-b819-94efdf66514b
Diffstat (limited to 'scripts/make-empty-db')
| -rwxr-xr-x | scripts/make-empty-db | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/scripts/make-empty-db b/scripts/make-empty-db new file mode 100755 index 0000000..92ccf75 --- /dev/null +++ b/scripts/make-empty-db @@ -0,0 +1,19 @@ +#!/bin/sh + +echo "creating db" +mysql -u root < createdb.mysql + +echo "creating tables" +mysql -u root < createtables.mysql + +echo "reading genres" +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 'languages.txt' into table language;" | mysql -u root --local-infile=1 + +echo "reading musictypes" +echo "use GiantDisc; load data local infile 'musictypes.txt' into table musictype;" | mysql -u root --local-infile=1 + +echo "reading sources" +echo "use GiantDisc; load data local infile 'sources.txt' into table source;" | mysql -u root --local-infile=1 |