Manual and ssh

This topic is empty.

Viewing 9 reply threads

Author

Posts
- January 12, 2005 at 2:09 pm #8737
  
  newbie
  Member
  
  Hi,
  
  I am a new user and I'd like to know if there is any documentation about how to create the xml files for the sja. I have seen some examples but I think is not enough.
  
  BTW, I am trying to do ssh tunneling to sync two servers and I don't know if I have to make any change into the xml file.
- January 12, 2005 at 3:51 pm #16816
  
  Ritesh
  Member
  
  Using SQLyog's Database Sync Wizard, you can easily create the XML files for SJA.
  
  BTW, SJA for Linux does not support ssh tunneling.
- January 12, 2005 at 5:58 pm #16817
  
  newbie
  Member
  
  has The enterprise edition support for linux ssh tunneling?
- January 12, 2005 at 6:01 pm #16818
  
  Ritesh
  Member
  
  If your MySQL and SSH server is installed on a Linux box and you can access it from a remote machine then you can very well access it using SQLyog Enterprise.
  
  You just need to provide the right credentials in the connection window.
  
  HTH
- January 12, 2005 at 6:37 pm #16819
  
  newbie
  Member
  
  ok, thanx.
  
  One more question. Can I syncrhonize two servers from a command line with the enterprise edition? My servers haven't X, so I have to use shellscript.
- January 12, 2005 at 6:56 pm #16820
  
  Ritesh
  Member
  
  SQLyog Job Agent (SJA), the database sync engine used by SQLyog is a command line tool.
  
  The windows version of SJA wont run on Linux. You can use the Windows version to sync any two databases. It can use HTTP/SSH tunneling if direct connection to the MySQL server is not provided.
- January 12, 2005 at 7:41 pm #16821
  
  newbie
  Member
  
  Thanx, but I still have a doubt.
  
  I have two servers running linux, I want to make a mirror of my database (Mysql), the conection has to be secure, the servers has basic funcionalities (no X). If I buy the enterprise edition can I do what I want?
- January 12, 2005 at 8:46 pm #16822
  
  peterlaursen
  Participant
  
  I think I'll try to clarify a little !
  
  Sqlyog is a Mysql-CLIENT-program for windows and can do the task if it's installed on a windows machine having access to both servers. Sqlyog does not care (like no Mysql-client does) on which platform the server(s) run. But it can not be installed or run on Linux.
  
  SJA for Linux is a Mysql-CLIENT-program to run on a Linux machine. That machine can of course be one of your servers.
- January 12, 2005 at 8:49 pm #16823
  
  peterlaursen
  Participant
  
  And just want to add in cas you don't know …
  
  The syncronization agent (both versions) will only work with tables that have a Primary Key.
- January 13, 2005 at 1:25 pm #16824
  
  Sthistle
  Member
  
  Why not simply mysqldump on one server, sftp it to the other server and load it in? How big is it?
  
  Using this method, you also have a backup
Author

Posts