FoolFuuka: Difference between revisions

From Bibliotheca Anonoma
No edit summary
(5 intermediate revisions by the same user not shown)
Line 3: Line 3:
== Installation ==
== Installation ==


* [[FoolFuuka/Install/Debian|Installing on Debian Jessie]]
<!-- * [[FoolFuuka/Install/Debian|Installing on Debian Jessie]] - This won't work -->
* [[FoolFuuka/Install/Ubuntu16|Installing on Ubuntu 16.04 LTS]]
* [[FoolFuuka/Install/Ubuntu16|Installing on Ubuntu 16.04 LTS]]
* [[FoolFuuka/Install/Windows|Installing on Windows, Apache, Mysql, PHP]] - Not recommended but it can work.
== 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.
<pre>
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
</pre>
=== 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.
{{bc|<nowiki>
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";
</nowiki>}}

Revision as of 14:21, 1 February 2018

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

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";