Parent Directory | Revision Log
try harder to drop database, reset passwords
1 | #!/bin/sh |
2 | |
3 | dropdb libdata || ( |
4 | sudo /etc/init.d/apache restart |
5 | dropdb libdata || exit; |
6 | ) |
7 | createdb libdata |
8 | |
9 | psql libdata < libdata.pgsql |
10 | psql libdata < libstats.pgsql |
11 | psql libdata < libsession.pgsql |
12 | |
13 | # reset all passwords to libdata (password file format isn't compatibile |
14 | # because MySQL is using password function and we are using md5 hash |
15 | psql libdata -c "update staff set password=md5('libdata') where staff_id > 1" |
Name | Value |
---|---|
svn:executable | * |
ViewVC Help | |
Powered by ViewVC 1.1.26 |