Just some personally useful bash scripts:
Find and delete files using a pattern
Find all files containing a particular string and do something with them - in this case, delete all files like "._*" i.e. "._user.module". This is usually junk left over from dead SSH sessions
for FILE in $(find . | grep '\._');
do
rm $FILE;
done;
Extract and import dumped SQL
This one comes from my work on gamerswithjobs.com, where I frequently received database dumps in the form of table dumps and need to decompress the import the SQL into a local DB. Also useful for bulk archiving or decompressing a large number of files.
echo "Extracting archives...";
for FILE in `ls *.gz`;
do
echo "Extracting $FILE ...";
gzip -d $FILE;
done;
echo "Importing SQL...";
for FILE in `ls *.sql`;
do
echo "Importing $FILE ...";
mysql -h dbhost -u dbuser -pdbpass dbname < $FILE;
done;
Dump and compress database tables
Another useful one from gamerswithjobs.com work. This one dump each table from a database as an individual .sql file. This is particularly useful for extremely large databases where a straight dump of the entire DB would take longer than acceptable, either by potential crashes or by sys admin enforcement of a max execution time of commands.
echo "Dumping tables...";
for TBL in `mysql -e "show tables" -N -h dbhost -u dbuser -pdbpass dbname`;
do
echo "Dumping $TBL";
mysqldump -h dbhost -u dbuser -pdbpass dbname $TBL > $TBL.sql;
done;
echo "Compressing dumped tables...";
for FILE in `ls *.sql`;
do
echo "Compressing $FILE ...";
gzip $FILE;
done;
