How to back up MySQL databases from the command line in Linux

Your Koha on Ubuntu 16.04 is up and running with on that server runs a database (or multiple databases) that must be backed up. 

There are various software options you could install to make that happen, but if you want to keep that server platform down to the bare minimum to avoid possible issues, chances are you'll want to work with the built-in tools to perform the backup. It's a good thing the koha administrator of MySQL thought of that

(here name of the database is koha_library on command you may enter root password or your koha db password)

# sudo mysqldump -p koha_library > /home/koha_library.sql

Installing SubjectPlus 4.2 on Ubuntu 16.04 LTS

SubjetcPlus is a free and open source tool to help you manage several interrelated parts of your library data

sudo apt update

sudo apt install mysql-server

sudo systemctl start mysql.service

then
CREATING USERS AND DATABASES

To create a MySQL database and user, follow these steps: At the command line, log in to MySQL as the root user:

mysql -u root -p

Type the MySQL root password, and then press Enter

CREATE DATABASE subjectplus;

CREATE USER sp@localhost;

SET PASSWORD FOR sp@localhost= PASSWORD("yourpassword");

GRANT ALL  ON `sp`.* TO `sp`@`localhost` IDENTIFIED BY 'yourpassword';

GRANT ALL PRIVILEGES ON subjectplus.* TO sp@localhost IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

SHOW DATABASES;

View All MySQL Databases

To view the database you’ve created simply issue the following command:

exit 

Your result should be similar to this:

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| spdb               |
| mysql              |
| test               |
| tutorial_database  |
+--------------------+
4 rows in set (0.00 sec)

sudo service apache2 restart

sudo service mysql restart

apt-get install unzip

mkdir -p /var/www/html/sp

wget https://github.com/subjectsplus/SubjectsPlus/archive/master.zipunzip -q /var/www/html/sp/master.zip




chown -R www-data.www-data /var/www/html/spchmod -R 755 /var/www/html/sp

URL http://localhost/sp/SubjectsPlus-master/