Sometimes we need keed data in some useful format and read it by available methods like Microsoft Excel, Google Spreadsheet, Libre Office, or something like that. In this post, I will show various techniques of how to export MySQL tables to a CSV file. The CSV stands for comma separated values. It will be useful to have data from MySQL database in CSV file format because you can analyze and format the data in the way you want.
Read more
One possible way is that your module is missing from the codebase or has been improperly uninstalled and you’ve still a field which is using that missing module. Try the following drush commands to remove the broken field: drush sqlq "DELETE FROM cache_config" drush sqlq "DELETE FROM config WHERE name = 'field.storage.xxx.xxx' OR data LIKE '%field.storage.xxx.xxx%'" drush sqlq "DELETE FROM config_snapshot WHERE name = 'field.storage.xxx.xxx' OR data LIKE '%field.storage.xxx.xxx%'" Warning: Don’t execute above commands on master/live database.
Read more