Posts about database

How to set up a MySQL database server on Ubuntu for Drupal to WordPress migrations

Content Management System (CMS) migration projects involve moving data between databases with different schemas. Read on to find out how to set up a MySQL database server on Ubuntu for Drupal to WordPress migrations.

How to fix the mysqldump access denied process privilege error

Fix the mysqldump "Access denied; you need the PROCESS privilege" error. Two solutions: grant the privilege or use --no-tablespaces.

How We Migrate: The Technical Process Behind a Drupal to WordPress Migration

A look inside the technical process of a custom Drupal to WordPress migration. Database mapping, custom scripts, iterative testing, and zero-downtime launch.

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

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

Importing a WordPress database: How to fix the Unknown collation: 'utf8mb4_unicode_ci' error

Fix the "Unknown collation utf8mb4_unicode_ci" error when importing a WordPress database. Use phpMyAdmin's MYSQL40 compatibility export.

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

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