NZEDb

Basic Installation

cd /srv
git clone https://github.com/nZEDb/nZEDb.git nzedb
cd nzedb
sudo chgrp www-data libs/smarty/templates_c www www/install resources/nzb nzedb/config
sudo chmod 775 libs/smarty/templates_c www www/install resources/nzb nzedb/config
sudo chgrp -R www-data resources/covers
sudo chmod -R 775 resources/covers
sed -i "s/nZEDb_CACHE_TYPE', 0/nZEDb_CACHE_TYPE', 1/" nzedb/config/settings.php

• Run the installer at http://example.com/install
• Activate "Tables Per Group (TPG)" in the site settings (if you have "innodb_file_per_table=1" for your MySQL server, which you should...)

• Convert all tables (except "parts") to InnoDB

php misc/testing/DB/convert_mysql_tables.php cinnodb-noparts

• Move Covers and NZBs to different storage

mv resources/covers resources/nzb /storage/nzedb/
ln -s /storage/nzedb/covers/ resources/covers
ln -s /storage/nzedb/nzb/ resources/nzb

Get PreDB Dumps

wget 'https://www.dropbox.com/s/qkmgbvmdv9a5w8q/predb_dump_08172015.tar.gz'
tar -zxvf predb_dump_08172015.tar.gz
php misc/testing/PreDB/dump_predb.php local tmp/predb_dump_08172015.csv
rm -r predb_dump_08172015.tar.gz tmp/predb_dump_08172015.csv
php cli/data/predb_import_daily_batch.php 0 local true

Enable IRC Scraper

cp nzedb/config/ircscraper_settings_example.php nzedb/config/ircscraper_settings.php
vi nzedb/config/ircscraper_settings.php

Enable Sphinx Search

sudo mv /etc/sphinxsearch/sphinx.conf /etc/sphinxsearch/bak_sphinx.conf
sudo cp misc/sphinxsearch/sphinx.conf /etc/sphinxsearch/sphinx.conf
sudo service sphinxsearch restart
cp nzedb/config/settings.example.php nzedb/config/settings.php
sed -i "s/nZEDb_RELEASE_SEARCH_TYPE', 0/nZEDb_RELEASE_SEARCH_TYPE', 2/" nzedb/config/settings.php
php misc/sphinxsearch/create_se_tables.php 0 9312
php misc/sphinxsearch/populate_rt_indexes.php releases_rt

Enable Comment Sharing

php misc/update/postprocess.php sharing true

Start TMUX

php /srv/nzedb/misc/update/nix/tmux/start.php