I was trying to sync my database from Dev to local using Drush, but encountered an error: Unknown command '\-'. Investigation revealed a MariaDB version change that added a problematic line to the dump file, causing the import failure.
Just tried to sync my production Drupal database to my local machine with the drush sql-sync command and I got the following error message: mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this operation (1227).
You might ask me why don't I just use the Backup and Migrate module to back up my Drupal database and files, and my response would be why to use a module with around 200 issues and who knows how many lines of code when I can do it with a simple shell script in less than 15 lines of code.
Quick tip on how to programmatically update a search index.
While updating this site to Drupal 8.7.2 I got Update aborted by: taxonomy post update make taxonomy term revisionable error. Let's see how I fixed it and what was the problem in my case.
dix is a simple console application that will make your life easier if you are working with MySQL databases. Let's say that you are working with some PHP framework or CMS and that you want to test a new module/plugin/add-on, or maybe you just want to upgrade to the latest version. The very first thing you should do is make a backup of your database. Doing this will save you a lot of headaches if something goes wrong.
May 24, 2024
