NOTE: For up-to date installation instructions please consult the README file distributed with videoDB. Manual installation or upgrading using database tools is no longer required. All changes are handled by the install.php script. The information on this page is outdated.

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)

VideoDB can

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.

If this script doesn't work for you, file a bugreport to the 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