MainelyDesign.com Blog

Common SSH Commands (An Idiot's Guide)

Posted on 09/25/2010 at 09:25 am | Viewed 2,195 times | 2 comments

Well, I never thought I would be saying this, but I'm starting to love using SSH to manage certain elements of my server.  Now that I'm using ssh bash to make some updates to my server, I find myself constantly hunting for the simple commands.  I'm going to put all the commands I need below, because I'm the idiot and it's my guide.

Read: Common SSH Commands (An Idiot's Guide) | View: Comments

CURL on Windows Doesn't Work in PHP 5.2.14 ISAPI

Posted on 09/07/2010 at 08:17 pm | Viewed 2,133 times | 0 comments

Just a quick post to let everyone know what I just found out- the version of CURL (php_curl.dll) that ships with PHP 5.2.14 for Windows ISAPI doesn't work!  That's right- it doesn't work.  I tried the MSI PHP installer package, manual installs, moving dll files into Windows and System32 directories all to no avail.  The culprit: a bad version of php_curl.dll (at least that's my best guess).  The other culprit: using ISAPI, but I don't have time to figure out FastCGI at this point.

Read: CURL on Windows Doesn't Work in PHP 5.2.14 ISAPI | View: Comments

Difference Between Truncate and Empty (Delete From) in Mysql

Posted on 06/23/2010 at 02:30 pm | Viewed 2,640 times | 1 comment

I use Navicat for administering all of my MySQL databases.  It has a command that I always use- empty table.  I noticed today that all along there has been a command right below it for truncate table.  Hmmm.  I figured this would result in the same outcome and wondered what the difference is between emptying a mysql table and truncating the same table.

Read: Difference Between Truncate and Empty (Delete From) in Mysql | View: Comments

Faking Symlinks on Windows 2003

Posted on 09/17/2009 at 04:25 pm | Viewed 2,752 times | 0 comments

My production server is a LAMP server.  I love it.  I have one cental location for my CakePHP application and symlink the folders I need to each individual hosting account.  It's pretty easy to do and very powerful.  I work on another server that is Windows 2003.  Everytime I sit down to do work, I bemoan not having the ability to create symlinks.  Turns out there is a way...

Read: Faking Symlinks on Windows 2003 | View: Comments

Invalid Date Value Error in MySQL

Posted on 09/09/2009 at 02:26 pm | Viewed 1,669 times | 0 comments

I ran into an interesting issue with valid dates and MySQL on Windows.  I wrote a CakePHP import function that basically moves MySQL data from one DB to the other.  I never thought that I would see an error related to an invalid date, but I did.

What determines if a date value is invalid (read: warning) or unacceptable (read: error)?

Read: Invalid Date Value Error in MySQL | View: Comments

Manually Installing MySQL on Windows 2003 Server

Posted on 09/02/2009 at 12:02 pm | Viewed 1,354 times | 0 comments

I have been trying to install MySQL on a web server running Windows 2003 for quite a while now.  I was finally successful! Here's how I did it...

Does your server have a hard-coded IP address?

If so, you need to make localhost refer to the manually assigned IP address in your hosts file.  This file is located in C:\Windows\System32\drivers\etc.

Read: Manually Installing MySQL on Windows 2003 Server | View: Comments

Using Exif in PHP on Windows

Posted on 08/28/2009 at 09:40 am | Viewed 1,328 times | 0 comments

I'm trying to use the exif functions in PHP on my Windows XP computer.  I want to read the meta data that is recorded by my digital camera (exif - exchangeable image file format).  I like the idea of storing that exif data in the database, so it's searchable. I wasn't having any luck with exif_read_data(), but finally found this posting.

Read: Using Exif in PHP on Windows | View: Comments

Network Solutions' Flawed .htaccess and Mod_Rewrite Rules Implementation

Posted on 08/06/2009 at 02:38 pm | Viewed 10,151 times | 8 comments

I can't believe it!  I spent hours trying to get the mod_rewrite rules working in .htaccess on Network Solutions' servers.  Everything I tried didn't work.  Using the default .htaccess (from Cake distribution) failed.  I've used the distribution on several servers and never had any issue with the rewrite rules.  However, Network Solutions's mod_rewrite works differently than [all] other servers.

Read: Network Solutions' Flawed .htaccess and Mod_Rewrite Rules Implementation | View: Comments

Avoiding Flash (.flv) 404 Errors on IIS 6 (Windows 2003)

Posted on 07/15/2009 at 11:11 am | Viewed 2,458 times | 2 comments

An interesting thing happens on Windows 2003 Server (IIS 6) when you try and play a .flv file through an embedded shockwave player...nothing.  Well, actually you get a 404 error. 

Fixing the .flv 404 error is simple

All you need to do is tell the IIS server that the MIME type for .flv exists.  Then, the web server can send the appropriate MIME-TYPE header when needed.

Read: Avoiding Flash (.flv) 404 Errors on IIS 6 (Windows 2003) | View: Comments