Forum Replies Created
-
AuthorPosts
-
RiteshMember
Yes. You can export data with the default settings.
RiteshMemberSQLyog uses MySQL's standard BACKUP TABLE… option to take backups. This option does not work if SQLyog and the MySQL server are running on different machines.
If you want to take backup of a remote database, you have to use DB -> Export Database As Batch Script. SQLyog comes with context sensitive help for all its dialogs. Just press F1 and you will be shown help for the dialog i.e. Export Database As Batch Script.
HTH
RiteshMemberAre your source and target MySQL server located on different machines?
RiteshMemberYeah I got it 🙂
RiteshMemberCan you send me a backup of your database?
Information like OS, MySQL version would be very helpful.
RiteshMemberUnfortunately, it isn't possible to connect with SSL using MySQL Client Library on Windows. It is something MySQL would like to support in the future, but currently there are both technical limitations (the code has not been written) and legal limitations (due to incompatibilities with the GPL).
So, until some time in the foggy future, you can work around this by using some kind of tunneling program. See details here:
RiteshMemberHave you tried connecting to those servers?
RiteshMemberYou can use SQLyog Job Agent to sync data between TWO MySQL databases. Your case is perfect for SJA if both the source and target datasource are MySQL.
As of now it is not possible to sync data between two heterogeneous datasources.
RiteshMemberCan you tell me your Source and Target MySQL versions?
RiteshMemberI have received the dump. Thanks 🙂
RiteshMemberHello,
Which version of MySQL?
Can you attach a dump of the database?
RiteshMemberI understand that connecting from the shell is working fine because the configuration is OK on the server. I want you to try the mysql command line tool from the windows pc.
RiteshMemberThats true Shadow but we prefer to give support on SQLyog 🙂
RiteshMemberThis problem was reported by CalEvans before. We have already fixed it in 3.7.
RiteshMemberAre you able to connect thru SSL using mysql client command line tool?
Note: You should try to connect to the remote server in “client-server” mode using mysql client comand line tool.
-
AuthorPosts