drush

Problem:

100.000 unpublished Spam Comments.

Solution

Solution:

for dir in /var/www/vhosts/*/httpdocs; do   user=$(stat -c '%U' "$(dirname "$dir")");   sudo -u "$user" bash -c "cd '$dir' && php -c ~/httpdocs/drush.ini ~/httpdocs/vendor/bin/drush.php sql:dump | gzip -c > db-test-$(date +%Y-%m-%d-%H%M).sql.gz"; done

PRETTY.

Problem:

Problem:

  Command ws was not found. Drush was unable to query the database. 
  As a result, many commands are unavailable. 
  Re-run your command with --debug to see relevant log messages.  

Solution?

Command(s):

Solution:

drush sql:dump --skip-tables-list=watchdog,cache,cache_* | gzip -c > my-db-without-cache-watchdog-$(date +%Y-%m-%d-%H%M).sql.gz

Problem:

The Drush launcher could not find a local Drush in your Drupal site

Solution?

"SQL Import" via Crontab:

Problem:

After Drupal core + module updates:

The roles anonymous & authenticated disapeared

Instead of the page content I get this error: "You don't have access to this page".

Solution:

Export config from your website: drush cex

Export config from your old website or a new Drupal installation.

Move two files to the config dir of your websites sync directory: