Archive for the ‘ Databases ’ Category
Current versions of MySQL 5.1.x appear to ship with an outdated default configuration file that generates the following warning in the Windows Event Log upon restarting the MySQL service: The syntax ‘–default-character-set’ is deprecated and will be removed in a future release. Please use –character-set-server instead. Solution Perform the following steps to prevent the warning: Open the MySQL [ READ MORE ]
This article is part of a backup. It was originally posted on Sunday, April 13. 2008. At the very bottom of the SQL Server 2005 Express download page, Microsoft offers 64-bit versions of their installers. Unfortunately, this is not everything you need to run SQL Server Express on 64-bit versions of Windows Vista. As it turns [ READ MORE ]
This article is part of a backup. It was originally posted on Sunday, April 13. 2008. The MySQL Server Instance Configuration Wizzard MySQLInstanceConfig.exe (current version 1.0.10.0) that comes with the MySQL Server Community Edition (current version 5.0.51a) has a typo in the embedded manifest file that prevents it from running on Windows Vista machines. The error can [ READ MORE ]
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 ]
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 ]