Language Selection

English French German Italian Portuguese Spanish

Backup your MySQL databases automatically with AutoMySQLBackup

Filed under
HowTos

If you site relies on MySQL and stores its sensitive data in a MySQL database, you will most definitely want to backup that information so that it can be restored in case of any disaster (manual mistake to delete some data, software errors, hardware errors, server compromise, etc.). In a previous post I have presented that MySQL provides the basic tool (mysqldump) to perform database backups. This is required because backing up a database is a little different than backing up regular files.

With mysqldump anyone can write a small shell script and running it from cron, it will achieve an automatic backup solution. There are many such scripts already available freely and also many commercial solutions also (I assume as I have not tested any really Wink ). The script that I liked the most is AutoMySQLBackup, because it doesn’t have any real requirements (mysqldump of course is needed - in any mysql client package - and gzip or bzip2 to compress the resulting file) and has all the features I was looking for in such a script.

Full Story.

More in Tux Machines

MongoDB IPO

Graphics: Mesa 17.2.3, Libinput 1.9 and More

  • mesa 17.2.3
    Mesa 17.2.3 is now available. In this release we have: The Vulkan drivers ANV and RADV have multiple small fixes. The EGL code has improved handling of the new wl_dmabuf codepath. SWR no longer crashes when checking environment variables. Other gallium drivers have also seen updates - freedreno, nouveau and radeonsi. The gallivm module, used by llvmpipe et al. has gained little endian PPC64 fixes.
  • Mesa 17.2.3 Offers Vulkan Fixes, Gallium3D Updates
    Mesa 17.2.3 is now available as the latest bi-weekly update for this current stable driver series.
  • [ANNOUNCE] libinput 1.9.0
    libinput 1.9 is now available. As expected, not a lot of changes since the rc2: a few test fixes, a fix to stop excessive logging and an extra assert so we fail early in case of a bug.
  • Libinput 1.9 Released With Input Improvements, Requires Meson
    Peter Hutterer has today released libinput 1.9.0 as the latest version of this library used by both Wayland and X11 systems for unified input handling.
  • DRM Leasing Support To Land For Linux 4.15
  • Intel OpenGL Shader Cache Revised Once More
    The long ongoing work to implement an OpenGL/GLSL shader cache for the Intel Mesa driver has been revised once more with 32 new patches hitting the mailing list today.

Linux 4.13.8, 4.9.57, 4.4.93, 3.18.76 and Ubuntu Kernel Team Summary

Security: FUD, Adobe, Cybersecurity Improvement Act, Updates and More

  • Focusing on Healthcare Open Source Security Awareness [Ed: More Flexera marketing in the form of scare-mongering]
  • Adobe patches zero-day vulnerability used to plant gov't spying software
    Adobe has patched a zero-day vulnerability used by the BlackOasis APT to plant surveillance software developed by Gamma International. On Monday, researchers from Kaspersky Lab revealed the new, previously unknown vulnerability, which has been actively used in the wild by advanced persistent threat (APT) group BlackOasis.
  • IoT Cybersecurity: What's Plan B?
    In August, four US Senators introduced a bill designed to improve Internet of Things (IoT) security. The IoT Cybersecurity Improvement Act of 2017 is a modest piece of legislation. It doesn't regulate the IoT market. It doesn't single out any industries for particular attention, or force any companies to do anything. It doesn't even modify the liability laws for embedded software. Companies can continue to sell IoT devices with whatever lousy security they want.
  • Security updates for Wednesday
  • Security updates for Thursday
  • Abuse of RESTEasy Default Providers in JBoss EAP
    Red Hat JBoss Enterprise Application Platform (EAP) is a commonly used host for Restful webservices. A powerful but potentially dangerous feature of Restful webservices on JBoss EAP is the ability to accept any media type. If not configured to accept only a specific media type, JBoss EAP will dynamically process the request with the default provider matching the Content-Type HTTP Header which the client specifies. Some of the default providers where found to have vulnerabilities which have now been removed from JBoss EAP and it's upstream Restful webservice project, RESTEasy.
  • “Security concerns” lead to LTE service shutdown on Chinese Apple Watches