Tag: opensource

Posted on

How to Import export MySQL database from command line

This tip would be useful for those who are either making backup of their remote mysql database or moving their web hosting to their provider.

Here’s how to export mysql DB to SQL file using command-line utility :
mysqldump –user=username –password=1234 –databases your_database –opt –quote-names –complete-insert > example.sql

Here’s how to import the SQL back into mysql database :
mysql –user=username –password=1234 –databases your_database –host=mysql_server host

Don’t forget to add your ip address to the list of allowable host on the remote MySQL server!

Posted on

Mitter: My favorite Ubuntu Linux Twitter client

Since I’ve been into twitter recently, I’m was looking for a twitter client that is suitable for my operating system. Thank god that search ended when I found mitter.

Among mitter features are :

  • clean interface: simple and easy to use
  • supports docking on systray
  • nicely integrated with GNOME desktop
  • has console client

Bonus for Ubuntu users : mitter is also available from GetDeb.net one-click-install portal

What are you waiting for? catch me on twitter (id: mypapit)

Posted on

Ubuntu Feisty Fawn is approaching end of life support

Important announcement!

Those who are still using Ubuntu 7.04 (Feisty Fawn) are advised to upgrade their distribution to later releases as it approaches end-of-life support, this October.

What is end-of-life ?
End of life means that the time where a product is no longer supported by its vendor. In case of Ubuntu 7.04 (Feisty Fawn), it will no longer receive security updates and patches. Normally this would not cause problem to desktop computer, but if you are advised to patch your system as regularly as you can if you are connected to the internet to prevent malicious user from accessing your pc.

Curious about how long other Ubuntu releases are being supported? you can refer here : Ubuntu Releases and end of life date

Posted on

How to convert OpenXML docx files to OpenDocument odf in Windows and vice versa

This guide might be a little different from the others because I write this for the Windows users. Here’s how to convert Microsoft OpenXML docx files to odf OpenDocument files (and vice versa) in Windows using only commandline :

  • First, make sure you downloaded odf-converter tool and copy it to appropriate folder.
  • Convert the files(s) using this command line :
    odfconverter /I filename.pptx
    and the tool will perform the conversion effortlessly.
  • You can use this command to convert multiple files :
    odfconverter /BATCH-DOCX /I c:\newfiles\

    replace /BATCH-DOCX with /BATCH-PPTX, /BATCH-XLSX, /BATCH-ODF, /BATCH-ODP if necessary.

Odfconverter also supports converting Open Document files (ODF, ODP, ODT) to OpenXML files (PPTX,DOCX,XLSX) making it a handy tool to use.

Why odfconverter?
Odfconverter is a (relatively) small and compact standalone tool for converting Office 2007 files to their OpenDocument counterpart. The convenient batch mode conversion makes it attractive tool to use when converting multiple files between the two formats.

The only downside with this converter is that it does not convert mathematical formula pretty well compared to other features.

[Source OOOninja]

Posted on

How to install *.rpm in Ubuntu / Debian based operating system

There are times when you need to install an application that is only available in *.rpm package in Debian GNU/Linux or Ubuntu operating system. One of the main obstacles is that Debian / Ubuntu are using *.deb based packaging system which is incompatible with RPM.

However you can easily convert RPM package to *.deb and install it afterwards, here’s how to do it :

  • Install alien, its available in Debian, Ubuntu repository
  • Convert rpm package using command “sudo alien -k some-binary-package.rpm”
  • Install it using this command “sudo dpkg -i some-binary-package.deb

That’s all about it! Have fun installing application in your application.

Posted on

Subscribed to Linux Hater’s Blog : Funny and hillarious blog

After discovering Linux Hater’s blog from Google Reader and Technorati, I decided to subscribe it as it was a funny and hillarious blog. It make fun of people who are using Linux for the wrong reasons (such as trying to act cool) and how some things in Linux are not better than any other operating system.

Linux Tux Logo

Other than that, it contains criticism of the Linux community in general, mainly directed towards fanboys and developers, although one can easily surmise that the author himself is a Linux user who has experience in writing applications, and presumably using a Debian-derived Linux distro.

Well I might be wrong, but Linux Haters Blog is a must read if you are a Linux user yourself because it offer insights of the overall of how GNU/Linux operating system compare to other OS and what would make Linux a better OS