comic stash app

  • gcd database dump in mysql format
  • on arch install mariadb
    pacman -S mariadb
    mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
    systemctl start mariadb
    mysql -u root -p  # empty password
    create user 'gcd'@'localhost' idetified by 'gcddump';
    create database gcd;
    grant all privileges on gcd.* to 'gcd'@'localhost';
    flush privileges;
    quit;
  • download current database from https://www.comics.org/download
  • import database
    cd ~/tmp
    unzip current.zip
    mysql -u gcd -p
    use gcd;
    source YYYY-MM-DD.sql