longbox.md (563B)
1 # longbox 2 3 comic stash app 4 5 * gcd database dump in mysql format 6 * on arch install mariadb 7 ``` 8 pacman -S mariadb 9 mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql 10 systemctl start mariadb 11 mysql -u root -p # empty password 12 create user 'gcd'@'localhost' idetified by 'gcddump'; 13 create database gcd; 14 grant all privileges on gcd.* to 'gcd'@'localhost'; 15 flush privileges; 16 quit; 17 ``` 18 * download current database from https://www.comics.org/download 19 * import database 20 ``` 21 cd ~/tmp 22 unzip current.zip 23 mysql -u gcd -p 24 use gcd; 25 source YYYY-MM-DD.sql 26 ```