# VideoDB - Documentation

Table of Contents

# Installation

The examples in this document assumes you're using Linux and Apache. The Apaches document root is in `/var/www` and 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 wich supports PHP (Apache recommended)
- A recent version of PHP 4, at least 4.1.0 is required
- A MySQL Database
- A WebBrowser (something new is probably better)

## First time installation

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

Example:

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

Then create a new database using the `install.sql` file in the `install` directory

Example:

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

Now edit the `config.inc.php` file to match your database settings.

Thats it. Now point your webbrowser to your new videodb and add some movies

## 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. Then apply the `upgrade.sql` to your database using the the `-f` parameter to ignore errors.

Example:

      $> mysql -p -f videodb < /var/www/videodb/install/upgrade.sql