Deprecated function: Drupal\field_group\FormatterHelper::formProcess(): Implicitly marking parameter $form_state as nullable is deprecated, the explicit nullable type must be used instead in include() (line 576 of /var/www/vhosts/itlantik.de/httpdocs/vendor/composer/ClassLoader.php).

Mysqldump - Backup Database to .gz with Date / TimeStamp

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

MySQL

Backup

Neuen Kommentar schreiben

Comments

DB Export als .zip … Sa, 08/20/2022 - 18:59

DB Export als .zip (WeekNumber: db-w1.zip ... db-w52.zip)

mysqldump -u myusername --password='Abc123' --all-databases | zip -q mybackup/db-w$(date +%U).sql.zip

Antworten

Neuen Kommentar schreiben

Suche

Neueste Kommentare

Short Code w. Radio Buttons, Checkbox, Textarea, Email, Phone
1 month 1 week ago
Formulare: alle Text Felder mit Test / Demo Daten füllen (mit JQuery)
```
$("input[type='radio']").each(function () {
```
Wildcard
4 months 2 weeks ago
How to Renew Let’s Encrypt SSL Certificate on Plesk via Ubuntu Shell
Let’s Encrypt will only accept a wildcard via DNS challenge.

If your Plesk instance can’t create the _acme-challenge.example.com TXT (external DNS), the extension can’t complete validation and will show no success.
Same problem
4 months 3 weeks ago
Warning: Undefined array key "url" in Drupal\Core\Asset\CssCollectionOptimizerLazy->optimizeGroup()
```
Warning: Undefined array key "url" in Drupal\Core\Asset\JsCollectionOptimizerLazy->optimizeGroup() 
```
set-timezone Europe/Berlin
4 months 4 weeks ago
Server install & config : Debian 12 + Plesk + Apache + nginx + MariaDB + Solr
```
sudo timedatectl set-timezone Europe/Berlin
```
Try this:1. Go to Tools &…
5 months ago
Warning: PHP Startup: Unable to load dynamic library 'apcu.so' ... cannot open shared object file: No such file or directory
Try this:
Alternative (without warnings like "no crontab for user")
5 months 2 weeks ago
List Cronjobs for all users (via for + crontab)
Alternative (without warnings like "no crontab for dovecot") to see all tasks:
php 8.3 apcu
5 months 2 weeks ago
Install APCu (PHP 8.1, Plesk)
php 8.3 apcu failed

über Plesk hat es geklappt.
phpize failed error?
5 months 2 weeks ago
Install APCu (PHP 8.1, Plesk)
install:
```
# sudo apt install php-dev
```
phpize
# sudo apt install…
5 months 2 weeks ago
pecl install apcu : phpize: not found / ERROR: `phpize' failed
phpize
```
# sudo apt install php-dev
```
details
Problem:
/opt/plesk/php/8.3…
5 months 2 weeks ago
Install APCu (PHP 8.1, Plesk)
Problem:

Fehlermeldung