Forum Replies Created
-
AuthorPosts
-
RiteshMemberzzapper wrote on Apr 23 2004, 05:08 PM:So,
Do you NEVER need to refresh after an insert/update??
—
zzapper (vim,cygwin,wiki & zsh)
vim -c “:%s.^.CyrnfrTfcbafbeROenzSZbbyranne.|:%s/[R-T]/ /Ig|:normal ggVGg?”
http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips
No. 😀
You only need to refresh the object browser if you have dropped/created/renamed objects.
RiteshMemberQuote:when dropping / creating it should automatically refresh the object browser.. I notice I always do it manually so…If you are creating/dropping objects using various pop menu options of Object Browser, the object browser is automatically refreshed.
RiteshMemberI suspect this is an issue with the efficiency of the ODBC driver. Have you tried accessing the data thru any other ODBC client like Excel, Access?
RiteshMemberSQLyog is the smallest and fastest GUI to MySQL. We consider Reporting a “non-core” feature – best handled by report writers. We dont want to give any feature just for the sake of listing it in the product catalog. Frankly – do you find Navicat's reporting capabilities usable?
You can have limited reporting capabilities by exporting the resultset as HTML, etc. With the upcoming 3.7 you can also receive the resultset(s) over email. You can also schedule the delivery of email.
RiteshMemberWe are testing compatibility with all versions of MySQL. Please give us some time.
RiteshMemberI think there is an issue with the MySQL ODBC drivers. The most efficient way to transfer data from one MySQL Host to another is by:
1) Open a new connection to the Target DB by selecting File->Connect
2) Select DB -> Copy Database to Different Host CB
RiteshMemberPlease tell me the exact warning message that you get.
RiteshMemberAre you able to import correctly from any other ODBC client like MS Access or Excel. Just wanted to confirm whether the ODBC driver is installed correctly.
RiteshMemberWhich version of MySQL are you trying?
RiteshMemberAre you sure that you are using the same ODBC DSN in both the cases?
RiteshMemberWhich version of SQLyog are you using?
RiteshMemberHello,
SQLyog uses MySQL's standard LOAD DATA LOCAL…. SQL to import data from a CSV file. The warning message is the one returned by MySQL on execution of the statement. For more information about what these messages mean check out http://www.mysql.com/doc/en/LOAD_DATA.html
RiteshMemberSJA 1.1 can only be used to sync data and not structures. To sync structure use Structure Synchronization Tool provided with SQLyog.
The features of SJA (therefore the structure of XML) has changed from 3.6x to 3.7. SQLyog 3.6x has SJA 1.1 and 3.7 has SJA 2.0. The version attribute is just a hint for SJA to be backward compatible.
SJA 1.1 could only be used for syncing data but with SJA 2.0 (available with SQLyog 3.7 BETA and Linux version coming soon) you can send formatted resultsets thru email. In SJA 1.1, you can have only one type of job i.e
Code:With SJA 2.0, you will be having two types of jobs
Code:and
Code:HTH
RiteshMemberYes 😀 SJA can connect to any MySQL server located anywhere in the world.
I think you dont have permission to connect to your MySQL server from your Linux box.
What does sja.log say?
RiteshMemberSJA is only available for Linux and Windows.
-
AuthorPosts