MySQL Archives - Another Cup of Coffee - Web Development & WordPress Migration

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

11 June 2021 / database, Drupal, Migration, MySQL, Sys Admin, troubleshooting, WordPress / By Anthony Lopez-Vito

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

23 October 2020 / database, MySQL, Sys Admin, troubleshooting, upgrades / By Anthony Lopez-Vito

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 Drupal events to WordPress Events Calendar (Tribe Events)

15 February 2019 / Events Calendar, Migration, MySQL, TribeEvents, WordPress / By Anthony Lopez-Vito

The The Events Calendar, sometimes known as Tribe Events, is a popular plugin for managing event content in WordPress. It’s so popular that it’s often the first choice when clients ask me to migrate Drupal event content into WordPress. Here is some sample SQL queries if you need to do something similar. Sample SQL queries …

Migrating Drupal events to WordPress Events Calendar (Tribe Events) Read More »