Forum Replies Created
-
AuthorPosts
-
Shadow
MemberI forgot to ask if you run the fix privileges script!
MemberBy using the mysql client program located in the MySql root/bin directory. Do you try to connect with the same user from SQLyog and the other programs? If yes, then does this user have a password?
MemberThe support for the newly available permissions in MySql 4.x and 5.x are planned for SQLyog Max. See the corresponding topic.
MemberCan you login from command prompt?
By the way, which version of SQLyog and MySql are you running?
MemberBetter foreign key support is planned for SQLyog Max.
MemberIt could be a feature request: SQLyog should watch out for such columns and do a silent column type change or could ask the user what to do. Of course, SQLyog should pay attention to the size of the field and do the conversion accordingly (tinyblob, blob…).
TEXT and BLOB fields are essentially the same in MySQL…
MemberYou may remove the length (xxx) from the definition, just leave the BLOB.
MemberRitesh, it's the same problem I have already reported. For some reason SQLyog attempts to create FULLTEXT indices in the temporary table regardless of the field and table type. In this particular example: InnoDB table type does not support FULLTEXT indices at all and the sample_id field is of smallint type…
This bug should be corrected!
MemberQuote:Yog is a Sanskrit work which means work with dedication . Thats what we stand for work with dedication to create GREAT PRODUCTS(definition by Ritesh)
MemberGotcha! This topic has already dealt with this issue. Unfortunately, it was inconclusive.
Ritesh, you should look at this problem carefully and see if SQLyog can be bended to handle these situations!
MemberWell, this explains a lot…
QUOTE [11:59:50][ 47 ms] describe `e-verglas.com`.`biblio` Notice the '.' in the db name: `e-verglas.com`.`biblio`. Now, that is not allowed in MySql. It's got nothing to do with SQLyog, your ISP broke the rules laid out by MySql… I can't really explain, why PHPMyAdmin works fine given the circumstances. As if there had been a topic about this issue in this forum… Perhaps, PHPMyAdmin does not issue context commands all the time. You should contact your ISP and ask them to correct the problem!
P.s.: issue a SELECT VERSION(); command from SQLyog, Tools -> Show -> Variables -> Version to obtain the version of the connected MySql server.
MemberI thought it was not going to be that simple…
We'll need additional info to be able to help you out. What version of SQLyog and MySql are you running? Could you reproduce the errors a few times more and paste/send the corresponding entries from the history pane to this topic?
MemberYou should check the “Optionally” option at “Fields enclosed by” because the numeric fields are not enclosed by “-character.
n = new line (Unix style line break)
rn = CR LF (Win style line break)
t = tab (not sure, though…)
MemberYou obviously use a character that is not allowed in table names ('.', '/'). Perhaps you put the`-characters at wrong places, e.g. select * `mydb.mytable` => incorrect table name (1103). It should be select * from `mytdb`.`mytable`.
MemberTools -> Database Synchronization Wizard
Choose “Edit a Saved Synchronization Session”, pick the xml file created by the wizard, and select all tables you need, then save the modified xml. That's it.
-
AuthorPosts
