Data loss is a terrible scenario for any organization that relies on databases to hold a crucial information. Whether it’s due to an unintentional loss, hardware failure, or software corruption, a backup solution is essential to ensure the data integrity and speedy recovery. MySQL and MariaDB offer robust data storing and retrieval capabilities. AutoMySQLBackup provides a dependable and effective solution to automate the backup and restore process to protect our databases.<\/p>\n
Let us discuss how to use the AutoMySQLBackup to create the automated backups of our MySQL and MariaDB databases, as well as restore them when necessary.<\/p>\n
Before doing anything, we have to install MySQL in our Linux system. After that, follow the further steps.<\/p>\n
We can create the database in MySQL or MariaDB. Here, we create the database in MySQL.<\/p>\n
Create the database first:<\/p>\n
Now, let us make a table named \u201clipi_tbl\u201d.<\/p>\n
After creating the table, we insert the values into the column and then select the table name for show.<\/p>\n
Let us install AutoMySQLBackup at first.<\/p>\n
In order to download and run the installation script, let’s start by making a working directory inside of \u201c\/opt\u201d:<\/p>\n
The AutoMySQLBackup configuration file named \u201cmyserver.conf\u201d is found at \u201c\/etc\/automysqlbackup\u201d. Let’s look at the most important configuration directives:<\/p>\n
After that, start configuring AutoMySQLBackup as per our need. Once we are complete with the configuration, just save it. It is strongly recommended to read the README file located in \u201c\/etc\/automysqlbackup\/README\u201d.<\/p>\n
When we’re ready, execute the program with the configuration file as an argument:<\/p>\n
Output:<\/strong><\/p>\n Now, navigate to the “\/var\/backup” backup directory to inspect the backup file.<\/p>\n A quick look at the daily directory reveals that AutoMySQLBackup is successful:<\/p>\n Set the crontab entry as shown in the following to take an AutoMySQLBackup every day at a certain time:<\/p>\n Now, let’s intentionally delete the \u201cmariadb_db\u201d database:<\/p>\n Let us recreate it and restore the backup. Enter the following command into the MariaDB prompt:<\/p>\n Then, specify where the backup must be restored.<\/p>\n The backup file should then be restored into the \u201cmaria_db\u201d database.<\/p>\n Output:<\/strong><\/p>\n AutoMySQLBackup automates the backup and restore, ensuring the data availability while minimizing the human error. We can protect our MySQL and MariaDB databases with this excellent approach. Integrate AutoMySQLBackup into our routine to improve the data protection and lower the chance of data loss. Secure our databases right away to ensure that our critical data is safely backed up and is rapidly recoverable.<\/p>","protected":false},"excerpt":{"rendered":" Comprehensive tutorial on how to use the AutoMySQLBackup to create the automated backups of our MySQL and MariaDB databases and restore them when necessary.<\/p>","protected":false},"author":111,"featured_media":22496,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[168],"tags":[],"class_list":["post-22493","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/22493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/111"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=22493"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/22493\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/22496"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=22493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=22493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=22493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\nParsed config file " \/etc\/automysqlbackup\/automysqlbackup.conf"
\n
\n# Checking for permissions to write to folders:
\n
\nbase folder \/var ... exists ... ok.
\n
\nbackup folder \/var\/backup ... creating ... success.<\/div><\/div>\n
\n
\n# ls -lR daily<\/div><\/div>\nRestore or Bring Back a MySQL Backup<\/strong><\/h2>\n
\n
\nEnter password:
\n
\nMariaDB [(none)]> show databases
\n
\n+--------------------+
\n
\n| Database |
\n
\n+--------------------+
\n
\n| information_schema |
\n
\n| maria_ |
\n
\n| maria_db |
\n
\n| mysql |
\n
\n| postgresql_db |
\n
\n+--------------------+
\n
\n6 rows in set (0.00 sec)
\n
\nMariaDB [(none)]> DROP DATABASE maria_db
\n
\nQuery OK, 1 row affected (0.06 sec)
\n
\nMariaDB [(none)]> show databases
\n
\n+--------------------+
\n
\n| Database |
\n
\n+--------------------+
\n
\n| information_schema |
\n
\n| maria_ |
\n
\n| mysql |
\n
\n| postgresql_db |
\n
\n+--------------------+
\n
\n5 rows in set (0.00 sec)<\/div><\/div>\n
\n
\nQuery OK, 1 row affected (0.00 sec)<\/div><\/div>\n
\n
\n# ls
\n
\ndaily_maria_db_2023-06-11_11h08m_Sunday.sql.gz<\/div><\/div>\n
\n
\nMariaDB [(none)]> SELECT * FROM lipi_tb1;<\/div><\/div>\n
\n
\n\/\/Enter your Password
\n
\nEnter password:
\n
\nMariaDB [(none)]> show databases
\n
\n+--------------------+
\n
\n| Database |
\n
\n+--------------------+
\n
\n| information_schema |
\n
\n| maria_ |
\n
\n| maria_db |
\n
\n| mysql |
\n
\n| postgresql_db |
\n
\n+--------------------+
\n
\n6 rows in set (0.00 sec)
\n
\nMariaDB [(none)]> use maria_db
\n
\nDatabase changed
\n
\n\/\/Showing our table which we created before
\n
\nMariaDB [maria_db]> select * from lipi_tbl;
\n
\n+--------+----------+----------+
\n
\n| UserID | UserName | IsActive |
\n
\n| 1 | Lipi | 1 |<\/div><\/div>\nConclusion<\/strong><\/h2>\n