1. Where is the Trash folder located in Ubuntu?
(Linux/Linux)

Question: Where is the Trash folder located in Ubuntu?   Answer: It's located in ~/.local/share/Trash/files you can access it by typing in the command below: cd ~/.local/share/Trash/files  ...

2. How to find what what shell you are currently using on Linux?
(Linux/Linux)

Question: How to find what what shell you are currently using on Linux?   Answer:  Open a new Terminal Window  Type in the following command echo $SHELL This will output something similar like below ...

3. How to reset a forgotten Ubuntu password?
(Linux/Linux)

... of the version numbers On the next screen select "Drop to root shell prompt" Once in the root shell prompt use the passwd command to reset your password password USERNAME Replace USERNAME with the username ...

4. How to install Google Earth in Ubuntu?
(Linux/Linux)

Question: How to install Google Earth in Ubuntu?   Answer:  Open a new Terminal Window  Type in the following command and hit Enter to download the installation file (Binary File). wget http://dl.google.com/earth/client/current/GoogleEarthLinux.bin ...

5. How to get the date for next week friday or any other day of the week via the command line in Linux?
(Linux/Linux)

Question: How to get the date for next week friday or any other day of the week via the command line in Linux?   Answer:  Open a new Terminal Window Type in the following commanddate -d fri Description: ...

6. How to find the User Id for a specific user in Linux?
(Linux/Linux)

Question: How to find the User Id for a specific user in Linux?   Answer: Open a new Terminal Session if not already in the command line. Enter the following command. Replace UNAME with the name ...

7. ERROR 1194 (HY000): Table 'mytable' is marked as crashed and should be repaired, how do I fix this?
(Databases/mySql)

...   Answer: In the mySql command line you should run the following command to repair the table repair table mytable; //Replace mytable with your table name REPAIR TABLE  repairs a possibly corrupted ...

8. How to change the root password for mySql under Linux in the command line?
(Databases/mySql)

Question: How to change the root password for mySql under Linux in the command line?   Answer: You will need to know the current root password in order to change it In the command line type in and ...

9. How to search and replace text within a text file using the Command Line on Linux?
(Linux/Linux)

Question: How to search and replace text within a text file using the Command Line on Linux?   Answer: This can be accomplished by using the sed command. sed =  stream editor for filtering and transforming ...

10. How to install MySql Server 5 on Ubuntu?
(Linux/Linux)

Question: How to install MySql Server 5 on Ubuntu? NOTE: Tried and tested on Ubuntu 10.04   Answer: Open a new Command Line Window  Execute the following command to install MySql Server 5 sudo apt-get ...

11. How to convert FAT32 to NTFS in Windows XP?
(Windows/Windows XP)

Question: How to convert FAT32 to NTFS in Windows XP?   Answer:  Reboot the PC into Safe Mode with Command Prompt. This can be done by pressing F8 during the boot process and a menu will appear, select ...

12. How to install Apache together with PHP5 on Ubuntu?
(Linux/Linux)

... commands: sudo apt-get install apache2 sudo apt-get install php5 sudo apt-get install libapache2-mod-php5 Now we need to restart Apache so that our changes can take effect. There are two commands for ...

13. How-to create a MySQL database and assign user privileges to it?
(Databases/mySql)

Question: How-to create a MySQL database and assign user privileges to it? NOTE: Please note that this is done in the Command Line Interface.   Answer:  First login to the mySql server using root. ...

14. How to Export your MySQL database schema to a file using the Command Line?
(Databases/mySql)

Question: How to Export your MySQL database schema to a file using the Command Line?   Answer:  Use the following command in the Command Line Interface mysqldump --no-data --tables -uMYSQL_USER_NAME ...

15. How to delete a file when getting the error "Error Deleting File or Folder"
(Windows/Windows XP)

... the File Right click in the File and click on Rename Rename the file to a short name eg. file Open up Command Prompt by clicking on "START->PROGRAMS->ACCESSORIES->COMMAND PROMPT" Locate the file ...

16. How to get the number of Words, Characters and Rows within a text file on Linux via the Command Line?
(Linux/Linux)

Question: How to get the number of Words, Characters and Rows within a Text file on Linux via the Command Line?   Answer: By using the wc command. wc = print newline, word, and byte counts for each ...

17. How to check how long your Linux system has been up and running?
(Linux/Linux)

Question: How to check how long your Linux system has been up and running?   Answer: In the Command Line Interface type in the uptime command and hit enter uptime Now the uptime information should ...

18. How to execute SQL commands from a file in postgresql?
(Databases/pgsql)

Question: How to execute SQL commands from a file in postgresql? In my case I had a .sql file with hundreds of insert statements and I wanted to run all of them, I was left with two options namely manually ...

19. How to list all Postgres databases using the Command Line?
(Databases/pgsql)

Question: How to list all Postgres databases using the Command Line?   Answer:  Type in the following command in the CLI (Command Line Interface) psql -l This command will list all of the databases ...

20. How to delete a column in a database table using postgres via the command line?
(Databases/pgsql)

Questions: How to delete a column in a database table using postgres sql via the command line?   Answer: Use the following statement ALTER TABLE my_table DROP COLUMN my_column; Replace my_table with ...