FoolFuuka/Import

From Bibliotheca Anonoma
Revision as of 04:44, 2 January 2019 by Antonizoon (talk | contribs) (Created page with "== Import Process -- external archives (ex. When original archive.moe died) == * Be careful & make sure file does not try to create a DB, especially one named asagi or foolfu...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Import Process -- external archives (ex. When original archive.moe died)[edit]

  • Be careful & make sure file does not try to create a DB, especially one named asagi or foolfuuka
    • Can test on local machine or can use HEAD to check the first few lines
    • If you only see CREATE TABLE, then you’re clear
  • Mysql - u root
    • CREATE DATABASE ‘tmpimport’;
    • Quit
  • Import the SQL dump
    • GZIP: pv import.sql.gz | gunzip | mysql -u root -p tmpimport
    • Regular file: import.sql | mysql -u root -p tmpimport
  • cd /home/atc/asagi-toolkit/
    • php fuuka migrate --asagi-mode -d <database> -s 1 -b <board>
    • EX: php fuuka migrate --asagi-mode -d tmpimport -s 1 -b b
  • No problem if it crashes, it saves state & will resume
  • Recommend running inside tmux / screen
    • Takes a long long time