No Picture
MySQL

How to Move MySQL D/B Files (Windows)

Locate your MySQL installation files and central configuration file basedir=”C:/Program Files/MySQL/MySQL Server 5.1/” Your MySQL configuration is stored in “my.ini” file Locate your MySQL Database location: datadir=”C:/Documents and Settings/All Users/ Application Data/MySQL/MySQL Server 5.1/Data/” Stop MySQL service. Modify My.ini file to point to a new D/B location and Save. Move […]

SQL Server

Automate Database Backup with SQL Express

This article describes, how to automate database backup in SQL Express with mixed Windows and SQL Authentication running on Windows 2008 Server.   This material was tested with Microsoft SQL Server 2008 R2 Express. SQL Server 2008 Enterprise comes with Maintenance Plan feature.  That feature allows amazing flexibility and auditing.  SQL […]

MySQL

How to Work with MySQL – Basic Tasks

This material is tested with MySQL 5.1 and 5.5 on various Windows versions. This article covers these topics: -010- MySQL Data Location -020- Shortcut to MySQL Command Shell -030- Create a New Database -035- Delete an Existing Database -040- Display a List of All DB Users -050- Display a List […]