Here’s a scripted version of a MySQL backup and automatic upload to Google Drive, using the gdrive CLI (not the complicated Google Drive API).This is the simplest and most commonly used on Linux servers. STEP 1 — Install gdrive CLI on the server (just once) Then initialize: A link will appear => Log in to…
Create backup script: Paste this script: Save the file, and exit nano by press CTRL-X. Run the backup script:
To pull from a GitHub repository without entering your username and password every time, you can set up authentication using Personal Access Token. Use Personal Access Tokens (PAT) GitHub no longer supports password authentication; instead, you can use a PAT. Steps: Replace <TOKEN> with your actual token.
We can use ‘tail’ command feature in Windows using Powershell. Run Powershell and execute this command: Change [filename] with your file. Number 30 means show the last 30 lines.
Linux Mint 21.3 “Virginia” is preinstalled with Redshift application which can be used to activate night light feature. Redshift will detect your location (latitude, longitude) to activate night light. Come a question, “how to force Redshift to activate night light all the day?”. You can modify config file to achieve this. Edit or create /home/[username]/.config/redshift.conf…
I cannot access container’s console in Portainer. When click Console link, it showed error message “Unable to retrieve image details”. To fix this, I remove Portainer image and pull again with portainer/portainer-ce:sts image. Use the following commands to stop then remove the current Portainer. Your other applications/containers will not be removed. # docker stop portainer…
The following query can be used to count duplicated records in MySQL:
The following regular expression function can be used to strip HTML tags: It is very simple.
I unable to do audio recording in Kdenlive. Audio device does not show in Settings => Configure Kdenlive => Capture => Audio tab. To fix this issue, install libqt5multimedia5-plugins. Restart Kdenlive and go to Settings => Configure Kdenlive => Capture => Audio tab. Audio device list will be shown and audio recording can be used…