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

Android Leftovers

This week in KDE: Adaptive panel opacity and auto-restored unsaved documents in Kate!

A big Plasma feature was added this week: adaptive Plasma panel opacity! Now the panel and panel applets are more transparent than they were before, allowing more of a tint from the beautiful wallpaper on your desktop! But what’s this? You’re about to complain that you maximize all your windows so the increased transparency will look ugly? In fact, we now make your panel and panel applets 100% opaque when there are any maximized windows, ensuring no ugly effect! But what if you don’t want that either? Well, if you don’t want adaptive opacity we now let you make your panel and panel applets always transparent, or always opaque! Hopefully that should make everyone happy. Let’s give a round of applause to Niccolò Venerandi and Jan Blackquill for this work, which will show up in Plasma 5.22. Read more

Kubuntu Focus M2 Linux laptop now available with NVIDIA RTX 30x series graphics

The Kubuntu Focus M2 is a 4.4 pound laptop that ships with the Kubuntu GNU/Linux distribution pre-installed. First launched in October, the 4.4 pound notebook has a 15.6 inch, 144 Hz full HD matte display, an Intel Core i7-10875H octa-core processor and NVIDIA graphics. When the notebook launched last year it was available with NVIDIA RTX 20 GPUs, but now you can configure the system with up to RTX 3080 graphics. Entry-level configurations are also getting a price drop. Read more

Self-supported Red Hat Enterprise Linux Server virty users see stealth inflation

Red Hat Enterprise Linux Server has maintained the same starting price over the past few years. Now, changes to the way the software is licensed have doubled the cost for some self-support customers using virtual machines. The change dates back to 2019, when Red Hat said its Red Hat Enterprise Linux Server, Self-support (RH0197181) was in the process of being retired and has been superseded by Red Hat Enterprise Linux Server Entry Level, Self-support (RH00005). According to a Red Hat spokesperson, RH00005 debuted in 2013 and RH0197181 stopped being sold in 2015. Both of these RHEL SKUs sell, or were sold, for $349 in the US. But only the discontinued product allows the use of virtualization at the lowest price tier. Now customers who opted for the discontinued entry-level offering have found they need to pay more than twice as much ($799 for the standard tier) to run a guest VM on a physical system. What's more, Red Hat in its subscription guide declares that its self-supported option "is not intended for production environments," making it clear that self-supported commercial usage with VM support requires greater investment that before. Read more