Forum Replies Created
-
AuthorPosts
-
ShadowMember
Well, those connection should not fail…
This feature has already been requested, and – unless I'm not pretty much mistaken – will be included in the MAX release.
ShadowMemberConfirmed in 3.71.
ShadowMemberActually, I don't use foreign key restrictions too much, I use application logic instead.
ShadowMemberYeah, that's a good idea! In our db there is a table containing log entries which must not change, only new entries may be appanded. As this table is pretty large, its sync takes a ehile. Such feature could considerably reduce the overhead of the sync in this case…
ShadowMemberGrendel: Do a little search next time before asking, please! You get this message if no MySql server is running on the specified host listening to the given port.
ShadowMemberRitesh said he would offer MAX at a discount price to current users.
ShadowMemberSQLyog calls the export file CSV even if the field separator is not comma. Try exporting to CSV format with comma set as separator and then it should work as expected.
ShadowMemberAs of now, Windows does not differentiate between cases in file names meaning that “filename.frm” and “FileName.frm” names yield to the same file. Currently MySql databases are “stored” as folders and tables as files (even when InnoDB is used!), so naming is affected by how the OS stores their names. This is why you have only lowercased db and table names on Windows.
Besides, there is a setting in MySql called lower_case_table_names. On Windows this value defaults to 1 (true). If this value is set to this value, then your table names will be always in lower case regardless of you OS.
ShadowMember😀
ShadowMemberSQLyog does not change the MySql host address you enter in any way. Apparently you are new to MySql because MySql host address and the host name appended to the username are two entirely different things.
MySql host address is the name or IP address of the machine where MySql server runs. While the host name in the MySql username identifies the computer you are connecting from! SQLyog uses standard MySql client dll to connect to the server, so the problem is not with SQLyog.
Can you log in via command line utility?
ShadowMemberDo you have to edit the content of a HTML page directly in the db? There must be better tools for that…
I guess SQLyog uses standard MS components that are based on CR LF and not just LF. Perhaps, this could be set in the preferences as well, right Ritesh?
ShadowMember??????? 😮
BTW, how is your beta test proceeding?
ShadowMemberExecute a SELECT query to get the desired data, then right click on the results and choose copy data to clipboard.
ShadowMemberAt first, make sure that you are allowed to connect from a remote host, at all! PHPMyAdmin runs locally that's why it connects without any problem. Most ISPs do not like granting direct remote access for security reasons.
-
AuthorPosts