Free mysqlrowcopy 1.0 software for linux

mysqlrowcopy is a tool that generates insert statements from result sets. It produces output similar to what might result from running mysqldump on a single SELECT query.

This project helps eliminate some of the tedium of moving data between QA and production MySQL databases.

Build:

To build mysqlrowcopy, you should run:

./configure
make

A mysqlrowcopy and mysqlrowcopy.debug file are created. They have identical functionality, the .debug version simply has debugging symbols built in (for gdb).

Since mysqlrowcopy is probably going to be I/O bound with modest CPU and RAM usage, the only reason to even build a 64-bit version is to work around potential issues in dynamic linking 32-bit binaries against 64-bit libraries.

RECIPES

1. Migrating a MySQL user account reaper from QA server to a production server.

e.g. MySQL database server qa3.example.com to prod1.example.com:

$ mysqlrowcopy -h qa3.example.com
SELECT * FROM db WHERE User = "reaper" mysql db > reaper.sql
$ mysql -h prod1.example.com mysql < reaper.sql

You could of course simply pipe the output of mysqlrowcopy into mysql and skip the intermediate file.

(Dont forget to RELOAD PRIVILEGES afterwards)

2. Keep your test environment up to date. Populate it with production data every 24 hours. You could run this sequence from cron once a day:

$ mysqlrowcopy -h finance-db.example.com
SELECT * FROM stocks WHERE modified > DATE_SUB(NOW(),INTERVAL 24 HOUR)
finance stocks > day-stocks.sql

$ cat day-stocks.sql | mysql -h finance-test.example.com finance

3. Copy data between tables on different servers that have some similar fields.

Youve got common data in table Zip on a production database:

mysql> desc Zip;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| ZIPCode | varchar(5) | | PRI | | |
| ZIPCodeType | char(1) | YES | | NULL | |
| City | varchar(32) | YES | | NULL | |
| CityType | char(1) | YES | | NULL | |
| State | varchar(32) | YES | | NULL | |
| StateCode | char(3) | YES | | NULL | |
| AreaCode | char(3) | YES | | NULL | |
| Latitude | varchar(12) | YES | | NULL | |
| Longitude | varchar(12) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

And youve got table ZipPosition in a research database:

mysql> desc ZipPosition;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| ZIPCode | varchar(5) | | | | |
| Latitude | varchar(12) | YES | | NULL | |
| Longitude | varchar(12) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

You want to load data from production Zip into research ZipPosition.

$ mysqlrowcopy -h production SELECT ZIPCode,Latitude,Longitude common ZipPosition > pos.sql
$ cat pos.sql | mysql -h qa research

Note how we specify ZipPosition on the first line to tell mysqlrowcopy what the destination table is going to be.

Nitrogen project is a background browser and setter for X.

It is written in C++ using the gtkmm toolkit. It can be used in two modes: browser and recall. It is multi-head friendly and can even work in GNOME. Nitrogen has been in development for over 2 years, due to real life and laziness. For more info, check out the features section.

Wchange provides a very simple wallpaper changer.

It requires only java runtime environment (JRE) and gconftool-2.

Usage:

java Wchange /home/folder/pictures/ seconds [random]

Where:

/home/folder/pictures/ is the directory where are wallpapers

seconds is how much time the system will wait between wallpaper switching

random (optional) use it only if you want wallpaper random switching

wmEbay monitors eBay auctions and it shows auction title and current price.

EditWithKateKeditKwrite is a service menu which allows you to choose an application to open different text files.

Author description:

I need one of these three actions for many files types of my own (but always text files), and I always have to open a dialog box to choose an application although its very often one of those.

The installation is as basic as possible : uncompress, chose one (or several within the 6) file(s) regarding to your language, and copy it (them) in your service menus folder. Thats all.

No dependancies. No mysteries.

I guess it could help at least some beginners like me.

Locales are french and english. Easily adaptable by everyone.

gsnapshot is a GTK2 application. The project provides for capturing a screen snapshot of the entire screen, a window or a region, with a simple user interface.

gsnapshot only depends on GTK version 2.8.x (developed and tested with gtk-2.8.16) thus, only X Windows is needed to capture the screen, a window or a region.

Localized with many translations taken from BabelFish many may be awful: German, Spanish, French, Bahasa Indonesia, Italian, Japanese [Default: English]

Screen capture can be saved to a file as PNG, JPEG or BMP format.

Screen capture can be printed to a PostScript file or piped to /usr/bin/lp.

Kmplot is a mathematical function plotter for the KDE-Desktop. It has built in a powerfull parser.

You can plot different functions simultaneously and combine their function terms to build new functions.

Kmplot supports functions with parameters and functions in polar coordinates. Several grid modes are possible. Plots may be printed with high precision in correct scale.