The examples in this document assume you're using Linux and Apache. The webservers document root is typically /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.
VideoDB works with the typical LAMP and WAMP environments. Here are the requirements in detail:
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.
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.
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.
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