Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberCan you attach a screenshot of the BACKUP dialog with the error message?
I guess you are selecting some options for which you dont have privileges….
Ritesh
MemberGOTCHA !!!!
I will release RC8 sometime tomorrow, that will have this bug fixed.
THANK YOU !!!
Ritesh
MemberI will work on it.
Ritesh
Membersja.log is created in the current directory of sja.exe ( if you are running Sync tool thru SQLyog, it will be in the same directory ).
sja.log is nowhere related to the last used directory.
Delete sja.log from the Installation directory of SQLyog and run the Sync tool. You will see that sja.log was created in the same directory.
Ritesh
MemberThis feature is in the TO-DO list of SQLyog.
Ritesh
MemberQuote:What is the purpose of that screen I showed in the video? Should it result in the same results?The option that is shown in video brings STRUCTURES of two databases in SYNC with each other and not DATA. The Tools menu specifies them as –
- Database Synchronization Wizard
- Schema Synchronization Tool
respectively.
Ritesh
MemberWent thru the video. Even the .sql file given by you tells that the structure are same.
Running, SJA on the tables results in correct output as shown above. I belive there should not be any problem.
Can you cut/paste the information that is given by Sync Wizard at the last page. I am attaching a snapshot of my last page after I ran the sync tool on the tables provided by you.
BTW, if the data is not very sensitive can you send me a backup of the data so that I can try out the sync tool on it?
Ritesh
MemberQuote:Also, can you please give me a heads up on the truncating problem?The reason remains the same. We have still not released the RC that has this problem fixed. It was reported by your earlier and we have fixed it in the next upcoming release.
BTW, sja.log is created in the installation directory. I am attaching a snapshot of my SQLyog directory. Your directory should have the files shown in the image.
Ritesh
MemberCan you upload a video capture of the steps you are following?
Ritesh
MemberQuote:Should it detect the difference between the two tables?Yes 🙂
Can you cut/paste the messages out here? What does sja.log says?
Ritesh
MemberGreetings
I restored the given database in my server and ran the sync tool. Everything seems to be fine. Here is the output –
Code:SQLyog Job Agent Version 1.0
Copyright (c) Webyog. All Rights Reserved.Sync started at Fri Oct 10 06:36:07 2003
Table            SrcRows  TgtRows  Inserted  Updated  Deleted
========================= Â ======= Â ======= Â ======== Â ======= Â =======
`points_allowed` Â Â Â Â Â Â Â Â 0 Â Â Â Â 0 Â Â Â Â 0 Â Â Â Â 0 Â Â Â Â 0Total time taken – 0 sec(s)
Ritesh
MemberCan you cut/paste your output here?
A video file will be even better?
Ritesh
MemberThe SQL file lists only the structures of one database. Can you send me the backup script of the both the databases as it is in your server. We can restore it on our server and run a sync on both the databases.
Quote:If I perform an export table as batch script and then perform a second export, the file is overwritten. I am not prompted to rename the file as was stated earlier in the post.The RC that has this feature has not been released. We are waiting for your Sync bug report before we release our next RC.
HTH
Ritesh
MemberQuote:My situation is this: I have a hosted MySQL database with a table containing weborders, I want to be able to extract the days orders at two intervals in the day lets say 11.00am and 2.00pm and update a local db with only those records.The upcoming version of SQLyog i.e. SQLyog 3.6 provides you a Wizard based interface to sync data. This is zillion times easier than writing a PHP/Perl script. Morever, this process can be scheduled. You can download a Release Candidate of SQLyog 3.6 from http://www.webyog.com/sqlyog/SQLyog36.exe. I am waiting for your comments 🙂
Quote:Also I then need to write each order out as individual text files.This feature is planned for future release of SQLyog.
Ritesh
MemberThe Export Dialog.. will ask for confirmation before overwriting any file 🙂 ( Thats not a bug actually, it was by design )
Waiting for the SQL scripts 😀
-
AuthorPosts