Posts Tagged ‘ Move ’

How to Work with MySQL – Basic Tasks

2017/09/16
By
Modified: 2017/09/10
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…

Read more »


Moving Win XP from RAID to RAID Machine

2017/06/18
By
Modified: 2017/04/30

After several days of heavy exhausting battles and sleepless nights, after testing dozens of options, after browsing many proposed Internet solutions, I finally was able to move an old instance of Windows XP on a new machine with new RAID drivers. That happened at 13:23 on December 12, 2010.  I moved Win XP from old RAID machine to a new RAID machine. O boy! I found  a clear and clean way to do this task.  I will also use the same technique to move any Microsoft operating system from a Single drive to a RAID machine.  And this also works great, if you simply switching your PC controller from IDE to…

Read more »

Add a FILESTREAM feature to an existing SQL D/B

2017/05/07
By
Modified: 2017/04/30
SQL 2008 SP2 FILESTREAM Problem

SQL Server 2008 allows to store binary data, if Database has a FILESTREAM feature

Read more »

Windows 7 – How to Copy and Delete Massive System Directories

2017/04/17
By
Modified: 2017/03/03
2007-07-07

Problem: You have an old discarded instances of failed Windows 7 installs.  You can rename the directories, but they still clutter your hard drive, and they are very hard to get rid of. I simply can’t take this painful and slow process of deleting huge system directories under Windows 7.  Remember this endless stream of errors, and warnings, and skips.  The same task in Win XP only takes a few seconds.  But under Windows 7, it  is a project of its own.  Pain! Finally, my patience ran out.  I decided to write a script.  And it it worked!   Delete Windows System Directories Here is a fantastic way to delete huge Windows 7…

Read more »

Moving Old ASP Sites to 2008 Server, IIS 7, and SQL 2008

2017/04/13
By
Modified: 2017/03/03
Moving Old ASP Sites to 2008 Server, IIS 7, and SQL 2008

It was time to move many sites from W2K3 Server (Windows 2003 Server) and SQL 2000 Server to a new W2K8 Server (Windows 2008 Server) and SQL 2008 Server.  And if I ever have to do it again, I will check with these notes. The greatest secret in technical life (and may be wider) is to change before you have to.  Anticipate and change before circumstances force you.  For a long time I was planning this migration, but I didn’t expect to go through so many hurdles and error messages.  Luckily, I found solutions that seem logical and clean.  So, let’s go into step-by-step details. COPY DATABASE AND SITES – Backup…

Read more »

Move IIS inetpub Directory

2017/04/11
By
Modified: 2017/03/03
Move IIS inetpub Directory

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…

Read more »