Thanks for the info. I did not know there was a GUI for the mysql product. I installed it and its like Toad for mysql. Very cool.
As I am not very strong at using mysql, I am a J2EE developer. I came up with two questions I need some more support with. 1). My home box does not have a static IP address, and my machine at work is behind a firewall, and we use DHCP. So I do not know if I can use sja? Anyone know? Upon reading, it looks like there is a need to use an IP on both ends. 2). Do ISPs allow this type of synchronization? 3). Is there a way to do a simple backup in the interim (copy the data to removable media) and copy to other machine until I get this all worked out? I see some export data capability in the SQLyog program. But do not know if this is valid? Thanks, Scott -----Original Message----- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Thursday, May 05, 2005 12:08 PM To: Scott Purcell; mysql@lists.mysql.com Subject: Re: Work / Home DB synchronization You require SQLyog's Data Sync Tool. Download it from http://www.webyog.com You can find an article on it at: http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent Karam --- Scott Purcell <[EMAIL PROTECTED]> wrote: > Hello, > > I am developing a web application in which I have > been working between home and an away office. > Anyway, up to lately, most of my efforts have been > writing the queries, etc for the backend. So I have > a text file that dumps the database and repopulates > them. And up until now, it has been effective in > getting some "basic" data into the datase to code > against. > > But now, that portion is done, and I am starting to > port more data into the database. Data I need to > display purposes, etc. > > Is there a simple, easy, effective way to transfer > the data between home and away? What I do for the > code, is create a .war file and copy that to a ram > stick and transfer it that way. But when it comes to > the database, I am not sure how to keep them > synchronized? > > Less than 10,000 total records at launch time. > > Thanks, > > Scott K Purcell > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
