Example
If you have installed the software as described in Installing the Escenic Community
Expansion software, 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 tables tables-stats constants constants-stats views-stats; 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 tables tables-stats constants constants-stats views-stats; do for ele in `find -L /opt/escenic/community-engine/ -name "$el.sql" | grep oracle`; do sqlplus eceuser/ecepassword @$ele done done