my del.icio.us tags

Subscribe to the inorganikast

Web development

category archive

02/15/2010

How to move a WordPress database in GoDaddy

Moving wordpress and its database from one GoDaddy server to another GoDaddy server is a tricky thing. So after I figured it out, I thought it might be helpful to post a tutorial to give back for all the many tutorials I’ve read and benefitted from. Disclaimer- this is not my usual blog banter, it’s a tutorial for web designers.

First, a quick FYI addressed to GoDaddy: Your advertising is causing you to lose business.

Okay, now lets get on to business. Hopefully you’ve decided to move your database before it’s grown to 10 MB in size, as there are size limits. Also, if you are using pretty permalinks or have hand-linked images rather than using wordpress’ upload feature, read this article in the codex. Now lets get started.

  1. Copy and upload the entire root wordpress directory to the new location.
  2. This one is important: Log in to the old location and go to settings. Change the wordpress location and blog url to the new locations, and save settings. Don’t worry about it getting copied with the wordpress files, this information is stored in the database.  After you do this, you will get a 404 error when you try to access the old location.
  3. Get into your hosting control center of the database you want to move, and then “databases.”
  4. Click “manage via phpMyAdmin” for the database you want to move, then enter your username and password. It’s the same login information you put in wp-config.php.
  5. In the far left-hand column, select your database again. You should see all the tables wordpress created, which start with “wp_”.
  6. Click export, and make sure all the wordpress tables are selected. We are moving just the tables because GoDaddy does not allow you to move whole databases.
  7. At the bottom of the page, check the box “Save as file” and replace the field which is already populated with “__SERVER__” with a name of your choosing. Leave all other settings as is. Hit “go” and you will be prompted to download the file, which will be a .sql file.
  8. Get into the database management for the site you are moving the database to. Tip- use a different browser for each hosting account, that way you won’t have to log out of the other account.
  9. Create a new database, with the exact same credentials as the original database, except add a ’1′ on the end of the name (which is also the username). This is because godaddy will not allow there to be any two databases in the entire galaxy of GoDaddy hosting with the same name.
  10. Refresh the database list until you can “manage via phpMyAdmin” for the new database.
  11. Select your new database on the left hand column (should only be the new one besides “information_schema”).
  12. Once selected, click the import tab, and import your .sql file.
  13. The import should be a success (provided you didn’t tamper with the export settings when you exported it) and you will see your “wp” tables. You’re not done yet! go on to the next step.
  14. Open up the wp-config.php wordpress file at the new location.
  15. Change the ‘DB_NAME’ and ‘DB_USER’ to the newly created database name, which was the existing one with a ’1′ at the end. I am assuming you left the password the same.
  16. Now go back to the browser with the destination godaddy account open. From the database management page, click the pencil icon next to your new database.
  17. Copy the host name, which will be something like “p47mysql125.secureserver.net”.
  18. Paste this into ‘DB_HOST’ in your wp-config.php file, upload the file, and you’re done! Access the blog at the new location to make sure everything is working properly.

If you want to make the old location work again, manage via phpMyAdmin the old database, and edit the table, “wp_options.” Click browse. Change the database entry for “blogname” back to the old location, and “home” (on the next page) back to the old wordpress folder location. Happy web designing.

10/22/2009

Should web developers keep their control over links?

Here’s a recent (one-sided) conversation I had on twitter… turns out I was a little naive about this subject.

w3cTweetconvoPerhaps my comments on the W3C were unwarranted, but sometimes I feel that the W3C’s goals for the web aren’t aligned with how we use it.

@necolas (link opens in a new tab) replied and said the ability to open new windows was removed because it was considered to be a usability problem and removing user control. But he also mentioned that it will be included in HTML5, although still discouraged for usability reasons.

From this we see that even the W3C hasn’t reached a “final answer” on whether or not the control over links should be taken from the developer.

Personally, I prefer links to open in a new tab, when appropriate. Imagine if everytime you clicked a link in the tweetdeck, it replaced your feed with the webpage it linked to. Point is, it has its place.

I believe it’s up to us as web devs to be responsible with the use of opening a link in a new window. The same way we’re responsible about not making text blink. Naturally, sites that are obnoxious and have bad usability are avoided. So even if we disagree who controls links we all can agree that usability is king.

04/20/2009

Indispensable tool for web designers

For web designers, Internet Explorer is the bane of your existence. It literally adds hours upon hours onto website development, doing guesswork on how to code your site so that it looks right in all the different versions of IE.

IE can be seen as a microcosm of Microsoft; Over-secure and paranoid,  and catering only to themselves- non-compliant to web standards, and non-compliant to cross-platform compatibility. Ultimately, I think this will cost them a lot of business.

Mac users like myself are forced to own a PC for IE testing, and until recently could only test on one version of IE. Fortunately there’s a great new tool available, a replacement for the old multi-ie, which would only let you test simultaneously on IE 6 and older.

I just discovered IE collection, which lets you run every version (and I mean every version) of IE, simultaneously on a PC. Plus, there’s an IE web developer tool included, which I haven’t had a chance to fully explore. The only glitch I’ve found is I can’t control the security settings, which disallow a lot of java functions. Thanks Microsoft, you over-paranoid, fear-based, used-by-default, headed-for-the-dumpster, piece of shit company! Anyway, enjoy, IE collection makes web design a little easier.

My twitter
Albums you should check out.
Plastic Beach ~ Gorillaz

The Gorillaz seem to keep getting better with each album. Plastic Beach resurrects a heavily produced 80′s sound and features more collaborators then ever before. Mos Def, who lights up “Stylo” with Bobby Womack also recently released Mos Dub -a free album that mixes up a bunch of classic dub tracks, and has been racking up the play count on my iTunes. My favorite new collaborator is definitely Little Dragon, appearing on several tracks, lending an ethereal quality. Bobby Womack no doubt leaves a lasting sonic impression as well.

found in April, 2010

Future Sound of Russia ~ Hospital Records

The Future Sound of Russia

I usually save Drum and Bass (dnb) releases for my mixes and reserve this section for other music. But this is an album, and deserves to be treated as such.

The fact that dnb is being released more and more often in album form shows that it’s growing in popularity. Not only that, but some songs on these full-length albums aren’t even mixable. That means these tracks aren’t just being loaded onto the turntable, but onto the ipod.

Hospital Records is one of the dnb heavyweights, with some of the best producers in its lineup,  distributing all forms of popular media. And with their award winning podcast, dnb is reaching new listeners all over the globe. Hospital has turned the ‘cast into a two-way relationship, soliciting for your demos, promising the best ones to be played on the podcast. The tune will reach millions of listeners, and possibly get signed.

That’s how Tony Coleman, the man behind the label, found many of the artists on this compilation, which consists of all Russian producers. True to his form, these tunes push the boundaries of the genre. They’re not really dancefloor mashers but a diverse collection of tunes that take a little while to warm up to, and they soon end up on your smart playlist of most played songs in iTunes.

found in December, 2009

Inhuman Rampage ~ DragonForce

Inhuman RampageAt first, sheer awe of the two guitar virtuosos and the machine-like live drums was what drew me to DragonForce. I loved how over-the-top the sound was- each second is packed with so much complexity that it takes multiple listens to digest the tracks.

But after a while you begin to appreciate the jazz-like soloing ability of this power metal band. As well as the melodies, any of which could be covered with an acoustic guitar. But instead DragonForce rages, as if infused by a power surge. The energy and dexterity necessary for an album of this sonic scale is impressive, and I can’t wait to see DragonForce live.

found in October, 2009

Uplifter ~ 311

Uplifter album art

311 has not begun to rest on its laurels. If there is a little more harmonizing and less lyricizing, they are still putting just as much thought and effort into their jams. I was slow to adopt this album, but a couple key tracks kept me coming back- “Daisy Cutter” – there are so many great parts to this song, and “Never Ending Summer”, a straight up rocker. 311 has been making new music and touring for 20 years, I wonder if they’ll ever stop. Read about my conjecture of the album art here.

found in July, 2009

The E.N.D. ~ Black Eyed Peas

The E.N.D.

The Peas have definitely traded hip hop for hop pop. With a steady stayin-alive beat, this is a club album all the way through, with tons of ass-shakin beats.  Will-I-am perfectly melts electro and hip hop together to make non-abraisive pop songs with a shelf-life. So, if you automatically avoid anything that hits the mainstream, in this case it would be to your detriment. This is quality beats.

found in July, 2009

See all found music »
Not necessarily recently written.
Survivor ~ Chuck Palahniuk

Survivor is one of those books that is nothing you expected. Palahniuk uses a unique writing style that delivers deadpan humor and heavy satire. Dark themes like suicide and death are explored. It can be a little depressing at times, but you can’t help but be drawn in by all of the unexpected events that occur in the book.

Told in first-person, this is the story of a survivor of a suicidal religious cult. Cared for by a government program, the protaganist, Tender Branson is placed in a job, and provided a new life. Life goes on uneventfully, until he meets Fertility Hollis. From there, nothing and everything go as planned, in a tragic story saturated with symbolism and rife with satire of modern American life.

finished in June, 2010

In Defense of Food ~ Michael Pollan

InDefenseOfFood

I’ve been a fan of Michael Pollan ever since I heard him interviewed by Terry Gross on NPR some years back. They talked about his book, The Omnivore’s Dilemma, which brought to light many things I had never considered about food, and encouraged us to foster a better relationship with the food we eat.

2007′s In Defense of Food goes a step further, exploring what food to eat. It’s a question a whole industry has sprung up to answer. But IDoF raises questions about food most of us have never considered.

For instance, the degree to which our government influences what we eat. One example of this are government subsidies that make corn and soy cheaper to buy than they are to produce- which floods the market with cheap corn syrup and soybean oil. This enables highly processed, unhealthy food to be cheaper than fruits and vegetables.

Pollan singles out the “Western diet” as a cause for most of the maladies that are unique to the western world- diabetes, cancer, obesity, hypertension, and stroke. He points to those cheap sugars and fats lacking in nutrition as the cause-

A diet based on quantity rather than quality has ushered a new creature onto the world stage: the human being who manages to be both overfed and undernourished, two characteristics seldom found in the same body in the long natural history of our species.

And the thing is, it all makes very good sense. Without summarizing the book, Pollan makes a case for the importance of foods as a whole, rather than the nutrients we generally value them for, and a case against the nutrient injected processed foods that dominate an American diet.

He finishes with no hard rules for what to eat but some very good rules of thumb such as, “Shake the hand that feeds you” and “Pay more, eat less”. Pollan points out that in 1960, Americans spent 17.5% of their income on food and 5.2% on health care. Today we spend about 10% on food and 16% on health care. What does this say about the quality of food we’re eating?

In all, In Defense of Food is an excellent evaluation of how we eat as Americans, and how we should eat. Look for Pollan’s next book, Food Rules in January.

finished in December, 2009

The Art of War ~ Sun Tzu

The Art of War

The Art of War has been adapted to all sorts of training and self-help books, but the original is quite literally a guide to conducting war… in Asia, circa 6th century B.C.E. The book consists by and large of clearly stated guidelines for war. There are many simple statements like this:

When the common soldiers are too strong and their officers too weak, the result is insubordination. When the officers are too strong and the common soldiers too weak, the result is collapse.

And there are more conceptual principles such as this:

Do not interfere with an army that is returning home because a man whose heart is set on returning home will fight to the death against any attempt to bar his way, and is therefore too dangerous and opponent to be tackled.

When you surround an army, leave an outlet free. This does not mean that the enemy is allowed to escape. The object is to make him believe that there is a road to safety, and thus prevent his fighting with the courage of dispair.

I believe these principles transcend the scope of just ancient warfare. Many of the principles in the book appear simple and obvious, but upon examination of the United State’s war history, you have to wonder if some of these principles weren’t ingored, how our history may have been changed.

finished in November, 2009

The Lost Symbol ~ Dan Brown

lost-symbol

Having also read Dan Brown’s Angels and Demons, I couldn’t help but notice the pattern in his writing, it’s undeniably formulaic.  But I’d say the formula of Robert Langdon running all over a historical city to solve an ancient riddle makes for a good read. And once again, there are hints that this book was written to eventually become a blockbuster film.

This is probably the most violent, cryptic, and intense incarnation of the Langdon series. And what is everyone after this time? It’s the legend of the ancient mysteries, which if unlocked, prophesize to illuminate the world and change mankind. A character in the book points out the true meaning of the word “apocalypse” (in reference to the apocalypse theory of 12/21/2012), that it means to illuminate. So in a way, the book is making a real life suggestion that these same ancient mysteries will change the world forever at some point in the near future.

At the end, the ancient mysteries are revealed. Without spoiling the book, it raises plausible questions, but really, when you offer up a worldwide epiphany, how much of it do you expect will be delivered?

finished in October, 2009

Moby Dick ~ Herman Melville

I got this book in a used bookstore while visiting my grandparents in Carson City, Nevada. The owner offered it to me for a penny when she heard I hadn’t read it.

This is one of the oldest books I’ve read, it was orginally published in 1851. To me the book was interesting for this reason alone, to get a glimpse of life 150 years ago.

Melville was very likely inspired by Shakespeare, as the book is filled with soliloquy and in parts is written like a play. References are as abundant as in an episode of Family Guy, but here they’re references and allusions to Roman and Greek mythology, as well as the Bible.

As one of the most well-known and oldest novels about sailing the ocean, it’s likely the source of our modern day image of the peg-legged sea captain crying, “Avast! Thar she blows!” As the book explains, many Nantucket whaling captains and sailors were quakers, who emulated scripture in their speech.

Definitely an epic, and perhaps America’s only contribution to classic literature, Moby Dick.

finished in August, 2009

See all recent reads »
et cetera
  • Search blog entries