Content

Importing Large Files into MySQL using phpMyAdmin and CPanel

7 Apr

+ 0

When I need to upload large .sql file (greater than 10 MB) into MySQL using phpMyAdmin, it frequently times out.

The annoying the solution is to split the SQL file into several smaller file, but text editors will hang up if the file is too large, and if you aren’t careful you can break the whole script.

That is why I like David Pratt’s solution. It worked great.

1. If you have phpMyAdmin installed in CPanel, you need to login to your server using your root password. Navigation to the folder:

/usr/local/cpanel/base/3rdparty/phpMyAdmin

2. There, create a directory “upload”.

  Leave Comment, 0 Comments

My Password Was Hacked

16 Dec

+ 3

This past weekend, a major website was hacked, and all the emails and passwords were posted online for the world to see.

Luckily for you, it was a network of technical websites.  So if you aren’t a tech guy, you probably aren’t affected.

Unluckily for me, my personal email and password was one of the 1.5 million stolen.

Anyone of BILLIONS of people could have gained access to my:

1.  Amazon
2.  Ebay
3.  Godaddy
4.  Myspace

And could of:

  Leave Comment, 3 Comments

Switching to the Mac: Buying a Mac

19 Oct

+ 0

Almost 10 months ago, I purchased my first Mac. Because a lot more of my website work was less Microsoft and more Open Source, it made more sense. I also wanted to learn iPhone / iPad development which is impossible without a Mac.

For an employed Windows developer, it was scary, confusing and exhilarating. There were so many questions swimming in my head:

Was I going to be able to perform my normal job?
Would it take long to learn OS X?
Would I have to purchase a lot of software?
Would I like it?
Am I throwing my money away?

  Leave Comment, 0 Comments

Integrating Forums with WordPress

24 Apr

+ 3

There are three viable options if you want to leverage WordPress as your Content Management System, yet want to offer your users a way to interact in a forum.

  • bbPress
  • phpbb
  • vBulletin

bbPress

bbPress logo
bbPress is a very lean forum solution for WordPress written by Automatic.  It is a great idea for a quick and dirty forum that works.  Theming works similarly to WordPress – so if you enjoy writing themes in WordPress, this will be easy.

I had to install it in a subdirectory. Trying to install it in the same directory as WordPress causes a battle over index.php since they both need it.

  Leave Comment, 3 Comments

Stephen Colbert Said My Name On The Colbert Report

3 Feb

+ 2

Not sure how long the link will stay live but you can see it at the 5:30 mark over at Hulu:

http://www.hulu.com/watch/125504/the-colbert-report-tue-feb-2-2010

I signed up for the beta of Blippy.com which he was making fun of.  It is a site that allows you to share your credit card purchases.

You can view my boring purchases here.

colbert-show

  Leave Comment, 2 Comments

How To Cheat at Mafia Wars

11 Aug

+ 6

More truthfully, this is  “How to Take Maximum advantage of the rules in Mafia Wars”.

If you play correctly, you can get to a point where you will never run out of energy.  You can just level up over and over and over.

Today I played for just a little while and completed over 4,800 jobs:

Mafia Wars Profile Page

This is what you need to do:

  1. If you haven’t started yet, choose the Maniac mafia type.  This isn’t required, but just makes the game go faster.

  Leave Comment, 6 Comments

Blackberry Tour 9630 Scroll Wheel Broken

27 Jul

+ 0

I received my Blackberry Tour 9630 about 5 days ago, and almost immediately noticed that the horizontal scrolling was either laggy or didn’t work.

After five days, I couldn’t scroll horizontally at all at normal sensitivity.  At 100 horizontal sensitivity, it will jump around a lot but will eventually scroll.

Here is a blurry video that shows the problem:

Additionally, I tested out my father-in-law’s Verizon Tour, and his horizontal scroll is how mine initially was.

I received my new Tour today in the mail – hopefully doesn’t happen again.

  Leave Comment, 0 Comments

How To Properly Setup and Configure Godaddy DNS Settings

22 Jul

+ 52

If you buy domains through Godaddy, but host the website and mail somewhere else, chances are you had to edit your DNS settings.

Up until a few weeks ago I had been doing it wrong.  It was working, for the most part, but some things like reverse dns lookups would fail, and strange errors would sometimes crop up.

When you buy your domain through Godaddy, find your way into Total DNS Control.  You will see a page similar to this:

Scary, that’s for sure.

  Leave Comment, 52 Comments

Sprint Blackberry Tour NOT Available

15 Jul

+ 0

June 30, 2009: Verizon announced the Blackberry Tour would be released on July 12,2009.

July 1, 2009: Sprint also announced the Tour would be available on their network the same day.

July 11,2009: I called Sprint’s Telesales and asked when the Tour is coming out and when they would be in the stores and was told, again, July 12, 2009.

July 12, 2009: Walked into a Sprint retail store and was told that they will not be getting any Tour’s until August 2nd.  The employee there said that no stores were getting them.

  Leave Comment, 0 Comments

Starbucks Venti Iced Coffee Cup

30 May

+ 5

I walked into a Starbucks in an old Albertson’s and saw this baby sitting there for $15. Apparently they had only been there for 1 hour and they were almost sold out.

Starbucks-cup

I was looking for this many years ago, and the Grande sized ones were selling for almost $80 on ebay. They were discontinued many years ago.

Specs:

  • Venti Sized – slightly bigger to accomodate the double walls
  • Double Walled Insulated to keep moisture off the outside, and keeping it cold longer on the inside
  • $.10 off all iced drinks

  Leave Comment, 5 Comments