NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL sync tool ...

Keith Richardson keith.richardson at thompsonhealth.com
Thu Oct 23 08:52:40 EDT 2003


I would think to either to create a changelog, and then only sync the
changes (like the keys/tables of what needs to be added/deleted), or do the
changes in both databases at once, just that would be so slow :/
Keith Richardson
Thompson Health Information Systems
keith.richardson at thompsonhealth.com
<mailto:keith.richardson at thompsonhealth.com>

-----Original Message-----
From: Mark Withington [mailto:mwithington at PLMresearch.com]
Sent: Thursday, October 23, 2003 8:42 AM
To: 'NYPHP Talk'
Subject: RE: [nycphp-talk] MySQL sync tool ...


Under the heading of MySQL snyc...

Anyone have a 'best practices' primer they can recommend?  I've got two
disparate databases (one MySQL) that I'd like to 'sync' on a nightly basis.
In fact, the other database will simply feed the MySQL one with out
reciprocation from MySQL.  Really _don't_ want to have to upload the entire
database, but rather incremental changes.

Thoughts?

--------------------------
Mark L. Withington
PLMresearch
"eBusiness for the Midsize Enterprise"
PO Box 1354
Plymouth, MA  02362
o: 800-310-3992
f: 508-746-4973
v: 508-746-2383
m: 508-801-0181
http://www.PLMresearch.com
Netscape/AOL/MSN IM: PLMresearch
mwithington at plmresearch.com
Public Key: http://www.PLMresearch.com/html/MLW_public_key.asc
Calendar: http://www.plmresearch.com/calendar.php


-----Original Message-----
From: talk-bounces at lists.nyphp.org
[mailto:talk-bounces at lists.nyphp.org]On Behalf Of jon baer
Sent: Wednesday, October 22, 2003 11:19 PM
To: talk at lists.nyphp.org
Subject: [nycphp-talk] MySQL sync tool ...


came across a pretty cool tool called sqlyog (needed to local <-> remote
sync) - are there any others? ...

http://www.webyog.com/sqlyog/scrnshot.html

-features-

a.. MySQL 4.1 compatible
a.. very fast retrieval of data
a.. ODBC Import with option to import data through query
a.. data sycnhronization tool
a.. schedule various jobs
a.. schema synchronization tool
a.. update result returned from query
a.. manage foreign key relationships
a.. fully InnoDB compliant
a.. view your results in GRID / TEXT mode
a.. fast client side sorting and filtering
a.. execute ( very large ) SQL-scripts as batch files
a.. execute multiple queries returning more than 1000s of rows per
resultset. Its very efficient in memory
a.. very compact binary
a.. written entirely in C/C++/Win32 APIs using native MySQL C APIs. No
wrapper classes used
a.. connection manager
a.. excel like grid interface to create/alter tables
a.. excel like grid interface to edit data with support for Enum/Set
a.. create/drop databases
a.. manage indexes
a.. comprehensive security manager. Control access to
databases/tables/columns
a.. reorder columns of table
a.. copy database between two MySQL hosts
a.. drop all tables of a database with a single click
a.. edit BLOBs with Bitmap/GIF/JPEG-Support
a.. export table-structure and data into SQL-scripts
a.. export/import data in/from CSV files
a.. export database schema in HTML
a.. log all queries for a session
a.. profile queries
a.. syntax-highlighting
a.. save resultset in CSV, HTML and XML
a.. save your commonly used SQL scripts in a personal folder with a click of
mouse
a.. is very keyboard friendly. You can work with 99% features of SQLyog with
keyboard.

a.. view and kill other user-processes
a.. view advanced table-properties, such as Type, Comment, Key_Length and so
on
a.. a list of server-variables e.g processlist, status, variables etc
a.. copy your result as CSV in clipboard
a.. copy tables to new table-names
a.. change table-types to ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB
a.. flush Host/Logs/Privileges/Tables
a.. do table-diagnostics (check, optimize, repair, analyze)


pgp key: http://www.jonbaer.net/jonbaer.asc
fingerprint: F438 A47E C45E 8B27 F68C 1F9B 41DB DB8B 9A0C AF47

_______________________________________________
talk mailing list
talk at lists.nyphp.org
http://lists.nyphp.org/mailman/listinfo/talk
_______________________________________________
talk mailing list
talk at lists.nyphp.org
http://lists.nyphp.org/mailman/listinfo/talk




More information about the talk mailing list