Posts about sql

How to change the WordPress table prefix prior to a migration
How to change the WordPress table prefix prior to a migration

If you're using table prefixes to create temporary containers, here's how to rename them prior to a migration.

Migrating Bare Bones Yojimbo to WordPress
Migrating Bare Bones Yojimbo to WordPress

Here's how I migrated Bare Bones Yojimbo content to WordPress.

Drupal to WordPress migration: user table mapping
Drupal to WordPress migration: user table mapping

Drupal 6 to WordPress 3 user table mapping. Field-by-field reference for migrating Drupal users to wp_users.

Drupal to WordPress migration: comments table mapping
Drupal to WordPress migration: comments table mapping

Drupal 6 to WordPress 3 comments table mapping. Field-by-field reference for migrating Drupal comments to wp_comments.

Drupal to WordPress migration: terms table mapping
Drupal to WordPress migration: terms table mapping

Drupal 6 to WordPress 3 terms table mapping. See how term_data and term_hierarchy fields map to wp_terms and wp_term_taxonomy.

Drupal to WordPress migration table mapping
Drupal to WordPress migration table mapping

A post documenting the table mappings for a site migration from Drupal 6.x to WordPress 3.x.

Drupal to WordPress migration: posts table mapping
Drupal to WordPress migration: posts table mapping

Drupal 6 to WordPress 3 posts table mapping. See how Drupal node and node_revisions fields map to the WordPress wp_posts table.

Drupal to WordPress migration SQL queries explained
Drupal to WordPress migration SQL queries explained

In this post I will give a step-by-step explanation of my Drupal to WordPress migration SQL queries.

Drupal to WordPress migration notes
Drupal to WordPress migration notes

Post-migration notes for Drupal to WordPress projects: fixing permissions errors, database prefix issues, and other common problems.