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...")
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