CVS log for scripts/perl/mysql/mysql-table-copy.pl

Up to [Platon] / scripts / perl / mysql

Request diff between arbitrary revisions / Display revisions graphically

Default branch: MAIN

Revision 1.18 / (download) - [select for diffs], Wed Feb 6 00:07:29 2008 UTC (2 years, 1 month ago) by rajo


Changes since 1.17: +45 -15 lines
Diff to previous 1.17 (colored)

Data in destination table can be updated according UNIQUE KEY

Revision 1.17 / (download) - [select for diffs], Sun Feb 3 23:57:44 2008 UTC (2 years, 1 month ago) by rajo

Changes since 1.16: +4 -6 lines
Diff to previous 1.16 (colored)

Fix: wrong SQL syntax with WHERE condition.

Revision 1.16 / (download) - [select for diffs], Sun Feb 3 23:41:35 2008 UTC (2 years, 1 month ago) by rajo

Changes since 1.15: +50 -31 lines
Diff to previous 1.15 (colored)

* Use Getopt::Long to parse command line parameters.
* Added --where='db_column = 5' parameter with SQL condition

Revision 1.15 / (download) - [select for diffs], Wed May 11 10:17:48 2005 UTC (4 years, 10 months ago) by nepto

Changes since 1.14: +39 -14 lines
Diff to previous 1.14 (colored)

Implemented -nd option: skip removal of source items, insert new only

Revision 1.14 / (download) - [select for diffs], Tue May 10 10:11:17 2005 UTC (4 years, 10 months ago) by rajo

Changes since 1.13: +5 -9 lines
Diff to previous 1.13 (colored)

Code optimalization.

Revision 1.13 / (download) - [select for diffs], Tue May 10 10:06:14 2005 UTC (4 years, 10 months ago) by rajo

Changes since 1.12: +2 -2 lines
Diff to previous 1.12 (colored)

Fixed typo.

Revision 1.12 / (download) - [select for diffs], Tue May 10 10:00:16 2005 UTC (4 years, 10 months ago) by rajo

Changes since 1.11: +2 -2 lines
Diff to previous 1.11 (colored)

Use localtime() instead of gmtime().

Revision 1.11 / (download) - [select for diffs], Tue May 10 09:57:17 2005 UTC (4 years, 10 months ago) by rajo

Changes since 1.10: +2 -2 lines
Diff to previous 1.10 (colored)

Changed output datetime format.

Revision 1.10 / (download) - [select for diffs], Tue May 10 09:54:25 2005 UTC (4 years, 10 months ago) by nepto

Changes since 1.9: +11 -8 lines
Diff to previous 1.9 (colored)

Added -verbose switch.

Revision 1.9 / (download) - [select for diffs], Tue May 10 09:52:55 2005 UTC (4 years, 10 months ago) by rajo

Changes since 1.8: +2 -2 lines
Diff to previous 1.8 (colored)

Updated copyright year.

Revision 1.8 / (download) - [select for diffs], Tue May 10 09:49:25 2005 UTC (4 years, 10 months ago) by nepto

Changes since 1.7: +7 -3 lines
Diff to previous 1.7 (colored)

Added -exit switch.

Revision 1.7 / (download) - [select for diffs], Tue May 10 09:40:39 2005 UTC (4 years, 10 months ago) by nepto

Changes since 1.6: +17 -4 lines
Diff to previous 1.6 (colored)

Added switch for PRIMARY KEY replication.

Revision 1.6 / (download) - [select for diffs], Tue May 10 09:19:23 2005 UTC (4 years, 10 months ago) by nepto

Changes since 1.5: +21 -1 lines
Diff to previous 1.5 (colored)

Added Oracle specific issues:
    - transaction auto-commit
    - usage of YYYY-MM-DD HH24:MI:SS date format

Revision 1.5 / (download) - [select for diffs], Tue May 10 08:36:03 2005 UTC (4 years, 10 months ago) by nepto

Changes since 1.4: +6 -3 lines
Diff to previous 1.4 (colored)

Ability to specify also non MySQL database type
(thought MySQL is still as default)

Revision 1.4 / (download) - [select for diffs], Tue Mar 15 23:25:04 2005 UTC (4 years, 11 months ago) by rajo

Changes since 1.3: +23 -1 lines
Diff to previous 1.3 (colored)

Autoreconnect into DB.

Revision 1.3 / (download) - [select for diffs], Sat Dec 20 09:04:20 2003 UTC (6 years, 2 months ago) by rajo

Changes since 1.2: +7 -11 lines
Diff to previous 1.2 (colored)

Accept username and passwords to db from cmdline.

Revision 1.2 / (download) - [select for diffs], Tue Dec 16 18:16:49 2003 UTC (6 years, 2 months ago) by rajo

Changes since 1.1: +1 -2 lines
Diff to previous 1.1 (colored)

Fixed typo.

Revision 1.1 / (download) - [select for diffs], Fri Nov 7 08:42:49 2003 UTC (6 years, 4 months ago) by rajo

MySQL table copy utility.
Read data from database1.tableName, write data to database2.tableName
and then delete writed data from database1.tableName

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.