[Ritesh]

Hello,

I think this result returned from 4.1.3. Can you cut and paste the result returned from 4.1.1?

You can use SQLyog to get the same result and it is formatted also 😀

[Ritesh]

Can you cut-n-paste the output of the following SQL:

Code:

show table status from `yourdb`

for both the MySQL servers?

[Ritesh]

Currently SQLyog runs only on Windows.

Our next generation upgrade to SQLyog i.e. SQLyog Max would support Windows, Linux and Mac. Check out the roadmap of SQLyog Max at – http://www.webyog.com/forums/index.php?act…ct=ST&f=2&t=472

[Ritesh]

Shadow wrote on Jul 28 2004, 11:22 AM:

Do you mean getting all those INSERT, UPDATE, DELETE statements sja uses to sync the dbs? Currently you can't do that. You may try logging the SQL statements issued against a MySql server, though.

This feature is already in the TO-DO list of SJA 😀

[Ritesh]

jdhr wrote on Jul 27 2004, 12:48 PM:

Thanks for your answer Shadow,

about primary keys, does sja have any problem if I define mor than one Primary Key on a Table??

No 😀 SJA will work perfectly even if you define more then one Primary Key on a Table.

[Ritesh]

Thats a good idea :D. I have forwarded it to my development team.

[Ritesh]

Are you using DB->Backup Database… option to backup your database? It will only work if SQLyog and the MySQL server are on the same system. To backup a remote database use DB->Export Database As Batch Scripts… option. 😀

[Ritesh]

Are the SQL in form of BULK INSERT STATEMENTS?

[Ritesh]

Currently, SJA requires primary keys to sync two databases.

[Ritesh]

Well we have already started working on SQLyog 3.8 that will have PHP Tunneling. I guess this feature would be seen in SQLyog 3.9 or later.

[Ritesh]

Shadow wrote on Jul 20 2004, 11:07 AM:

Well, not directly, but it can be done. All you need to do is to set up two syncronization sessions. One will sync tA to tB and the other one will sync an empty table to tA (since the source table is empty, none of the rows in tA will have a matching record and therefore each row gets deleted). This method is not too fast as the deletion is done row by row. As an alternative, you may use notification service's maintenance query tool to time the execution of a TRUNCATE TABLE statement.

I would suggest the second method 😀

[Ritesh]

Quote:

Ritesh: Is it possible to put two jobs of different type (a data sync and a notification) into one xml file?

No. 🙁

Quote:

I tried it out and found it impossible to execute a job file containing two different queries successfully. Either only the notification job was executed or the sync job failed saying “Lost connection to MySql server during query” (2013). Sja apparently locates the password needed for connecting to the SOURCE MySql in a syncjob in a wrong way. It seems to locate the first psw node with data regardless of the node's relative position…

Can you explain the problem a little more?

[Ritesh]

Quote:

then automatically delete the rows from tA

Do you mean that you need to TRUNCATE all the data of tA?

[Ritesh]

Currently SQLyog does not provide you with a GUI interface to create Store Procs and Functions. It is in the TO-DO list of SQLyog.

You can very well create the necessary object(s) by executing correct SQL using the Query Window.

[Ritesh]

Quote:

the reference no appear in dialogue box

Which dialog box are you referring?

[Author]

Posts