How to Backup MySQL Database and Automatic Upload Backup File to Google Drive
Here’s a scripted version of a MySQL backup and automatic upload to Google Drive, using…
How to Backup MySQL Database and Automatic Upload Backup File to Google Drive
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…
How to Backup MySQL Database and Remove Old Backup Using Shell Script
Create backup script: Paste this script: Save the file, and exit nano by press CTRL-X. Run the backup script:
Use Personal Access Token for Github
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.
Windows Equivalent of Linux ‘tail’ Command
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: How to Activate Night Light
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…
Portainer: How to Fix “Unable to retrieve image details”
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…
MySQL: How to Count Duplicated Records
The following query can be used to count duplicated records in MySQL:
MySQL: How to Strip HTML Tags
The following regular expression function can be used to strip HTML tags: It is very simple.
Kdenlive: How to Fix Audio Record Device
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…
