notes.splitbrain.org

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Installation (outdated) ======

**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 [[vdb: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)

VideoDB can

===== 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.


==== Manual Installation ====

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