Parent Directory | Revision Log
try harder to drop database, reset passwords
1 | dpavlin | 35 | #!/bin/sh |
2 | |||
3 | dpavlin | 40 | dropdb libdata || ( |
4 | sudo /etc/init.d/apache restart | ||
5 | dropdb libdata || exit; | ||
6 | ) | ||
7 | dpavlin | 35 | createdb libdata |
8 | |||
9 | psql libdata < libdata.pgsql | ||
10 | psql libdata < libstats.pgsql | ||
11 | psql libdata < libsession.pgsql | ||
12 | |||
13 | dpavlin | 40 | # 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 |