Forum Replies Created
-
AuthorPosts
-
CalEvans
Membernl ???
=C=
MemberIf it's not your url (machinename.yourdomain.whatever) then I would ask your ISP's support dept.
=C=
MemberIF your ISP is (smart enough to be) running Linux then you can probably get them to let you setup an ssh tunnel.
http://www.vandyke.com has a program (ssh tunnel?) that does just this. You don't need a shell account, just a login and password.
I use SecureCRT (you can use PuTTY for free) do tunnel all the time.
Once I have the connection made and the tunnel working, I fire up SQLyog and create a connection. The host is localhost, the port is whatever port I've assigned it to. (I have more than one and they can be open at the same time so I use unique ports on each tunnel) and voila! I have a secure connection to my server, through my firewalls.
It's a bit more complex than that and I'm happy to help you if this will work. Let me know.
=C=
MemberWhat is the exact error message you get?
When you get the error, does it tell you what server it is trying to connect to? If so, is that the correct server? (localhost is usually not the correct server)
Have you checked to make sure that either 3306 is open on your winproxy or that it allows all outgoing connections? Yes, this could be the problem. You get around it by opening 3306, if this is the issue.
More information is needed before more help can be given.
=C=
MemberWithout any additional information to go on I would say that it sounds like you local instance of mysql is not running.
=C=
MemberIANAP,
But I believe I remember talking with Ritesh about similar UI issues and I THINK I remember him talking about the next major version would be multi-threaded. This would solve the problem of the UI being unresponsive.
However, in the short term, use a where clause to limit the number of records in your result set. (1k records is a huge result set for SQL) This will solve your problem with the sorting because it will take fewer resources to process. An extreme solution would be to add more RAM as SQLYog is obviously having to swap to disk a lot.
Finally, use an order by clause on your query and let the server do all the work. This is by far the best answer.
HTH,
=C=
MemberWhen you say
Quote:I can log in using telnetDO you mean you can connect directly to the mysql server via telnet or that you can telnet into the server and then connect to mysql using the command line interface?
If the later then your ISP needs to change your host in the mysql.users table to %. Chances are that it's localhost now which is why you can telnet in and then connect.
HTH,
=C=
MemberNot sure if it will help but the only time this happens to me is when I'm trying to edit a recordset and not a table. Does it happen to you if you click on the table name on the tree control on the left and then press CTRL+ENTER? Is it a derived table?
HTH,
=C=
MemberPersonally, I'd do it in PHP.
Open the email, suck the contents into mySQL, do the calculation dance, send it back out. http://www.zend.com has about a dozen or so email controls that make sending emails easier.
HTH,
=C=
MemberSure it is.
Just highlight them all and press F5.
HTH,
=C=
MemberThis is a known issue with MySQL.
=C=
MemberTHANK YOU!
That's been driving me up the wall on single chr fields! 🙂
=C=
Memberobviously corrected in the current version, mine says http://www.webyog.com
=C=
MemberContact your ISP. They should be able to give you the 3 things you need.
1: machine name or ip address
2: login
3: password
Optional 4th piece, the database you are allowed to use. (Not necessary if you are allowed to see all the databases.
=C=
MemberAsk your sysadmin to list your permissions for you. This IS a permissions problem. (BTW, being a SYSADMIN myself, I hate it when users ask questions like this so be polite but persistent.)
As a test (and to kill time waiting for his reply) try this:
On your Windows server, try backing up one of your databases to another one locally on that same server. If it works, try it again.
I know it's a permissions issue but I'm unclear as to which server is giving you the error. It looks like the remote but if the above test fails then the problem could be with your local server. (but I don't think it is)
When you get the answer form your SYSADMIN then post it here.
BTW, I think the UPDATE thing is a separate issue. If you can use the SQLyog dialog to do the update then you can also use the command window. (They are connected as the same user and issuing the same command.) As a test, check the history tab after doing an update via the dialog. It should list the commands issued. copy and paste them into the command windows and press the almighty F5 and see if it works.
HTH,
=C=
-
AuthorPosts
