Nicovs' Blog – Page 3 – Some Random SysAdmin Stuff

Automysqlbackup: Skipping the data of table mysql.event

Leave a Comment / Uncategorized / Nico VS

When using automysqlbackup to dump your mysql databases, you might run into the following error: ###### WARNING ###### Errors reported during AutoMySQLBackup execution.. Backup failed Error log below.. — Warning: Skipping the data of table mysql.event. Specify the –events option explicitly. While you can of course change the automysqlbackup script itself, to add the following […]

Automysqlbackup: Skipping the data of table mysql.event Read More »

MsSQL Database: Drop connections

Leave a Comment / MsSQL, Windows / Nico VS

If you need to restore a Microsoft SQL Database, you might run into the problem that there are still users connection to the database. It’s not easy to drop those connections… lots of info that I find on google use ALTERDATABASE DB_NAME SET SINGLE_USER WITHROLLBACK IMMEDIATE –do stuff ALTERDATABASEDB_NAME SET MULTI_USER And this doesn’t always

MsSQL Database: Drop connections Read More »

Puppet on Windows: set Administrator password to never expires

Leave a Comment / Puppet, Windows / Nico VS

When maintaining windows server with puppet, it could be interesting to set your Administrator password to never expires. Since you want to manage your passwords through puppet, and not manually by some hyper active sysadmin, this comes in handy. Note the fact that it is wise to change passwords now and then 😉 On Windows

Puppet on Windows: set Administrator password to never expires Read More »