Forum Replies Created
-
AuthorPosts
-
ShadowMember
SQLyog does support most of the new features included in 4.1. Implementing charset support is underway. You may still execute the necessary statements from the SQL window, thus setting charset manually.
ShadowMemberStandard MyISAM tables won't be able to hold so much data, they are limited by OS file size restrictions. You may use merge tables if you want to stck with MyISAM. However, I would suggest you to switch to InnoDB, which may use several files to store a table.
ShadowMemberTry increasing the max_allowed_packet variable.
ShadowMemberSQLyog MAX is going to have a much better history handling, ask for a beta and see it yourself. Any comments will be appreciated!
ShadowMemberCurrently this feature is not supported, but I gather that it is on the to-do list.
ShadowMemberTry setting character_set_connection variable manually from SQL window to a Chinese charset!
ShadowMemberThe newer builds of PHP have trubles to connect to older versions of MySql as well. Even if they did, the returned results would not be in the format expected by SQLyog.
ShadowMemberI belive, there are simpler ways of backing up a db than launching SQLyog via PHP. Actually, I don't even get how you could make use of SQLyog in a shell script either!
ShadowMember😀
ShadowMemberHELP “string functions” or “numeric functions” will do the trick… You can do various category searches, these two were only examples. I tend to refer to this help more and more often!
ShadowMemberIf you have MySql 4.1, then #4 is pretty much solved: just type “HELP
” in the SQL command window and MySql will return a short explanation. ShadowMemberUntil these versions are complete, you could try MySqlAdministrator from MySql. It's a free MySql server management tool which is capable of executing scheduled backups and restores.
ShadowMemberYou may delete all tables in a db by using the truncate database feature of SQLyog.
ShadowMemberReplace the ENGINE keyword with TYPE and the CREATE TABLE statement will work as expected, unless you have some timestamp columns.
Ritesh: SQLyog could detect the versions and do this conversion automatically!
ShadowMemberPerhaps the user is not allowed to connect from another host…
-
AuthorPosts