RE: Work / Home DB synchronization
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]
RE: Work / Home DB synchronization
You can use mysqldump to create a text version of your database. Mysqldump will generate the statements that will both (re)generate your tables and populate them with data. It may be the "low tech" solution you asked about. Just "dump" your DB to file (memory stick, zip disk, CD-RW) and move it en masse from one machine to the other. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Scott Purcell" <[EMAIL PROTECTED]> wrote on 05/06/2005 09:05:39 AM: > 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] >
RE: Work / Home DB synchronization
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]
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]
