How to backup a single MySQL database?

1. Open the Command Prompt (Windows)/Terminal (Linux)
2. Type the following command:
   
   
   mysqldump -u {username} -p{password} -h {host} {databaseName} > {backup-name}.sql

{username} is the login that has access to connect to the database
{password} is the login's password
{host} is the server name where it is the database
{databaseName} is the database name
{backup-name} is the name back up file name

Example:

I want to backup the BAZINGA database located at the TheBigBangTheory host with the user name Sheldon and password Cooper and save it on Meemaw.sql  file.

mysqldump -u Sheldon -pCooper -h TheBigBangTheory BAZINGA > Meemaw.sql

Source: https://www.linode.com/docs/databases/mysql/back-up-your-mysql-databases

How to fix the “The open file ulimit level is too low, please increase it otherwise changes will not be detected properly” error in Copy Linux?

sudo sysctl -w fs.inotify.max_user_watches=100000

Source: http://askubuntu.com/questions/162229/how-do-i-increase-the-open-files-limit-for-a-non-root-user

Where it is the hosts file in Linux and Windows?

Windows

C:\Windows\System32\Drivers\etc\hosts

Linux

/etc/hosts

How to do foreach in Java

List<String> collection = new ArrayList<String>();

collection.add("Hello");
collection.add("World");

for(String item:collection)
{
System.out.println(item);
}

Source: http://stackoverflow.com/questions/85190/how-does-the-java-for-each-loop-work

How to check how much RAM you have installed in Linux

1. Open terminal
2. Type
   
   
   free -mt

This command will output the memory in megabytes

Source: http://www.cyberciti.biz/tips/how-much-ram-does-my-linux-system.html

How to move the Eclipse workspace to another folder

1. Close Eclipse
2. Open the OS file manager (Example: Windows Explorer for Windows and Nautilus for Linux)
3. Move the workspace folder to the new location
4. Open Eclipse
5. In the menu bar, click File
6. Mouse over Switch Workspace
7. Click Other...
8. Select the new workspace folder location
9. Click OK

Source: http://stackoverflow.com/questions/15165135/moving-eclipse-workspace-from-to-new-directory

How to fix web sites cannot be started unless both the Windows Activation Service (WAS) and the World Wide Web Publishing Service (W3SVC) are running IIS Error

IIS Error

Fix

1. Open command prompt and type:
   
   
   net start w3svc
   
   
2. Open IIS
3. Start the site again

Source: http://www.engincode.com/fix-web-sites-cannot-be-started-unless-both-the-was-and-w3svc-are-running