Forum Replies Created
-
AuthorPosts
-
Shadow
MemberSQLyog 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.
Shadow
MemberStandard 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.
Shadow
MemberTry increasing the max_allowed_packet variable.
Shadow
MemberSQLyog MAX is going to have a much better history handling, ask for a beta and see it yourself. Any comments will be appreciated!
Shadow
MemberCurrently this feature is not supported, but I gather that it is on the to-do list.
Shadow
MemberTry setting character_set_connection variable manually from SQL window to a Chinese charset!
Shadow
MemberThe 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.
Shadow
MemberI 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!
Shadow
Member😀
Shadow
MemberHELP “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!
Shadow
MemberIf 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. Shadow
MemberUntil 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.
Shadow
MemberYou may delete all tables in a db by using the truncate database feature of SQLyog.
Shadow
MemberReplace 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!
Shadow
MemberPerhaps the user is not allowed to connect from another host…
-
AuthorPosts