Showing posts from September, 2021

Digital Marketing

Google Apps Script is a cloud based scripting language for extending the functionality of Google Apps and building lightweight cloud-based applications.

How to Factory Reset an Amazon Fire Tablet

Turn off your Amazon Fire tablet completely. Press and hold the Volume Up + Power buttons until you see the Amazon logo on the screen. Press the Volume Up and Down keys to navigate through the options in the system recovery menu as the touch screen will not be active.

China-based SparkPool and Beepool recently suspended operations to comply with Beijing's new regulatory policy on crypto.

High-interest savings ETFs primarily invest in high-interest deposit accounts with Canadian banks, credit unions or trust companies

Remove All Hyperlinks in Google Sheets

Click the arrow in the upper left corner of the sheet (or use the keyboard shortcut CTRL + A) to select the whole... Right-click anywhere in the selected area Then choose Remove link.

The main differences between tracepath and traceroute

The main differences between them are: root or superuser privileges are not required in tracepath. This is the main reason for using tracepath than traceroute in Linux. Otherwise they are similar to each other as a Linux Utility service. 

Get file name only with Linux GNU 'find'

 find /your-directory -type f -printf "%f\n"

Crontab to run first Sunday of every month

 08 08 * * 7 [ $(date +\%d) -le 07 ] && /your/script

Dump large tables by mysqldump

To dump large tables, combine the --single-transaction option with the --quick option. This will backup MySQL database using Mysqldump without locking.

Crontab uses OR when both day of month and day of week specified

When a crontab line contains both day of week and day of month cron uses OR for the date to run the command. The POSIX standard dictates at  that: if either the month or day of month is specified as an element or list, and the day of week is also specified as an element or list, then any day matching either the month and day of month, or the day of week, shall be matched

MySQL – Ignore Tables from Backup in MySQLdump

Use –ignore-table option with the mysqldump command to ignore table for backup.  Using this option, you need to specify both the database and table names as showing in the below example. mysqldump --login-path=root -T /backup/mysql-files/ goyuninfo --ignore-table=goyuninfo.table_to_ignore1 --ignore-table=goyuninfo.table_to_ignore2 Or using --ignore-table and create an array of tables, with syntaxs like --ignore-table={db_test1.table8,db_test2.table6,db_test3.table5}

Show warnings when using mysqlimport

There is no output of warnings from mysqlimport. You can run for example to find out. It is likely foreign key constraints etc. mysql --login-path=goyuninfo -e "LOAD DATA LOCAL INFILE 'goyuninfo.txt' INTO TABLE goyuninfo ; SHOW WARNINGS;"

Set java vmargs in vscode at workspace level

Use vmArgs option in the .vscode/launch.json file, create an entry for java launcher configuration as below:         {              "type" :  "java" ,              "name" :  "Launch Current File" ,              "request" :  "launch" ,              "mainClass" :  "${file}" ,              "vmArgs" :  "-Dspring.jmx.enabled=true"         }