Forum Replies Created
-
AuthorPosts
-
peterlaursen
Participantadditional comments/questions:
1) It would be easy to verify this by executing “create table `database`.`table` … ;” from command line. Did you?
2) One thing that is known to break circular replication is that if you have auto_increment columns you must use the 'auto_increment_increment' construction to avoid PK collisions.
3) Please tell server versions and more details about this setup. Any particular 'recipe' or 'guidelines' that were followed?
peterlaursen
ParticipantIs that link correct? I do not think I find such rule/advice on that page (except for the user comment at the bottom).
Could you elaborate?
Actually we have a replication setup between this server (webyog.com – Master) and a server at our office in Bangalore (Slave).
I frequently do manipulations on Master with SQLyog as well as a PHP script (an internal maintenance routine we have developed for ourselves). That never broke replication as far as I know! Most of those are inserts/updates but also create's have occurred.
Do you think it is a problem due to the circular replication pattern, or is it 'create table' statement and other specific statements only where this is a problem?
What does 'break replication' mean? Does replication gets completely disabled or is it this particular statement only that fails to replicate?
I will not exclude anything! But it would be a problem with thousands of 'standard applications' too, if this is correct!
… and there is no way to configure this. This is all compiled into the program.
peterlaursen
ParticipantWe do not support 'FIND in GRIDs' yet. 'find' refers to the editor.
We have this in our 'wishlist' here
http://code.google.com/p/sqlyog/issues/detail?id=468
I use the term 'wishlist' and not 'TODO' because this is not yet scheduled.
peterlaursen
Participantgofree wrote on Mar 11 2008, 02:00 PM:Seems to me that connecting from local computer to remote database on most ISP is almost impossible though they claim that they allow remote access to mysql database. So SQLYog can only connect to database in the server not remote ISP?Edit: Name server here meant DNS that you configure for your domain???
If they mean that you can access with a web-based interface like phpMyAdmin then it is definitely not 'remote access'.
You will have to use tunnelling then!
peterlaursen
Participantwhat we are doing with different MySQL version is explained here
peterlaursen
ParticipantTimeframe estimate for 6.2 beta1 is 1-2 weeks.
peterlaursen
Participant“Error Code: 2006 – MySQL server has gone away”
This error happens because the .SQL file contains BULK inserts larger than what the max_allowed_packet setting in server configuration allows for (the default setting for max_allowed_packet is 1M only with recent server versions).
Insert this line
Code:max_allowed_packet = 100Min the [mysqld] section of the mysql configuration file (my.ini/my.cnf) and restart the server. Now this error won't occur again with this dump.
If you are not in control of configuration of this particular server you can import to another (like local) server and transfer data using 'copy to other ..' or 'data sync'.
peterlaursen
ParticipantQuote:PS! I never said the connection settings ….. and I never said you said!
My points were that
1) if low wait_timeout is the reason for 'gone away' message then at least on 5.0 you should be able to avoid it by SETting the variable locally after connection. If it is not this setting that causes this can you describe how to reproduce this? Is this problem with every server? Sure that it is not the connection from/to your local machine that has 'holes'?
2) Also does the lack of engines in 'CREATE TABLE .. advanced' occur with all your servers? For me it works with every version I have (from 3.23.58 to 6.04).
peterlaursen
Participant1)
In SQLyog tools .. show .. variables or query “show variables like 'wait_timeout';” (server 4.1-) or “show global variables like 'wait_timeout';” (server 5.0+) will give the server wait_timeout setting.
But for 5.x servers you may change that after connection (if that has not been blcok too (what I doubt, because that would be a 'dirty hack' of the server)).
Just execute “set local wait_timeout = 28800;” (28800 is the server default setting is nothing else is specified in configuration).
After that “show local variables like 'wait_timeout';” to ensure that it has taken effect!
ISP's often set it low becuase a lot of users may have scripts and programs that do not do mysqlclose() properly. Only after timeout the connection thread is killed then!
2)
As regards the missing Engines in ALTER TABLE ..advanced please tell: What is the server version?
It may be a configuration issue on you host (file system privilege issue or some mistake when upgrading the server) or some issue with SQLyog and specific server versions.
But moving the dropdown to another GUI dialogue will not retrieve the list and not solve anything. This is not hard-coded into SQLyog – the list of available engines is retrieved from the server (we need to because of MySQL pluggable storage engine architure – maybe you even wrote a 'fredlund' engine for your server. We cannot tell in advance what engines are available with a server, but the server itself will tell if only you know how to ask)!
peterlaursen
ParticipantOK … 1st issue again.
Maybe we do some kind of SHOW query from ALTER TABLE that are not piped through the reconnect wrapper. That was the problem with DATA TAB before 6.16 too. We know that there are still some corners of the program where we will have to go through this.
Can you confirm that 'wait_timeout' setting is low on that server?
peterlaursen
Participant1) We do reconnect.
However a GUI bug was fixed in 6.16. Did you upgrade?
Also with SSH it is not complete. But that is fixed in 6.2 tree
Also what are your server 'max_allowed_packet' and 'wait_timeout' settings? If the ALTER TABLE statement is longer than 'max_allowed_packet' the server will drop the connection. We may reconnect 1000 times with no use because the server will still drop the connection every time before execution! But maybe not likely that a ALTER TABLE statement is longer than the default 1M setting! So reason is probably another.
If you get that very often you should consider fixing the server or the connection – whatever the reason is!
2)
Please be more specific than 'something like'.
A tabbed interface for every connection you are requesting?
I think we first discussed this more than 2 years ago! Get us a few dozens more paying customers per week requesting this …
It is not low priority to improve the overall interface, but there are lots of pending issues with higher priority!
3)
“When im creating a new table i do not get the chance to choose storage engine on its first creation. I have to go to advanced table properties after a succesful creation” wrong. You can go directly to 'advanced properties' before creating!
[attachment=848:notempty.jpg]
“but the engine list is empty”. For me it is not empty. Click the arrow and the options available will display. But by default SQLyog does not specify the engine and the server will use the server default engine. If this is not the case for you please attach screenshot, tell program verson etc.
peterlaursen
ParticipantImport succesfull here with both SQLyog 6.16 and command line “source” statement.
Local server 5.0.51a.
[attachment=846:success.jpg] [attachment=847:somedata.jpg]
Do you have another file on your system that your system could mess up with this one?
The server gets the SQL statement that it should create Information_Schema!
I suspect it is an issue with Windows Explorer on your system. Do you have an option to try another?
One (silly maybe) idea: Try copy to another folder and rename! Maybe that is enough!
peterlaursen
ParticipantNo because I did not see it untill now!
I was sitting up were late last night waiting for it actually!
I propose yoy create a new post insted of editing an old one. We get notified with new posts but not edits!
I am downloading now!
peterlaursen
ParticipantIt is your choice if you want it public or private!
peterlaursen
Participantyes – a 90 Mb file is a little of a problem! Do you have somewhere to upload it?
If so please do and post the link (you may create a ticket here http://www.webyog.com/support if you do not what to expose it in public)
We will need to find out if this error occurs at the server side or the client (SQLyog) side!
Do you have an option to try source-statement with command line client?
-
AuthorPosts