Example
If you have installed the software as described in Installing Dashboard, you may follow this example on how to
install all the VCE database scripts on a mysql
database running on a server called dbhost
with the
schema ecedb
, user name eceuser
and password ecepassword
:
$ for el in constants; do for ele in `find -L /opt/escenic/community-engine/ -name "$el.sql" | grep mysql`; do mysql -u eceuser -pecepassword -h dbhost ecedb < $ele done done
The equivalent for Oracle DB would be:
$ for el in constants; do for ele in `find -L /opt/escenic/community-engine/ -name "$el.sql" | grep oracle`; do sqlplus eceuser/ecepassword @$ele done done