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