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