blob: 92ccf7500169ebcdf1bd8df8057669f3119c2ef8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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
|
