New year come again..
been there, done that. nothing special :p
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!
Twitter Command Line Client
A nice twitter client for those who are working in CLI environment.
Get twitter-cmdline.
A Windows alternative is also available at : Twitter Windows Command Line Client.
Alternatively you can try a cURL hack to post your update to twitter from command line.
btw my twitter id is ‘mypapit’. Happy twittering.
How to add “Send To” removable USB drive in GNOME
Here’s a way to add “Send To” functionality to copy multiples files to removable drive (usually USB drive) in GNOME desktop.
- First, download the “Send To” nautilus script from : http://www.gdr-exiles.com/nautilus/.
- Copy the Send To file to ~/.gnome2/nautilus-scripts, make it executable. chmod a+x.
Finally you can test it by selecting a file on your desktop and clicking the Send To option, you’ll be presented with a dialog similar to this.
Now you can easily copy files between your GNOME Desktop to your portable USB drive.
Introduction to Linux Workshop Outline and Notes
As promised, I’ve upload materials from the previous workshop that I’ve to conduct :
Hope it would be useful to you!
Get Cool Powered By Ubuntu Stickers Locally in Malaysia !
Great news to all Ubuntu users out there! Fahmi from MelayuBuntu has made available these cool stickers for you to brag to your friends!
The best thing about these stickers is that they are available locally, and thus much more cheaper and is faster to obtain.
Interested? You can forward your order to :
Name : Mohd Fahmi
Maybank : 164799012134
CIMB : 14081271592525
E-mel : editor[a]jomlinux.com
The price for the stickers as follows :
- 1 set (4 pieces) – RM 2.50
- 3 set (12 pieces) – RM 4.50
- 5 set (20 pieces) – RM 6.80
- Delivery : FREE!
Don’t forget to fill in the Order Form after you’ve made payment.
The first batch of these stickers has been shipped out! Order now!
Read the original post from melayubuntu