longbox

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