Backing Up MySQL Databases with MySQL Backups Manager
DATA SAVER
Your web hoster is fine with serving up HTML, but when it comes to backing up a simple MySQL database, you are often on your own. Or are you?
Even if you are running a small, non-commercial website, the data you store in a MySQL database is very important to you. If that database is frequently changed on a live system, a reliable backup becomes even more important. Unfortunately, the tools that web hosters provide to backup your data are often cumbersome at best. I recently made a number of major changes to the database on my test system and became concerned about what would happen if I really hosed that database. I make regular backups myself on my local machine, by simply copying the MySQL files. This option works, but recovering from a crash has its own problems. So I started looking for other solutions. After considering several of the alternatives for backing up an SQL database (see the the box titled “MySQL Backup Alternatives”), I settled on indexsoft’s MySQL Backups Manager utility [1].
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
US / Canada
UK / Australia
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Find SysAdmin Jobs
News
-
KDE Plasma 5.27 Beta is Ready for Testing
The latest beta iteration of the KDE Plasma desktop is now available and includes some important additions and fixes.
-
Netrunner OS 23 Is Now Available
The latest version of this Linux distribution is now based on Debian Bullseye and is ready for installation and finally hits the KDE 5.20 branch of the desktop.
-
New Linux Distribution Built for Gamers
With a Gnome desktop that offers different layouts and a custom kernel, PikaOS is a great option for gamers of all types.
-
System76 Beefs Up Popular Pangolin Laptop
The darling of open-source-powered laptops and desktops will soon drop a new AMD Ryzen 7-powered version of their popular Pangolin laptop.
-
Nobara Project Is a Modified Version of Fedora with User-Friendly Fixes
If you're looking for a version of Fedora that includes third-party and proprietary packages, look no further than the Nobara Project.
-
Gnome 44 Now Has a Release Date
Gnome 44 will be officially released on March 22, 2023.
-
Nitrux 2.6 Available with Kernel 6.1 and a Major Change
The developers of Nitrux have officially released version 2.6 of their Linux distribution with plenty of new features to excite users.
-
Vanilla OS Initial Release Is Now Available
A stock GNOME experience with on-demand immutability finally sees its first production release.
-
Critical Linux Vulnerability Found to Impact SMB Servers
A Linux vulnerability with a CVSS score of 10 has been found to affect SMB servers and can lead to remote code execution.
-
Linux Mint 21.1 Now Available with Plenty of Look and Feel Changes
Vera has arrived and although it is still using kernel 5.15, there are plenty of improvements sure to please everyone.