Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberYes. You can export data with the default settings.
Ritesh
MemberSQLyog 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
Ritesh
MemberAre your source and target MySQL server located on different machines?
Ritesh
MemberYeah I got it 🙂
Ritesh
MemberCan you send me a backup of your database?
Information like OS, MySQL version would be very helpful.
Ritesh
MemberUnfortunately, 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:
Ritesh
MemberHave you tried connecting to those servers?
Ritesh
MemberYou 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.
Ritesh
MemberCan you tell me your Source and Target MySQL versions?
Ritesh
MemberI have received the dump. Thanks 🙂
Ritesh
MemberHello,
Which version of MySQL?
Can you attach a dump of the database?
Ritesh
MemberI 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.
Ritesh
MemberThats true Shadow but we prefer to give support on SQLyog 🙂
Ritesh
MemberThis problem was reported by CalEvans before. We have already fixed it in 3.7.
Ritesh
MemberAre 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