sed -n -e '/DROP TABLE.*`table_name`/,/UNLOCK TABLES/p' dump.sql > table_name.sql
Source: https://ruleoftech.com/2019/restore-single-table-from-full-mysql-database-dump
There are 20 posts filed in Code Snippets (this is page 3 of 4).
sed -n -e '/DROP TABLE.*`table_name`/,/UNLOCK TABLES/p' dump.sql > table_name.sql
Source: https://ruleoftech.com/2019/restore-single-table-from-full-mysql-database-dump
find . -newermt '14 days ago' ## minutes/hours etc.. see date input formats
In this example I get the ruby-version of my projects.
tail -n +1 */.ruby-version
Which results in the following output
==> project1/.ruby-version <==
2.5.1
==> project2/.ruby-version <==
3.0.0
==> project3/.ruby-version <==
2.7.2
Just found out this Ruby syntax, for iterating over a hash (with an index).
hash.each_with_index { |(key,value), index| ... }
find . \( -name ".DS_Store" -or -name ".Trashes" -or -name "._*" -or -name ".TemporaryItems" \) -print
Check if the print is correct. When the file can be deleted. replace '-print' with '-delete'
Prevent ._ file creation (samba config)
[share-name]
veto files = /._*/.DS_Store/
delete veto files = yes