Content Management System (CMS) migration projects involve moving data between databases with different schemas. Table names, field types and constraints often don’t match up, leading to a number of frustrating errors. This is especially the case with highly complex Drupal to WordPress migrations that use custom scripts to extract, transform and load the data. 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
You may receive a new ‘Access denied PROCESS privilege’ error when trying to dump your MySQL database. You were able to export database before so what caused this? This is due to an incompatible change introduced July 2020. Find out your options for fixing the mysqldump process privilege error.
Migrating Bare Bones Yojimbo to WordPress
In a previous post, I wrote about exporting data from Bare Bones Software’s Yojimbo and using Tomboy as an alternative. My migration script scraped the content from Yojimbo Sidekick and wrote XML files in Tomboy Note format. Though there were some drawbacks, such as tags being unavailable in Yojimbo Sidekick, I thought Tomboy’s search feature… [more]
Importing a WordPress database: How to fix the Unknown collation: ‘utf8mb4_unicode_ci’ error
If you do a lot of exporting and importing to different database servers, you’ll be familiar with the frustration of encountering MySQL import errors. Every so often when importing a WordPress dump file into a client’s database, I will encounter an Unknown collation error like the following: Unknown collation: ‘utf8mb4_unicode_ci’ Sometimes it will come up… [more]
Drupal to WordPress migration notes
These Drupal to WordPress migration notes are intended for clients who are handling some aspects of the migration themselves. Users of the Drupal to WordPress Migration Tool or MySQL queries might also find information here to resolve some problems. Admin account password and email address Your content management system (CMS) administrator password and email address… [more]