Miren Berasategi's Library tagged how-to →  View Popular

Over the past 10 years, the MySQL database has become incredibly popular on the Web. Every WordPress blog is driven by a MySQL database, which contains the blog’s posts, settings, comments and much more.

While plug-ins and even coding hacks can solve some problems and achieve some tasks, sometimes you don’t have any other choice than to execute SQL commands in phpMyAdmin or directly to the database via SSH. Let’s take a look at 8 useful SQL hacks for WordPress. Each section of this post presents a problem, suggests a solution and provides an explanation to help you understand the solution.

www.smashingmagazine.com/...8-useful-wordpress-sql-hacks - Preview

wordpress sql how-to tips

usuarioaspireone.blogspot.com/...l-escritorio-entre-xfce-y.html - Preview

aspire-one desktop software how-to

www.google.com/...bin - Preview

google news help how-to reference

hplipopensource.com/...index.html - Preview

hp linux ubuntu printing software how-to

Tips on how to create an optimal print stylesheet.

alistapart.com/...goingtoprint - Preview

css how-to tips print

in Weblog Tools Collection. CSS to make long lines or URLs wrap.

weblogtoolscollection.com/...css-for-code-wrap-long-lines - Preview

wrap url css how-to help

Easy link tracking with jQuery in Google Analytics.

www.think2loud.com/...-outgoing-links-from-your-site - Preview

google analytics how-to trick links

in Analytics Talk. Using Google Analytics we can actually track every single click that a visitor makes. It doesn’t matter what they click on, we can track it. This functionality is great for tracking clicks on:

* non-html pages (mp3, pdf, exe, etc.)
* links to other sites
* form elements

There is some instruction in the GA help docs, but I’m going to dive deep into this topic during during three blog posts.

www.epikone.com/...cks-with-google-analytics-pt-0 - Preview

google analytics clicks how-to help reference

Use .htaccess to make a 301 redirect from one domain to another.

scriptplayground.com/...Redirect-to-new-domain - Preview

301 apache redirect how-to

decafbad.com/...etting-laconica-up-and-running - Preview

laconica open-source how-to microblogging software

Use absolute paths to include (in annotation).

es.php.net/include - Preview

php include help how-to

Create RSS feeds with DreamWeaver

www.communitymx.com/...article.cfm - Preview

dreamweaver rss feed how-to tutorial

yoast.com/wordpress-seo - Preview

article blogging how-to marketing seo wordpress

www.nintendowiifanboy.com/...nary-mario-kart-training-wheel - Preview

nintendo wii mario-kart mario how-to training

en TUXINGA!

tuxinga.wordpress.com/...efecto-lomo-con-gimp - Preview

lomo gimp photography how-to

en Abartia Team

www.abartiateam.com/...u-empresa-con-google-maps.html - Preview

google maps how-to business

The How-To Magazine for Everything Adobe. Magazine Table of Contents

www.layersmagazine.com/?page=magazine/index - Preview

magazine Adobe how-to

en TiGRETON

tigreton.com/...arentes-en-internet-explorer-6 - Preview

css tips png graphics how-to

en Saber curioso

www.sabercurioso.com/...por-que-ojos-rojos-fotografias - Preview

photography red-eyes how-to

twiki.org/...PersonalInfoWithLdap - Preview

ldap twiki how-to intranet