If you ever had a problem with a MySQL Table being foobar because of a human error (or other bug), you might need to be able to restore only 1 single MySQL table. Restoring an entire Database may cause other data loss, and this is of course something we don’t want. So, if you have […]
Restore a single MySQL Table Read More »
Today I had to migrate a customer’s DNS server to a new server… This because the old server (a very old plesk instance) was end of life. As I have very good experiences with PowerDNS, we decided to migrate from Bind (Named) to PowerDNS. PowerDNS provides you with the utilities to do so, but I
Migrating a DNS server to PowerDNS Read More »
Want to add a user to MySQL that you can use for eg backups, monitoring,… or any other tasks this user needs to perform. (in this example a root user) Create a small definition define create_mysqlbckuser ( $mysqlrootpasswd = ”, ) { exec { “create_mysql_bck°user”: unless => “/usr/bin/mysqladmin -ubckuser -p’b4ckupP4ss’ status”, command => “/usr/bin/mysql -uroot
Puppet: Add MySQL User Read More »