I recently had to move data from one server to another.  The serevr runs linux, Railo and mysql.  It's always a pain migrating databases bewteen servers but mysql makes this so easy:



This will prompt you for the root password but if you want to can add the password after the -p and not be prompted.

Thats it.  you can now run this and restore all your databases on the new server or pick through it and restore the ones you need.

What would you prefer and why?

EXTjs is not free

jQuery is.

EXTjs is built into ColdFusion jQuery is not.

jQuery is Microsoft's defacto Ajax library so it has some big support behind it.

We use EXTjs at work but I use jQuery at home.

We had a largeish DB server corrupt a disk and in the process cause one of the databases to become suspect.

This can be resolved by running the following:

EXEC sp_resetstatus 'DBName'
GO
ALTER DATABASE DBName SET EMERGENCY
DBCC checkdb('DBname')
ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('DBName', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DBName SET MULTI_USER

GO

From: http://blogs.microsoft.co.il/blogs/dbaces/archive/2008/12/28/how-to-repair-sql-server-2005-suspect-database.aspx

However we had a database with a hyphen in the name eg: data-base-name

To get around this use " " around the data-base-name eg:


EXEC sp_resetstatus 'data-base-name'
GO
ALTER DATABASE "data-base-name" SET EMERGENCY
DBCC checkdb('data-base-name')
ALTER DATABASE "data-base-name" SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('data-base-name', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE "data-base-name" SET MULTI_USER

GO

I setup a new server that will have access to the outside world.  This of course means I need SSL.  We have a wild card SSL cirtificate for the domain and I know they can be a pain to install in IIS6 but I wasn't sure how it would be in IIS7 ( Windows 2k8 ).

Anyway I was following the steps provided when I bumped into this:

It's actually a known issue and is described here and what to do about it:


http://www.digicert.com/ssl-certificate-installation-microsoft-iis-7.htm

Note: There is a known issue in IIS 7 giving the following error: "Cannot find the certificate request associated with this certificate file. A certificate request must be completed on the computer where it was created." You may also receive a message stating "ASN1 bad tag value met". If this is the same server that you generated the CSR on then, in most cases, the certificate is actually installed. Simply cancel the dialog and press "F5" to refresh the list of server certificates. If the new certificate is now in the list, you can continue with the next step. If it is not in the list, you will need to reissue your certificate using a new CSR (see our CSR creation instructions for IIS 7). After creating a new CSR, login to your DigiCert account and click the reissue button for your certificate. 

It was actually easier in my case as I already had the pfx exported from the IIS 6 server but still an error like this coming up on a brand new server is not confidence building.


All in all I think MS did a decent job with IIS7 and SSL and its less confusing then IIS6 and I now have my CF9 Flex app running behind SSL.

We use MP4's to deliver some content.  Some is on our own server ( in Dev ) and the rest on Akamia.  I just set up a new ColdFusion 9 box and forgot about the mime tpye for MP4.  For such a simple thing I seam to forget the mime type every time for mp4.

So here it is:

mp4 video/mp4