FoolFuuka: Difference between revisions
From Bibliotheca Anonoma
Antonizoon (talk | contribs) No edit summary |
Antonizoon (talk | contribs) |
||
| 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]] | ||
=== Dumping FoolFuuka Tables without leaking IPs or Passwords === | |||
It's easy and fast. | |||
{{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>}} | |||
== Backups == | == Backups == | ||
Revision as of 04:37, 4 December 2017
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
Dumping FoolFuuka Tables without leaking IPs or Passwords
It's easy and fast.
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";
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
