Forum Replies Created
-
AuthorPosts
-
RiteshMember
Can you explain the problem a little more?
What are your specific needs?
RiteshMemberIs it in CSV format?
RiteshMemberWhat does it take from our side to make you 100% SQLyog?
RiteshMemberConfirmed 😀 will be fixed in 3.8.
RiteshMemberIf we dont generate checksums, there is no way to compare the data without bringing the entire data to the client.
RiteshMemberLet us start by synchronizing our terminologies!
I think the aforementioned “database” of ~3 million entries is really a single table containing those rows. If that is the case, we need to reduce the no. of test cases by trying to synchronize all other tables other than this table. If that works, then we have only got this table to look into. You could then send us the table structure and some sample data ( if not confendential ). We would immediately start working on it.
Please send the table structure, etc to [email protected]
RiteshMemberSQLyog does not issue any “explicit” lock commands during DB Sync.
The SJA algorithm in mainly designed to sync data using “minimal” data transfer. That means incredible performance gains if network is a bottleneck.
RiteshMemberSSH support is planned for SQLyog 4.0 and future versions of SQLyog Max.
Till the time we incorporate SSH tunneling in SQLyog, you can use 3rd party tunneling tools like Van Dyke Secure CRT or Putty.
You can follow the given steps:
- setup the port forwarding in your favorite SSH client.
- connect your SSH client to your server.
- If the tunneling is working correctly then fire up SQLyog and tell it to connect to the server localhost, enter in your username and password for your server, click the connect button.
A very good tutorial on SSH port forwarding (tunneling) with MS Windows can be found at http://acd.ucar.edu/~fredrick/mpark/ssh
RiteshMemberI have forwarded the request to my development team.
RiteshMemberFill in the following details:
MySQL Host Address: IP address of the machine on which MySQL server is running.
Username: Your MySQL username. Its the same as in phpMyAdmin.
Password: Your MySQL password. Its the same as in phpMyAdmin.
Database: The database you are going to work on. You can leave this field blank if you want to work with all the databases in the MySQL server.
Note: Make sure that the server is up and running and you have correct privileges to connect from a remote host.
RiteshMemberCan you explain the problem a little more?
RiteshMemberAfter you have selected Save & Schedule It… option, you need to provide the jobfile and schedule name in the next page.
Clicking finish will load up the Windows job scheduler where you can set the other options. Are you not getting this page?
RiteshMemberWait for SQLyog 3.8 which is 2 weeks away.
Ver 3.8 would allow you to connect to MySQL host thru PHP/HTTP tunnelling. This means that SQLyog ( and SJA ) will continue to work even if the MySQL port is blocked, as well as in case of MySQL security disallowing remote access.
RiteshMemberYes.
Use SQLyog Notification Services. The option can be found in Tools -> SQLyog Notification Services
RiteshMemberzzapper wrote on Aug 20 2004, 04:42 PM:RiteshNow we're sucking diesel' (Now we're making progress! of Irish origin)
😀 😀
Great to know that SQLyog works for you 😀
-
AuthorPosts