How to pause wget downloads in terminal
use wget with the -c option so –
wget http://file
To pause the download press Ctrl+C
To resume the download –
wget -c http://file
In the same directory of course.
Escaping a password using mysqldump console
You have to quote the password, like this:
mysql -u root -p'PASSWORD'
You must do this if the password has any of the following characters: * ? [ < > & ; ! | $
Source:
http://superuser.com/a/123953
SSH: Backup all databases
You can dump all the databases into a single .sql file like so:
mysqldump --all-databases > database_backup.sql
Or you can dump them individually to a directory with the date of backup to /home/ by using a for loop, such as this:
now=$(date +"%m_%d_%Y");mkdir /home/mysql.back.$now && for i in $(mysql -BNe 'show databases'| grep -v _schema);do echo $i; sudo mysqldump $i > /home/mysql.back.$now/$i.sql ; done
Split and merge large files
Use the split command to do this:
split --bytes=1024m bigfile.iso small_file_
That command will split bigfile.iso into files that are 1024 MB in size (1GB) and name the various parts small_file_aa, small_file_ab, etc. You can specify b for bytes, k for Kilobytes and m for Megabytes to specify sizes.
To join the files back together on Linux:
cat small_file_* > joined_file.iso
Similarly to join the split files on a Windows machine, use the copy command:
copy /b small_file_* joined_file.iso
Source:
http://linuxpoison.blogspot.com/2008/09/split-and-merge-large-files.html
Recent Comments