- Exchange Server 2010 – Get a List of Mailboxes by Size
- Exchange Server 2010 – Grant Full Access Rights for All Mailboxes
- Exchange Server 2010 – Increase Number of Move Requests by the Mailbox Replication Service
- Exchange Server 2010 – Purge the Deleted Items (RecoverableItems) Folder
- Exchange Server 2010 – Shrink Database Size – OR – Reclaim Lost Database Storage Space
- Firefox – Version 33 Update Causes Certificate Error in Webmin
- Foxit Reader 7.0 – Disable Auto Updater via Group Policy
- Foxit Reader 7.0 – Set as the Default PDF Viewer via Group Policy
- Fuck You Microsoft, I Will Install the Cisco VPN Client on Windows 10 and Furthermore, You Can Suck It
- How to Clone Windows with Clonezilla when the Destination Disk is Smaller than the Original – OR – Cloning a Large Drive to a Smaller SSD
- HP 280 G1 MT/Intel HD4600 Dual Monitor DVI Problem Finally Resolved
- HP Support Assistant – The Epitome of Spyware and How to Disable It
- IE10 Certificate Error Fix
- Implementing DKIM on Exchange 2019 CU11 with Microsoft DNS
- Installing Logitech Webcam Software on Windows Server
- Java – How to Export Site Exceptions List to a Different Computer
- KB947222 – Addressing the User Profile Redirection Display Problem with a Different Approach
- Mozilla Firefox 51.0.1 Runs Extremely Slow
- MySQL Script – Alter/Convert All Tables in a Database from MyISAM to InnoDB
- Outlook 2010 – Crashes Upon Opening Emails with Embedded Pictures
- Outlook 2010 – Only Starts in Safe Mode
- Outlook 2010 Hijacked
- Polycom RealPresence Desktop – Do Not Minimize to Taskbar Tray
- Polycom RealPresence Desktop – Windows QoS Registry Settings
- PowerShell Script – Generate DFS-R Health Reports and Email Them
MySQL Script – Alter/Convert All Tables in a Database from MyISAM to InnoDB
Pieced together from various tutorials on the web with a lot of my own additions, here is a snippet of SQL that will alter or convert all tables in a database from “MyISAM” to “InnoDB”. As long as your MySQL user account has privileges to create stored procedures, all you have to do is simply edit the @DATABASE_NAME variable at the top of the script and run it in PhpMyAdmin if you’ve got it. Enjoy! Continue reading “MySQL Script – Alter/Convert All Tables in a Database from MyISAM to InnoDB”