This is a handy command that i use to backup or export, compress and upload a mysql database to my remote host, very handy when you wanna upload your development database to the remote host after some changes.
/usr/mysql/bin/mysqldump --opt -uUsername -pPassword Databasename | gzip -c | ssh -q email@example.com 'cat > ~/Databasename.sql.gz'
Replace the following :
- /usr/mysql/bin/mysqldump : The path for mysqldump on your localmachine
- Username : Username for local mysql database.
- Password : Password for local mysql database.
- Databasename : Name of the database to export.
- firstname.lastname@example.org : the user and the IP or the address of the remote host.
the above command will upload the compressed database to your home directory on the remote host, to change the directoy, replace ~/ with the path you want.
This can be easily done with install GnoCHM, the CHM viewere for Linux
you can install it by executing this command in the terminal
sudo apt-get install gnochm
a friend asked me for a nice guide to learn the Linux commands, so i made a search for him and found some cool links
straight to the point guide for beginners :
it covers the following topics :
* The “Bash” shell
* A simple command
* Obtaining help
* Linux Directories
* Linux Files
* Typing Tricks
* Redirecting Output
* Environment variables
* Switching to root
* Compiling from source
Alphabetical Directory of Linux Commands
a complete directory of Linux commands
Linux shortcuts and commands
This is a practical selection of the commands we use most often
if you have more cool guides, please post in comments