FoolFuuka: Difference between revisions

From Bibliotheca Anonoma
Line 11: Line 11:


* [[FoolFuuka/Start]] - Start up Asagi, Sphinxsearch, and FoolFuuka.
* [[FoolFuuka/Start]] - Start up Asagi, Sphinxsearch, and FoolFuuka.
* [[FoolFuuka/Import]] - Import data from the dumps.
* [[FoolFuuka/Troubleshooting]] - Restart the site if its down or troubleshoot if there are problems.
* [[FoolFuuka/Troubleshooting]] - Restart the site if its down or troubleshoot if there are problems.
* [[FoolFuuka/Upgrading]] - Upgrade FoolFuuka to the latest version.
* [[FoolFuuka/Upgrading]] - Upgrade FoolFuuka to the latest version.

Revision as of 04:43, 2 January 2019

FoolFuuka is a PHP web viewer paired with the Asagi archiver. It was developed by the FoolCode team who originally made this fork for archive.foolz.us. Currently, it is maintained by 4plebs.

Installation

Administration

Backups

FoolFuuka/Asagi is notorious for their large and unwieldy database. We use this command to do daily and weekly dumps without getting locking problems.

mysqldump -u $DB_user -h $DB_host -p$DB_pass --opt --single-transaction --quick --lock-tables=false $DB $t | gzip > $DIR/$DB-$t.sql.gz

Dumping FoolFuuka Tables without leaking IPs or Passwords

Don't just release the bare SQL dump into the wild. This script will dump to CSV, which is actually quite easy to import back.

SELECT `doc_id`, `media_id`, `num`, `subnum`, `thread_num`, `op`, `timestamp`, `timestamp_expired`, `preview_orig`, `preview_w`, `preview_h`, `media_filename`, `media_w`, `media_h`, `media_size`, `media_hash`, `media_orig`, `spoiler`, `deleted`, `capcode`, `email`, `name`, `trip`, `title`, `comment`, `sticky`, `locked`, `poster_hash`, `poster_country`, `exif`
FROM `pol`
INTO OUTFILE "/tmp/a.csv"
  FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  LINES TERMINATED BY "\n";

Automatic Full SQL DB Backups

   /home/atc/sql/full.sh

That script back up foolfuuka rbt_foolfuuka asagi

Iterates through each DB

/home/atc/sql/desu - Writes gzip’d SQL files here (normal to be empty)

Uploads to encrypted RClone folder