Sunday, September 13, 2020

How to AutoBackup MySQL on Ubuntu/Debian

Here is an utility program called "automysqlbackup" that is available in the Ubuntu repositories.

sudo apt-get install automysqlbackup

Run the command by typing:

sudo automysqlbackup
/etc/lib/automysqlbackup ls
daily  monthly weekly
/etc/lib/automysqlbackup/daily ls
koha_library test

Saturday, September 12, 2020

Reset MySQL Root Password on Ubuntu 16.04 / 17.10 and 18.04/20.04 LTS

sudo /etc/init.d/mysql stop

sudo mkdir /var/run/mysqld/

sudo chown mysql /var/run/mysqld/

sudo mysqld_safe --skip-grant-tables &

=======

You may promnt something like this… you may have to press the Enter keykoha@ubuntu:~mysqld_safe Logging to syslog.

2017-12-25T16:49:30.554646Z mysqld_safe Logging to '/var/log/mysql/error.log'.

2017-12-25T16:49:30.578079Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

2017-12-25T16:49:32.568746Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


[1]+  Done                    sudo mysqld_safe --skip-grant-tables

=======

sudo mysql -u root

use mysql;

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed


update user set authentication_string=PASSWORD("Newpassword")

where User='root';

flush privileges;
exit
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
Take Koha backup
Access mysql -h 127.0.0.1 -P 3306 -u root -p
Backup of Koha_library
mysqldump -u root -p koha_library > koha_library.sql

Installing Koha 23.05 on ubuntu

apt update sudo apt-get -y install sudo wget gnupg wget -q -O- https://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - sudo apt...