How to configure nautilus to open new window in same folder in Fedora

Open System->Preferences->File Management
Check the box that marked “Always open in browser windows.”

File Management behavior

How to install Compiz Fusion in Fedora 11

This guide assumes that you have video card that supports 3d acceleration installed in your system.
To install compiz fusion, open up your terminal and type this command:

yum install ccsm compiz-manager compiz-fusion-extras compiz-fusion-extras-gnome fusion-icon-gtk compizconfig-backend-gconf

Then go to System->Preferences->Startup Applications.

Startup Applications

How to install NVIDIA proprietary graphics driver in Fedora 11 using yum

Why install this driver?

Your NVIDIA video card will work on your Fedora 11 box without this driver, however if you want to enable the 3D acceleration (if you want to use Compiz Fsuion) you need to install it.

Which driver to use?

The latest nvidia driver: This is a proprietary driver that works with newer nvidia cards.
The legacy nvidia driver: This is also a proprietary driver, but it works with older nvidia cards.
Current list of Legacy NVIDIA drivers:

  • Legacy version (173.xx series)
  • Legacy version (96.xx series)
  • Legacy version (71.xx series) Note: This driver is not available in RPM Fusion repository.

More from this website.
You need to identify which nvidia driver is ideal for your video card. Open up your terminal and type this command:  full story »

How to make totem media player play wma, mp3 and real audio in Fedora 11

Install xine backend.

yum install xine-lib xine-lib-extras xine-lib-extras-freeworld xine-plugin totem-xine

Since totem uses gstreamer as its default backend, we need to change its backend to use xine. To do it, just type the command:

totem-backend -b xine

You can now play mp3, wma and real audio using totem media player. To know more about xine, please click this link.

How to install latest flash plugin for firefox in Fedora 11

Adobe flash player is available via yum. To download flash player, enable adobe yum repo using this command:

rpm -Uvh http://linuxdownload.adobe.com/adobe-release/adobe-release-i386-1.0-1.noarch.rpm

After enabling the repo, install the flash player plugin. Type this command:

yum install flash-plugin

Flash player is now installed in your system, just restart your firefox if is currently running and you can now watch flash content in your browser.

How to install Sun Java Runtime Environment (JRE) in Fedora 11

This is a straightforward tutorial on how to install Sun Java Runtime Environment (JRE) in Fedora 11.
1. Go to the site below and grab the latest version of Java Runtime Environment.
http://java.sun.com/javase/downloads/index.jsp
2. After downloading the file, make the file executable

chmod ug+x jre-6u16-linux-i586-rpm.bin

and install.

./jre-6u16-linux-i586-rpm.bin

3. After the installation, you need to configure your system to use the newly installed Java Runtime Environment.

alternatives --install /usr/bin/java java /usr/java/default/bin/java 5
alternatives --config java

During the installation of your Fedora 11 CD or DVD, the OpenJDK 6 development and runtime packages are installed by default.

There are 3 programs which provide 'java'.

  Selection    Command
-----------------------------------------------
*+ 1           /usr/lib/jvm/jre-1.6.0-openjdk/bin/java
   2           /usr/lib/jvm/jre-1.5.0-gcj/bin/java
   3           /usr/java/default/bin/java

Enter to keep the current selection[+], or type selection number: 3

Enter "3" to change it to your newly installed Java Runtime Environment.
Verify your version of java using this command:  full story »

RPM Fusion's Kdenlive error

I've got this strange error below when I upgraded my Kdenlive 0.7.4 to 0.7.5 from "RPM Fusion repository".

Kdenlive error in Fedora 11

To fix the problem, you have to delete the file "~/.kde/share/config/kdenliverc" because of wrong MLT binary name in it.

How to show MySQL table details?

Issue this command in your MySQL prompt to show table column detail.

desc user;

or

describe user;

The display would be as follows:  full story »

How display database tables in MySQL?

Switch to a database you want to use using this command:

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Once you have selected the database, just type this command to show all the tables inside it.

mysql> show tables;

The database tables are shown below.  full story »

How to delete MySQL database?

To delete MySQL database, just simply type this command inside MySQL terminal.

mysql> drop database test_db;
Query OK, 0 rows affected (0.07 sec)