Saturday, June 23, 2012

MySQL Workbench: Copy Table Structure and Data

Right mouse click the table you want to copy and choose, "Send to SQL Editor -> Create Statement"
Select all and execute the statement (lightening bolt icon)
In SQL statement, change table name
Then execute the statement:

INSERT INTO `table2` SELECT * FROM `table1`

Tuesday, June 5, 2012

Installing Coldfusion 10 on Windows 2008

When installing CF10 on 2008, you may receive on error message telling you that ASP.NET, ISAPI Extensions and ISAPI Filters needed to be installed.  Despite having these roles installed, the CF10 installer may still tell you they are not.  The little bit of information this error message leaves out is that CGI needs to be installed as well.  Once you have ASP.NET, ISAPI Extensions, ISAPI Filters AND CGI installed, the error message should go away.