====== VideoDB ======
[[http://wiki.splitbrain.org/vdb:features|Features]]
[[http://www.videodb.net/videodb/index.php|Demonstration]]
[[http://sourceforge.net/projects/videodb/|Sourceforge Projektseite]]

===== Download =====
http://surfnet.dl.sourceforge.net/sourceforge/videodb/videodb-2_2_1.tgz

====== Installation ======

The examples in this document assume you're using Linux and Apache. The webservers document root is typically ''/var/www'' and [[http://sourceforge.net/projects/videodb/|Videodb]] is to be installed in ''/var/www/videodb''. But it shouldn't be difficult for you to follow the steps with any other environment.

===== Requirements =====

VideoDB works with the typical LAMP and WAMP environments. Here are the requirements in detail:

    * A Webserver which supports PHP ([[http://httpd.apache.org|Apache]] recommended)
    * A recent version of [[http://www.php.net|PHP]], at least **4.3.2**(in 2.x version) is required -- PHP 5 works, too
    * A [[http://www.mysql.org|MySQL]] Database
    * A Webbrowser (something new with stylesheet support is probably better)

===== First time installation =====

Unzip the tarball into a directory below your webserver document root and make the cachedirectories writable.

Example:

  $> cd /var/www
  $> tar -xzvf ~/videodb-*.tgz
  $> chmod 777 videodb/cache/*


You can then use the installer script to create your database. Just point your browser to ''http://www.hemptec.pointclark.net/videodb/install.php'' and follow the instructions.

<file>
For security reasons this file (install.php) should be deleted after the installation. You can later adjust the database settings by modifying the ./config.inc.php file.
</file>

==== Manual Installation ====

If this script doesn't work for you, file a bugreport to the [[http://wiki.splitbrain.org/vdb:mailinglist]] and create the database yourself by using the ''createtables.sql'' file in the ''doc'' directory.

Example:

  $> mysqladmin -p create videodb
  $> mysql -p videodb < /var/www/videodb/doc/createtables.sql

Now edit the ''/videodb/config.inc.php'' file to match your database settings.

===== Update from a previous version =====

For updating from a previous version just delete all files but the cache directory and keep your database. Then unzip the new tarball as described above.

When opening the videoDB index page, videoDB will automatically recognize that a new database version is required and run the installer. Alternatively, you may call the ''install.php'' to upgrade your database or apply the ''updatedb.sql'' by using mysql's ''-f'' switch to ignore errors.

Example:

  $> mysql -p -f videodb < /var/www/videodb/doc/updatedb.sql