Hello, I am not the final authority on this but you can use SSH/HTTP Tunneling.
More information on it can be found at: http://www.devx.com/security/Article/27854?trk=DXRSS_DB If you have any question regarding, SQLyog, I guess - http://www.webyog.com/forums would be your best guess. Karam --- Scott Purcell <[EMAIL PROTECTED]> wrote: > 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 > __________________________________________________ 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]