How to search for recently changed files, ie. in last 24 hours Files changed in last 24 hours: find . -mtime -1 -print To find all files modified in the last 24 hours (last full day) in a particular specific directory and its sub-directories: find /directory_path -mtime -1 -print To find all files with regular…
How to export MySQL table data into file CSV file, or even better – into Excel readable file All you have to do is that in your SQL command define how exported fields and lines will be terminated. Here is usable example – export data from table named mytable: SELECT * INTO OUTFILE ‘table.csv’ FIELDS…
You can sync two directories using command rsync. Practical example is to run next command: rsync -avz –delete /sourceDirectory /destinationDirectory This will sync /destinationDirectory with content of /sourceDirectory, with additional: a for archive more (more to follow about this), v for verbose, and z for zip compression. Option –delete means that rsync delete option deletes…