Forum Replies Created
-
AuthorPosts
-
Shadow
MemberUse SHOW WARNINGS command to get more info. In this case, however, I belive MySql only returns the number of warnings, but no additional data is recorded.
Shadow
MemberDidn't have time to test it. Perhaps this weekend! 🙁
Shadow
MemberBeta 5 does not crash on W2K with IE6 SP1.
Shadow
MemberIt's an XML data file and not a schema file. Starts like
… Shadow
Member@peterlaursen: Yes, that was a question for you! Of course, a db structure may not be completely altered by an automatic tool, but in simpler cases it might come handy. I know the limits of ALTER TABLE statements, especially in older versions of MySql, that is why I asked what you had in your mind. Though you had an alternative approach…
Shadow
MemberYou mean, a tool that creates alter table statements instead of completely dropping and then recreating a table?
Shadow
MemberIf I understood your problem properly, then the answer is – unfortunately – no, data sync wizard is not suitable for your needs.
First of all, data sync wizard works only if the synced tables' structures are identical. SQLyog has a structure sync wizard, but that cannot be scheduled and needs manual intervention anyhow. Secondly, data sync wizard cannot sync data using complex queries including joins. All you can do is to specify a WHERE clause. Data sync wizard, however, will be further developed. You could participate in testing SQLyog MAX and try to convince Ritesh to incorporate the features you require.
Shadow
MemberThat's a good idea! 😀
Shadow
MemberIf there are such rows in the target db that are not present in the source db and you chose to perform a one-way sync, then sja deletes these extra rows.
Shadow
MemberWorks correctly with MySql 4.1.3 on W2K.
Shadow
MemberConsidering MySql's silent column changes, a CHAR(100) column is highly interesting!
Shadow
MemberThis might explain terrym's problem as well.
Shadow
MemberI figured that out by starting SQLyog…
Shadow
MemberSorry once again, SJA bundled with 4.0 beta may use HTTP tunneling.
So, if your ISP does not allow direct connection from remote hosts, then you have to copy SQLyogTunnel.php to ISP's server and use tunneling features in the connection.
Shadow
MemberAre you sure that your PK field is of integer type? Isn't it accidentally a signed tinyint? The error message may be caused by overflow…
-
AuthorPosts