Productivity Sauce

Dmitri Popov
Back up MySQL Databases with a Simple Bash Script

Jan 12, 2011 GMT

If you host your own blog or any Web-based application running on the Apache/MySQL/PHP stack, you should have a backup system in place for keeping data stored in MySQL databases safe. There are several solutions that can help you with that, but nothing beats a simple Bash script I stumbled upon in a blog post comment. Here is the script in all its beauty: #!/bin/bash NOW=`date +"%Y-%m"`; BACKUPDIR="location/of/your/backup/dir/$NOW"; ### Server Setup ### #* MySQL login user name *# MUSER="user"; #* MySQL login PASSWORD name *# MPASS="pass"; #* MySQL login HOST name *# MHOST="your-mysql-ip"; MPORT="your-mysql-port"; # DO...
Turn Google Chrome into a Text Editor with Write Space

Jan 07, 2011 GMT

The Write Space app for Google Chrome and Chromium can come in rather handy when you need to quickly scribble down a note without leaving the browser. Once installed, Write Space adds a no-frills text editor to the browser. Despite its simplicity, Write Space has a handful of nifty features. For example, the persistent auto-save function saves the text file on every key press, so you don't have to worry about losing your changes. Write Space also offers live document statistics, such as number of words, line, and characters. You don't need an Internet connection in order to use Write Space, and the app saves text files locally. Write Space...
Use GoogleCL to Upload Photos to Picasa Web Album

Jan 05, 2011 GMT

If you are using Google's Picasa Web Album photo sharing service and you want to automate the process of uploading photos, the GoogleCL command-line toolset can come in rather handy. Once installed on your machine, you can use it to perform several tasks such as creating albums, uploading and tagging photos, downloading photos, etc. directly from the command-line. Better yet, GoogleCL is pretty straightforward in use. For example, you can upload all photos in a directory to a specific album using the following command: google picasa post --title "Travel Photos" /home/user/photos/*.jpgIf the specified album doesn't exist, GoogleCL automatically creates it for you. When you run...
Manage Amazon S3 with DragonDisk

Dec 28, 2010 GMT

Amazon S3 provides ample storage at bargain prices, but to put the service to practical use, you need a client software. There are a few command-line utilities out there that let you manage your S3 storage space, but if you are looking for a graphical client, then you might want to give DragonDisk a try. This graphical S3 client allows you to manage buckets as will as synchronize local directories with S3 buckets. Although DragonDisk is not released under an open source license, it's available free of charge, and it runs on Linux. There is a .deb binary package for Ubuntu and Debian uses as well as a tarball package for other Linux distros. You can use the latter on Ubuntu, too. To run...
Tomdroid: Now with One-Way Sync

Dec 20, 2010 GMT

The version of Tomdroid covered in a previous blog post lacked any advanced features like the ability to sync notes. A lot has changed since then, though. The Tomdroid developers have released a new version of the app which boasts a couple of improvements and new features. The most notable addition is the synchronization feature which supports syncing with the Tomboy Web service and SD cards. For now, the synchronization feature can handle only one-way syncing, though. Using the synchronization feature is supremely easy. Press the Menu hardware button, tap on Settings, and select the desired service. If you want to sync notes with the...
Keep an Eye on Network Usages with NetCounter for Android

Dec 18, 2010 GMT

Many (if not all) wireless carriers have bandwidth caps, so it makes a lot of sense to keep an eye on your network usage to avoid going over the limit. There are a few Android utilities that can help you with that, including NetCounter. This open source app lets you track bandwidth usage with consummate ease, and it can monitor both Wi-Fi and 3G interfaces. NetCounter displays the usage for each interface divided into four categories: Total, Monthly, 7 days, and Today. This gives you a quick overview of the bandwidth usage for different periods of time. In addition to that, NetCounter lets you export data to the SD card as a CSV file. You...
Create Presentations with Ease

Nov 29, 2010 GMT

Although OpenOffice.org Impress offers a wide range of features for creating high-quality presentations, it's too heavy for users who practice the art of minimalistic presentation design. For them, a graphical presentation tool like Ease will probably be a much better fit. While this application may look rather bare-bones, it does include all the essential tools for creating polished presentations and offers a couple of clever features on top of that. Ease's interface is simplicity itself, and you can find your way around in virtually no time. The application offers a couple of pre-made templates to choose from, or you can create a...

Issue 169/2014

Buy this issue as a PDF

Digital Issue: Price $9.99
(incl. VAT)

News

njobs Europe
What:
Where:
Country:
Njobs Netherlands Njobs Deutschland Njobs United Kingdom Njobs Italia Njobs France Njobs Espana Njobs Poland
Njobs Austria Njobs Denmark Njobs Belgium Njobs Czech Republic Njobs Mexico Njobs India Njobs Colombia