Problem:
# mysqldump --user=mydbuser --password=mypassword --tab=backup/db mydbname
mysqldump: Got error: 1: "Can't create/write to file '/www/backup/db/yourls_log.txt' (Errcode: 13 "Permission denied")" when executing 'SELECT INTO OUTFILE'
Problem:
# mysqldump --user=mydbuser --password=mypassword --tab=backup/db mydbname
mysqldump: Got error: 1: "Can't create/write to file '/www/backup/db/yourls_log.txt' (Errcode: 13 "Permission denied")" when executing 'SELECT INTO OUTFILE'
Mysql export kann sehr lange dauert, wenn man viele und große Datenbanken hat. Damit man schnell ein Backup von allen DBs erstellen kann:
mysqldump --opt --quick --all-databases > /root/backup/mysql/alldbs.sql
Wenn User login notwendig ist :
mysqldump -u root -p --opt --quick --all-databases > /root/backup/mysql/alldbs.sql
Command 1:
drush sql:dump | gzip -c > /home/backup/db-$(date +%Y-%m-%d-%H%M).sql.gz
Error:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Lösung:
Wie ich alle Datenbanken exportiere und mit GZIP komprimiere:
mysqldump -u myusername -p --all-databases | gzip -c > all-dbs-$(date +%Y-%m-%d-%H%M).sql.gz
Neueste Kommentare
Problem:PHP APCu caching…
Problem:
Hilft "cp -avf old new && rm…
Hilft "
cp -avf old new && rm -rvf old"
nicht?Same with Drush 13 + PHP 8.3 and my Solution
Same with Drush 13 + PHP 8.3
Error : Failed to install the required package 'RPM' by using AP
Initializing...
Error : Failed to install the required package 'RPM' by using APT. Please install it manually.
Exit
Solution:
Installieren & Aktivieren
So habe es installiert und dann mit Hilfe von Key/Code (über Website von Acronis Cyber Protect) aktiviert:
I have a view with a path…
I have a view with a path like
/my-content-export
to export entivies as JSON or CSV.admin_toolbar 3.5.2 is the…
admin_toolbar 3.5.2 is the reason. Patch coming ...
Drupal 10.4, in a custom View
Drupal 10.4:
Tools & Settings >> Security…
Tools & Settings >> Security Policy :
Allow only secure FTPS connections
List config vaiables
/usr/sbin/mariadbd --help --verbose | grep "query.*size"