Forum Replies Created
-
AuthorPosts
-
Shadow
MemberWell, 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.
Shadow
MemberConfirmed in 3.71.
Shadow
MemberActually, I don't use foreign key restrictions too much, I use application logic instead.
Shadow
MemberYeah, 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…
Shadow
MemberGrendel: 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.
Shadow
MemberRitesh said he would offer MAX at a discount price to current users.
Shadow
MemberSQLyog 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.
Shadow
MemberAs 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.
Shadow
Member😀
Shadow
MemberSQLyog 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?
Shadow
MemberDo 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?
Shadow
Member??????? 😮
BTW, how is your beta test proceeding?
Shadow
MemberExecute a SELECT query to get the desired data, then right click on the results and choose copy data to clipboard.
Shadow
MemberAt 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