Tag Archives: MySQL

Switching: Linux App Equivalents

I have been in the process of planning out switching to Linux in 2010 for my main development computer (a laptop), as well as for various web and database servers I am responsible for at work.

I’ve been making good use of Sun’s awesome (and free) VirtualBox program, which allows me to create any number of virtual computers to experiment on. I’ve had a couple of CLI-only server versions running (Debian and Ubuntu), as well as what amounts to a desktop system for the last three Ubuntu releases: 8.10, 9.04, and the just-issued 9.10.

tron.jpg

My User has information that could… that could make this a free system again! No, really! You’d have programs lined up just to use this place, and no MCP looking over your shoulder.

I’ll cover the whys and wherefores of switching in the future. For now, suffice to say that the ever-increasing commercialization of Mac OS X, with accompanying restrictions, has been grating on me for some time now. I am also attracted to the notion of software freedom (having been a huge fan of the original Tron movie ;) and of course the cost savings can be dramatic. And since I work primarily in education, I think we would be neglecting our duty by not exploring the open-source world.

dumont.jpg

All that is visible must grow beyond itself, and extend into the realm of the invisible.

One of the first and ongoing steps is compiling a list of application equivalents to programs I am need of.

Still looking:

  • Time Machine (backup) -> roll-my-own or manual?
  • Bluetooth File Exchange -> built into Gnome?

Stuff that exists in both places:

If you’re looking into switching as well, or just are looking for new apps to try out whatever your platform, check out AlternativeTo, which provides alternatives for Linux, Mac, and Windows programs.

Note: Written before the current cold whacked me in the head and upper respiratory tract. Bits are incomplete. Suggestions are welcome.

End of line.

Solution to MySQL ERROR 1 (HY000) saving INTO OUTFILE

If you run into this,

ERROR 1 (HY000) Can't create/write to file '/path/to/file' (Errcode: 13)

when attempting a MySQL SELECT * INTO OUTFILE command, you’re suffering from a permissions problem. The command is issued as if you are the “mysql” user, which includes its filesystem permissions.

The quickest solution is to save it in the /tmp directory, then move it afterwards.

Colophon

[Originally 2007, updated 2011.]

Here are some of the hardware and software tools I use to create and maintain my various websites, as well as performing other writing. This is not an exhaustive list, nor is it likely to be accurate for more than a few months, as I am always trying new programs.

Celsius1414 is running on the open-source WordPress, hosted on Linux web servers, with PHP and MySQL.

My desktop operating system of choice is Linux, specifically Ubuntu, which I switched to full time in 2010. (Previously, I spent years on Mac OS X.)

Most coding is done in vim, as is personal journaling, research material accumulation, planning, and all-around textual goodness.

The vast majority of web browsing is accomplished in Firefox, with indispensable Extensions such as Adblock Plus and NoScript.

Dealing with the occasional office-suite document necessitates LibreOffice.

Other random programs I’ll use often enough to be notable: