Archive for the ‘ Administration ’ Category
The following batch file is a simple backup script for MySQL. It exports all databases into a temporary SQL dump file and compresses it using 7Zip into a file with the current date as its name. It also automatically deletes backups that are older than 30 days. Here is how to get started: Copy the batch file [ READ MORE ]
When installing the Microsoft Web Platform installer on Windows Home Server and enabling the UrlScan feature during setup, parts of the Windows Home Server Connector will stop functioning properly. In particular, the Windows Home Server Console will be unable to retrieve client updates from the server and instead respond with a “404 – Resource not [ READ MORE ]
I played around with the HeidiSQL front-end for MySQL and somehow managed to remove all privileges from the database’s root account while editing other user accounts. Needless to say, none of the other accounts had access to the administrative internals of MySQL, so that I essentially threw away the master key to my database server. Solution Luckily, [ READ MORE ]
If your Outlook successfully sends emails from your home network, but fails to do so on certain wireless networks, this may be because the network port 25 is blocked by the internet provider you are using at the time. If you are seeing this problem at work, your company may allow sending emails only on [ READ MORE ]
After consistently losing hard drives over the past few years (and plenty of data with it), having daily automatic backups has become an integral part of my home network. While backing up to a local computer is pretty straightforward, trying to accomplish the same thing over a network is often raising some difficulties with the [ READ MORE ]