VideoDB

Installation

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:

  • A Webserver which supports PHP (Apache recommended)
  • A recent version of PHP, at least 4.3.2(in 2.x version) is required – PHP 5 works, too
  • A MySQL Database
  • A Webbrowser (something new with stylesheet support is probably better)

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.

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.

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