Forum Replies Created
-
AuthorPosts
-
RiteshMember
Hmmmmmmmmmm….
Thanks for the information 😀
RiteshMemberQuote:I had a sql script that had 2 create scripts. When I hit F-5, it only ran the first one… ? Is this correct?Yes 😀 To execute both the scripts, use Shift+F5
Quote:is it possible to add refresh to the right click of the database menu without having to go to the parent connection and refresh the whole tree?You can refresh the tree by pressing F9
HTH
RiteshMemberError 1045 means that you dont have correct permission to connect to the MySQL server.
Ask your MySQL Host to provide you with correct permission to connect remotely.
RiteshMemberWell…Its very difficult to point you anything?
I believe, that the best place to start will be the MySQL Help files :huh:
RiteshMemberSeems, you do not have correct permission to connect to the MySQL server.
RiteshMemberQuote:so, is this SQLyog open source?No 🙁
Quote:OR there is a way or option to let the column show the data? Hmn… let me know!use Ctrl+L
RiteshMemberQuote:Instead of grant all what specific grants we can give for normal users?You can provide specific permissions like Select, Update, Insert, Delete, Create, Drop, Grant, References, Index, Alter for a DB to a user 😀
HTH
RiteshMemberWhy do people confuse SQLyog with Webyog?
Webyog is the company name and SQLyog the product…..
Anyway, great to know that people are using SQLyog 😀
RiteshMemberUse Ctrl+L to switch from grid-mode to text-mode and vice-versa. You can then copy,search,etc.
RiteshMemberHmmmmmmm…..Thanks for the information.
Quote:I've noticed a few small glitches here and thereWaiting for the list 🙄
RiteshMemberThanks for your information. We will work on it.
RiteshMemberHello
Try this line in the [mysqld] section of your my.cnf
set-variable = max_allowed_packet=16M
We store around 3-4MB of binary data in BLOB fields without any problem 🙂
RiteshMemberQuote:I'm guessing that I will need some ODBC driversYou need MS SQL Server's ODBC driver installed in your computer.
Create a DSN to the MS SQL Server's DB using Control Panel -> ODBC Datasources.
Then you can use SQLyog's ODBC Import Wizard to Import data to MySQL. A tutorial on how to Import Data from ODBC Datasources to MySQL using SQLyog can be found at Devshed.com
Hope it helps.
RiteshMemberQuote:The only way to refresh seems to be to disconnect and reconnect to server.You can refresh the Object Browser by pressing F9
RiteshMemberQuote:load a database file to my database server.If you have your database backup in SQL scripts ( created using MySQLDump etc. ), then you can use Tools->Execute Batch Scripts… option to execute your queries from the file. The file can be of any size ( limited by OS ).
-
AuthorPosts