Thursday, February 21, 2019

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


No comments:

Create Superuser in Mysql

Login MySQL using mysql -u root -p CREATE USER 'superuser'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGE...