1. run following command in terminal
  
   sudo apt-get install mysql-server

    during the installation process it will ask for root password

2. to check whether the Mysql server is installed & running properly,run
  
   sudo netstat -tap | grep mysql

   you sholud see now the following lines or something similar:
  
   tcp        0      0 localhost.localdo:mysql *:*                     LISTEN      13059/mysqld

3. If in case your server is not running properly you can restart it by running following command
   sudo /etc/init.d/mysql restart

Using Mysql
4. when mysql is installed, you can start it by running:

 mysql -u root -p

the command prompt will change now to mysql>

5. to create database use:
    create database databasename;
6. to use database use:
    use databasename;

from here on you can create table,insert into table and peroform other mysql actions

Well determined to use my powerful little net-book for as many things as possible that it was not intended to be used for,I wiped Windows 7 Starter and installed Ubuntu 11.04 32 bit; which went extremely smoothly, and Ubuntu was able to install and detect everything on it's own. The only work I had to do on top of installing Ubuntu 11.04, was clicking on “additional drivers” and enabling the proprietary drivers for my Nvidia Ion card(That's right, my little 10 inch net-book has a 512 V-RAM Nvidia Ion graphics card). My wireless card, bluetooth, everything built-in to my net-book Ubuntu 11.04 installed smoothly and easily. However, I felt this was all too easy and simple, so I wanted to take it a step further.

  With a real operating system installed (The “Starter” edition of windows 7 lacks many basic features for my net-book, such as switching between the on-board video card and my Nvidia card for battery saving reasons). I decided to attempt to install a virtual copy of Windows 2003 Server on my net-book for no other reason then to prove to myself and the world that it can be done. The first thing I did was restart the computer and check my BIOS settings to see if my net-book supports virtualization, it was a false hope but it turns out they don't put that option in the BIOS of 10 inch net-books... I thought this would be the case. This led me to believe that I was in the beginning of a big waste of time, because without being able to enable virtualization on my BIOS, that usually, if not always, means that my BIOS/mainboard does not support virtualization. But hey, why let this stop you?

  I continued on my quest to run a functional virtual copy of Windows 2003 Server on my net-book (Why windows? Because hey, if it can run a virtual copy of Windows, it can run a virtual copy of anything!). Next I install VirtualBox OSE direct from the Ubuntu Software Center then made a 20 GB 256 MB RAM Virtual slot for my soon to be OS. Once that completed, I proceeded to install Windows 2003 Server in VirtualBox on my new net-book.

After waiting for windows to finally install, I had a tough time staying determined to make this work, but still I kept at it while watching the windows installer 40 minute count-down slowly pass. Once done, it rebooted the VirtualBox OSE to start Windows 2003 Server, then I rebooted it a few more times to make sure it wasn't a fluke... Cross your fingers.... this is the moment of truth.

Victory!!! Man +1 Machine 0

I have now installed Ubuntu 11.04 Desktop, VirtualBox OSE, and Windows 2003 Server onto my net-book.

Net-book specifications:

ASUS Eee PC Seashell 1015PN

CPU SPEED: 1.66 GHZ

Processor: Intel Atom 570 (Dual-Core)

Memmory: 1GB 1333mhz 204 pin RAM

Hard Drive: 250 GB

We are pleased to announce our new openSUSE Weekly News Issue 184.

In this Issue:

You can download it there:

• Weekly News in PDF Format
• Weekly News in HTML (Bento Theme)
• Weekly News in HTML (Susebooks Theme)

We hope you enjoy the reading :-)

If you want to help us collecting interesting articles for the openSUSE Weekly News, so you can all your stuff into our new ietherpad: http://os-news.ietherpad.com/2.

Found Bugs? Please place it in our Bugtracker: http://developer.berlios.de/bugs/?group_id=12095

Features, Ideas and Improvements can placed in our Featuretracker: http://developer.berlios.de/feature/?group_id=12095

Older content can be found there.

The conversion procedure is very simple enough. Let us assume /dev/sda6 (ext2 now) mounted on /convert.  You will be seeing fstb entries like,

/dev/sda6         /convert             ext2    defaults        0 0

Unmount the partition

umount /dev/sda6

Enable Journal (converting to ext3) using tune2fs command,

tune2fs -j /dev/sda6

Edit /etc/fstab and for /dev/sda6 change the file system type to ext3. Finally, the entry should be like this,

/dev/sda6         /convert             ext3    defaults        1 2

Mount the partition using mount command,

mount -a

If above command doesn’t work, reboot the system and check.

to change the case of selected text

Ctrl + Shift + X  :  to_upper

Ctrl + Shift + Y  :  to_lower

 

So I'm blowing away, and re-installing, my Steam Bottle on Codeweaver's Crossover games. I was hoping to get some in-game overlay support for the Community/Friends features of Steam. I really really want to hang on to Team Fortress/Left 4 Dead settings though.

Using the find command we can solve this problem fairly easy.

I started becoming interested in programming maybe 2 years ago. I did some reading and saw VB.NET may be easier to start with. So, I bought some books, watched some videos and started punching away at small apps. Received some major help from DiC users on something I put together from work and it was a lot of fun.... but was VB.NET what I wanted to learn? My first programming class was a Java class. I was very excited since I am a huge Linux fan and Java is cross-platform. Bought some more books, read some more forums and started coding Java. For some reason, I just couldn't get into it. Next, I went for C# since it is similar to Java but I get to use VB Studio, put together my GUI and code around that. I enjoyed that a lot! But, I didn't like the Mono Project in Linux. Then, I looked into Python.... Python from the get go hit me like a beautiful woman from across the room and we stared at each other as she sauntered over and said,

Then strolled out of the room leaving me helpless.
I melted. I was officially in love and wanted to see her again. I grabbed more books, checked more forums for her. Coded love letters to her. Everything I could do to see her again. I have found what I was looking for.... A language I could use on Linux and Windows, was sexy and made me happy.
THEN! What happens. Phone rings.. nasty Ex calls. "Hi, since your work uses Windows only and they are using MS Office apps with a ton of VB code in it. Why don't we have dinner?" DAMNIT! So. Not that I want to really stop seeing Python but VB.NET is still kind of sexy. So, again I will start studying VB.NET and maybe see C# on the side but really sneak out and see Python in between. I will use VirtualBox and Windows 7 so I have the best of all worlds. Almost like a polygamist of languages. Side note:
It is actually quite annoying. I'm sure I'm not the only one with this problem. I like a lot of programming languages, I like a lot of different computing aspects but not one have I really taking to the next level and learned everything there is to know or at least I can about it. I can't quite pick a direction yet. I guess I'm just dabbling and maybe the day will come.

Lets face it, all blogging systems and wysiwyg (What You See Is What You Get) editors have some quirks that the user must work around, particularly when you attempt to paste a pre-built formatted document into the blog system. In the case of the Linux.com Blog system it retains most of the original formatting including text size which may not appear well once it is published in html. For that reason I am here to share my trick with the other users of the blog system so everyone can have well formatted tutorials and blog posts.

Lets cut to the chase

In efforts to allow you more time to write your own posts we can jump to my major points.

1. Do not write your posts in a formatted application, use only a text editor.
2. Write the post in html using standard flags such as headings, breaks, paragraphs, ordered lists and unordered lists.
3. Paste your text based file into the Plain Text tab, then add the pictures, hyperlinks, special characters and touchups in the formtted view which will be inthe Rich Text tab.
4. Keep it simple, by using only the headers and default font formatting rather than specifying the text size you allow the users to change their browser setting to fit their own preferences rather than forcing your own preferences.
5. All formatting flags except for horizontal rules and line breaks must be started and ended.

Available HTML flags

Now that you know to write the original document in HTML, it is time share the flags that you can use.

• Flags with terminators - all Of the followin flags must be terminated to end the formatting.
  • Paragraph - <p> - This flag is used to notate where a paragraph starts and ends, the ending flag is the paragraph with a / character - </p>.
  • Bold - <b> - This flag is used to indicate where bold text starts and ends, the ending flag includes the / character - </b>.
  • Italic - <i> - This flag is used to indicate where italic text starts and ends, the ending flag includes the / character - </i>.
  • Underline - <u> - This flag is used to indicate where underlined text starts and ends, the ending flag includes the / character - </u>.
  • Headings - The heading flags indicate where Headings/Larger Font text starts and ends, there are four size which are numbered 1-4 from Largest to Smallest such as <h1>, the ending flag includes the / character such as </h1>. Generally I do my Section Headings in H2 and the subsections in H3.
  • Lists - The list flags are special because you must start list with <ol> for ordered lists or <ul> for unordered lists. You must then notate each list item with between <li> and </li>. Remember that the list sets must be terminated with </ol> or </ul> depending on which type you are using.
• Flags without terminators
  1. Line Returns - <br /> - The line returns are used to terminate a line.
  2. Horizontal Line - <hr /> - The Horizontal Lines create a single line across your posts which are useful for seperating sections.

Some additional flags such as adding a hyperlink, a picture or a video can be added, but I recommend using the formatting tools in the Rich Text tab to guarantee that the placement is where you want it. The same can be said for special characters which you will see when you review the text for this post.

Now to make this easier I have posted the html formatted text for this post to pastebin so you can reference it to see what formatting I used.

I hope you learned something and if you have any other hints to share please post them in the comments.

If you have been watching the new feeds you may have noticed that many new corporate members have joined the Linux Foundation lately. Most of the new additions have been big name companies, but the two most recent additions have gotten me very excited.

After a bit of studying and testing, I have found a  very simple way to download RSS feeds from the command line. It works very well, except (in some cases) with encoding. The whole script with explanations is here. Thank you in advance for any help with the encoding problem!