Nick Bartlett“Every man I meet is my superior in some way, and in that I learn from him.” - Emerson

Today I needed to import a 4.5GB file of SQL into a MySQL database. Good ole phpmyadmin won’t handle anything close to that large, I it had to be command line. It took me a bit to find the proper syntax, so hopefully this will rank well and provide a quick reference not only to myself but to everybody else.

Save your text file of SQL somewhere on your computer and open a command window (start > run and type “cmd” and hit enter). Type the following command

1. mysql -u root -p (then hit enter. “root” is the database username you’re using)
2. It’ll then prompt you to enter the password for that user. Enter it and hit enter.
3. type “USE databaseName” and hit enter. (”databaseName” must be changed to whatever your database name is).
4. the final step is to use the “source” command and provide the location of your text file on your hard drive like source C:\dump.sql

Hopefully this will save somebody an hour of digging like I did today. If you installed Zend Core and are using the bundled Apache2 that came with it, go to services.msc and you’ll find the apache2 service listed as “ZendCoreApache”. It’ll be at the bottom of the list of two hundred services listed instead of at the top where you’d expect near the A’s.

If you can’t find how to open the Zend Core Administration web GUI, then hopefully this will help you out. Go to http://localhost/ZendCore/index.php in your browser or on Windows go to Start | All Programs | Zend Core | Zend Core Administration . More documentation here from Zend http://files.zend.com/help/Zend-Core/zend-core.htm .

A challenge I’ve found being a PHP developer in the .NET and Java ruled Minneapolis and Saint Paul area is finding good PHP jobs.  I am building a list of companies in the Twin Cities that use PHP or have a need for PHP developers so when the time comes to find work, this list should be very helpful. If you’re willing to work for ten bucks an hour, you can find PHP work in craigslist any day. However, if you need to make a living, this list should help you out.  Please leave a comment with additional companies in the Twin Cities area you’re aware of that use PHP and need Developers.

Employ Full Time PHP Developers

1. VISI
   visi.com
2. Sierra Bravo
   www.sierrabravo.com
3. Ecreativeworks
   ecreativeworks .com
4. Colle + Mcvoy
   collemcvoy.com
5. National Bankcard Services, Inc
   nbs-inc.com
6. Internet Exposure
   iexposure.com/
7. Cazarin
   cazarin.com/
8. Star Tribune
   startribune.com/
9. Digital River
   digitalriver.com/
10. Artropolis
    artropolis.com/
11. The MLS Online
    themlsonline.com/

Contract or Temporary PHP Developers

1. Best Buy
   bestbuy.com
   They only hire contractors. Accenture is their main recruiting firm.
2. Dolan Media dolanmedia.com
   Various recruiting agencies
3. Regis regissalons.com
   Various recruiting agencies

Today I had the privilege of sporting my plumber’s crack again.  Our tub faucet diverter was not working again for about the third time this year.  I’m actually getting pretty good at this routine and can have that stem out in less than five minutes.   The problem was the same as last time… the brass screw on the end of the faucet diverter stem had twisted in half and broke.  I’m growing rather tired of fixing this every three months, so I went to LeVahn Brothers Plumbing in Maple Grove MN.  I talked with a very nice guy there, who was a plumber and may have been the owner of the store.  Unfortunately he didn’t have the diverter for my Union Brass bathtub faucet, but told me I could get one at Park Supply in downtown Minneapolis when they open on Monday.

I asked the plumber about alternative screw types to the brass screws that keep breaking, but he said other types of screws will just rust and get stuck in the stem.  I mentioned these screws turn a dark brown color after only three months when they break.  He said the brass screws are rusting or corroding and suggested I coat them in grease to repel the water when installing a new one this time.  I’ll have to check in my garage for some grease or I may use some silicone if I don’t have grease.  I’ll keep you posted as to the effectiveness of this solution.