Difference between revisions of "User:Alvonruff/ISFDB2 Notes"

From ISFDB
Jump to navigation Jump to search
Line 25: Line 25:
 
* systemctl enable mysqld
 
* systemctl enable mysqld
 
* systemctl start mysqld
 
* systemctl start mysqld
 +
* Issue: ''mysql''
 +
* While in mysql, issue the command: ''create database isfdb;''
 +
* While in mysql, issue the command: ''use isfdb;''
 +
* While in mysql, issue the command: ''alter database isfdb character set latin1 collate latin1_swedish_ci; ''
 +
* While in mysql, issue the command: ''source <<backupfile>>;'

Revision as of 11:27, 27 April 2022

The isfdb2 staging system is a minimal system, with few packages installed, which uses dnf instead of apt-get.

Prerequisites

The staging system a minimum configuration AlmaLinux system, which is a variant of Fedora Core. It's really intended for tight cloud installations, so almost everything is missing, and installation of packages is done with yum/dnf.

  • dnf install gcc
  • dnf install make
  • dnf install tar
  • dnf install zip.x86_64
  • dnf install bzip2.x86_64
  • dnf install wget
  • dnf install python2.x86_64

Apache

  • dnf install httpd
  • firewall-cmd --add-service=http --add-service=https --permanent
  • service httpd start

MySQL

  • dnf update
  • dnf module enable mysql:8.0
  • dnf install @mysql
  • systemctl enable mysqld
  • systemctl start mysqld
  • Issue: mysql
  • While in mysql, issue the command: create database isfdb;
  • While in mysql, issue the command: use isfdb;
  • While in mysql, issue the command: alter database isfdb character set latin1 collate latin1_swedish_ci;
  • While in mysql, issue the command: source <<backupfile>>;'