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.

SnowIsh provides a Mac-inspired icon theme.
Also greatly inspired by VannillA Cream Icon Set made by djnjpendragon.
Again, all done with inkscape.
Version restrictions:
- Beautiful icons, but the gtk-media-previous-ltr icon is missing from both the PNG and SVG sets (it should be a copy of gtk-media-next-rtl). Also, the Trash icon doesnt show up at large sizes - the fallback is used instead.
Enhancements:
- Add a PNG version (faster)

JScroll is a swing component for Java that provides a virtual desktop pane.

It provides a virtual desktop replete with dynamic scroll bars, dynamic menus, and dynamic button shortcuts.

The JScrollDesktopPane class surmounts the limitations of the original JDesktopPane Swing component, offering a solution to the clipping and overlap problems inherit to said component, and mimics the interface of the original JDesktopPane to provide an easy upgrade path.

It provides a scrolling MDI desktop, one of the most requested features to the Java JDK.

CsvToSql a java based highly configurable and expandable conversion tool and library. You can define the structure of data how render and where write it through a descriptor. CsvToSql project is compatible with the most common rdbms.

csvToSql mission:

- convert csv files to sql statements.

input:

- can read data from comma separated value file
- can read data from excel files

multiple output:

- can write list of sql statements to console
- can create text file with the list of sql statements
- can store data to jdbc resource (database)

How it Works ?

Can be used as library or as standalone program, using csvtosql as a library is very simple, documentation can be found in tutorial section.

Csvtosql provide two frontends for using it as program, executing jar or class net.sf.csv2sql.frontends.gui.simple.SimpleGui a gui will appear. Or you can also use net.sf.csv2sql.frontends.console.ConsoleMain for console version.

SimBar project is a fast and customizable dockbar for Linux.

SimBar is a fast and customizable dockbar. Allows the user to launch applications showing some eye-candy animation. It is written in c++ and wxWidgets and fits well in Gnome but works on most desktop environments. Does not require Compiz nor 3D acceleration.

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

BlankOn is a Gnome icon theme and they are the default icon theme for BlankOn Linux.