Your config-set contains manually added customizations. Be aware that these will be lost when the config-set needs to be regenerated.

Submitted by Gast (nicht überprüft) on Sa, 06/06/2020 - 17:45

Error: Apache Solr (Solr-Server Version: 8.5.2) & Drupal 8.9 (search_api_solr: 3.9)

 

Your config-set contains manually added customizations. Be aware that these will be lost when the config-set needs to be regenerated.

MySQL Query - Delete All Tables from a Database

Submitted by Gast (nicht überprüft) on Mo, 06/01/2020 - 13:58

SQL Query:

 SELECT CONCAT('DROP TABLE ', table_schema, '.', table_name, ';') AS 'command' FROM information_schema.tables WHERE table_schema = 'MyDatabaseName' INTO OUTFILE '/tmp/sql_delete_all_tables'; 
SOURCE  /tmp/sql_delete_all_tables;

No access to "/tmp"?

 SELECT CONCAT('DROP TABLE ', table_schema, '.', table_name, ';') AS 'command' FROM information_schema.tables WHERE table_schema = 'MyDatabaseName' INTO OUTFILE './sql_delete_all_tables'; 
SOURCE  ./sql_delete_all_tables;

 

Mysqldump - Backup Database to .gz with Date / TimeStamp

Submitted by Gast (nicht überprüft) on Sa, 03/07/2020 - 14:00

Wenn man alle Datenbanken sichern möchte (mit  Datum in Dateiname), Befehl könnte so aussehen:

 mysqldump -u myusername -p --all-databases | gzip -c > all-dbs-$(date +%Y-%m-%d-%H%M).sql.gz

Nur ein Datenbank:

 

 mysqldump -u myusername -p myDbName | gzip -c > mydbname-$(date +%Y-%m-%d-%H%M).sql.gz