Skip to content

Instantly share code, notes, and snippets.

@asaph
asaph / mysql-backup-local.sh
Created November 2, 2017 21:31
Back Up Local MySQL Database
#!/bin/sh
mysqldump -h 127.0.0.1 -u username -p --single-transaction databasename | gzip > /tmp/databasename.sql.gz
@asaph
asaph / mysql-backup-remote.sh
Created November 2, 2017 21:32
Back Up Remote MySQL Database
#!/bin/sh
mysqldump -h host -u username -p --compress --single-transaction databasename | gzip > /tmp/databasename.sql.gz
@asaph
asaph / attach-artwork-to-apple-lossless-files.sh
Created March 18, 2021 19:38
Attach Artwork to Apple Lossless Files
#!/bin/sh
for f in *.m4a; do atomicparsley "$f" --artwork "image.jpg" --overWrite; done
@asaph
asaph / attach-artwork-to-flac-files.sh
Created March 18, 2021 19:41
Attach Artwork to Flac Files
#!/bin/sh
metaflac --import-picture-from="image.jpg" *.flac
@asaph
asaph / convert-flac-files-to-96k-apple-lossless.sh
Created March 18, 2021 19:47
Convert Flac files to 96 kHz Apple Lossless
#!/bin/sh
for f in *.flac; do ffmpeg -i "$f" -acodec alac -ar 96000 "${f%.flac}.m4a"; done
@asaph
asaph / remove-artwork-from-flac-files.sh
Created March 18, 2021 19:49
Remove Artwork From Flac Files
#!/bin/sh
metaflac --remove --block-type=PICTURE *.flac
@asaph
asaph / import_csv_into_mysql_table.sql
Created July 6, 2015 21:18
Import a CSV file into a MySQL table ignoring header line
load data infile '/tmp/file.csv'
into table my_table
fields terminated by ','
optionally enclosed by '"'
escaped by '"'
lines terminated by '\n'
ignore 1 lines;