To keep your operating system completely separate from all the web stuff, it is advisable to move inetpub directory off the root of a %SystemDrive% to a completly different drive. In these sample I am moving IIS from C:\inetpub to x:\inetpub. Adjust this to your needs. Steps described here were tested on Windows 7 IIS 7.5 and Windows 2008 Server R2 IIS 7.5. Check if your http://localhost/ is working before proceeding. -01- Stop all IIS-related services Stop services related to IIS: – FTP (if installed) – IIS Admin – SMTP (if installed) – Windows Process Activation (will stop all other IIS services) – WWW (will be stopped by stopping previous…
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 of All Tables -060- List All Fields in a Table -070- Free ODBC Connector is Available -080- Create a New User -085- Change User Password -090- Delete a User -100- Grant User Rights to a D/B and Show It -110- Save Database into a Dump File -120- Restore Database From a Dump File -130- Rename Database -140- Backup Database -150- Automate…