Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberTunneling can be configured in two easy steps.
1) Upload SQLyogTunnel.php ( found in the MySQL installation folder ) to your web server using any FTP client.
2) Type the complete URL to SQLyogTunnel.php in the HTTP Tunneling URL input field.
This is still in BETA and the help file is not fully updated. The release version would have complete documentation on setting up HTTP/SSH Tunneling.
We are still not frozen the commercials and licensing policies.
Ritesh
MemberCurrently, SJA requires a PRIMARY KEY to sync table(s).
If you dont have a PRIMARY KEY then the best solution would be to just add an auto_incremenet column to the table.
Ritesh
MemberSQLyog supports table level comments. To specify COMMENTS for a table, click on Advanced Properties… button.
HTH
Ritesh
MemberCurrently, SQLyog dosnt support syncing of FK in Structure Sync Tool.
This featured is planned for one of the future releases of SQLyog.
Ritesh
MemberThis feature is planned for SQLyog Max.
Ritesh
MemberThis is a known bug and has already been fixed in SQLyog 4.0 😀 Would you like to be notified when the 4.0 BETA comes out?
Ritesh
MemberPlease upgrade to 3.71 as SQLyog 3.6x uses an old MySQL client library :huh:
Ritesh
MemberOne of the possible solutions that comes to my mind:
1) Start using MySQL instead of Access at the client-end.
2) Schedule a “Data Sync Job” using SQLyog. As required, SQLyog will only update the changed rows during the sync process. You can do away with exporting data to CSV, etc.
If you still need to use the “front-end” features of Access, use Access to make an ODBC connection to MySQL.
Ritesh
MemberCan you mail me the XML schema that you are using?
Ritesh
MemberYou can use SQLyog's Structure Sync Tool (Tools -> Structure Synchronization Tool) to generate the correct ALTER TABLE statements.
However, what you require is a schedulable Structure Sync Tool. Currently, you cannot schedule Structure Sync Tool. We may add it in one of the future versions of SQLyog.
Ritesh
MemberAs of SQLyog 3.71, we dont monitor size of bulk insert statements. You have to unselect BULK INSERT STATEMENT option, if the query is going beyond the limit.
This is a good feature request and I have added it up in our TO-DO list.
Thanks for your request.
Ritesh
MemberCurrently, SQLyog does not support importing of indexes and foreign keys in its ODBC Import Tool. You have to create them using SQLyog's Index Manager (Table -> Manage Indexes) and Relationship Manager (Table -> Manage Relationships) after importing the data.
Importing of Indexes and Relationships are planned for SQLyog 4.1
Ritesh
MemberPlease upgrade to SQLyog 3.71. This bug has been fixed in SQLyog versions starting from 3.7 🙂
Ritesh
MemberWhich version of SQLyog are your using?
Ritesh
MemberSelect the table in the ObjectBrowser.
Select Table -> Import Table Data From CVS… . Enter the filename and the correct escaping sequences and press Import. Thats it 🙂
-
AuthorPosts