Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantWe have PLESK on this (webyog.com) server too and it works fine.
Did you notice that we have added an option to specify the HTML contenttype in last version?
I quote from the help file:
Quote:The content-type option was added in 6.5. Most users will not not need to care about this as they most often will all work, but in some situations a special HTTP format is required. Known situations are:With Apache and mod_security extension enabled in Apache configuration it may be necessary to use 'urlencode'
With IIS running on Windows Server 2003 some PHP editions will fail to connect with 'urlencode' setting.
Open source webservers (like Apache, Lightttpd) may have been built with some code change (or 'hack') blocking certain HTML content-types.
Please try the different options. I think 'urlencode' may be required for you!
peterlaursen
Participant“I have a need to migrate the program from my desktop to my notebook”. How did you? Did you install it?
Anyway .. please check the URL. One posibility is that a LAN-ip or a 'name server alias' is used on the old machine that is not available for your Laptop.
peterlaursen
Participant1)
no – you will not need to remove. The instance on the Laptop has no 'knowledge' about where else it is installed.
2)
it does not prompt for registration details. It rememebers you. Well .. what is the problem then?
But did you use some kine of 'clone'/ program to migrate you old system settings to the new Laptop? (like Windows 'transfer settings' utility)?
3)
the PROBLEM is I think this
Quote:Error No 1HTTP Error: Could not connect to tunneling URL.
This is *not at all* related to registration issues. Are you sure that the URL is correct? First verify that *exactly the same details* work from the old computer. Also try connecting to the tunneller in a browser. You may copy the sqlyog.ini file from the old computer – that will migrate all settings including connections.
peterlaursen
ParticipantI just checked this morning. We did not get your order processed yet.
We will discuss what we can do. Please be patient for yet a few hours.
peterlaursen
Participant1) SJA can be executed on one of the hosts where either of the databases reside. Actually it may also be executed on a third machine. It uses no files on any machine except where it is executed.
2) Can you execute it manually from a console? Does it do what you want? First verify this. If not there is no idea in creating a CRONjob!
3) As regards defining a CRONjob I am helpless without a (KDE, GNOME etc.) GUI interface or some AdminPanel (like PLESK etc). One of our Linux specialists will reply to that tomorrow – if not some user is faster.
peterlaursen
ParticipantPaypal (from outside US in particular) can take up to a few hours. I am not sure about the reason for this, but we experience this from time to time.
We can't really do anything except for checking the status in the morning.
peterlaursen
ParticipantI do not understand the question.
'SJA for Linux' is for *linux* – non-linux unix (BSD's, Solaris, OS-X etc. are not supported).
On linux it will execute from any folder if only you have execute privilege.
Please explain more in detail .. where do you want to specify? But basically you specify the folder name 'as it is'.
did you read FAQs here: http://webyog.com/faq/category/25/sqlyog-job-agent-sja.html
.. in particular:
peterlaursen
ParticipantSilly mistake. Sorry for this. It was cnfigured to start April 10th – and today is 9th. Now corrected. Please try again!
peterlaursen
ParticipantIt will not be possible to view changes while sync is running. It will mostly happen so fast that you would be able to read it!
But we do plan an option to run data sync with logging of all statemens executed and possibly also to run in some 'virtual mode' so that logging is the only thing that happens.
peterlaursen
ParticipantIt is not SQLyog that does! It is the server that does!
The server identifies the host from where you connect. If there is no 'user'@'yourhost' or 'user@'%' defined you cannot authenticate % is the SQL wildcard meaning 'from anywhere'.
The complete communication betwen a client and the server when connecton is established is a 'ping-pong' of several initial tests normally referred to as a 'handshake'. In the proces of this 'handshake' the ip or URL of the client is identified. Refer to: http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Note that 'oneuser'@'onehost' and 'oneuser@'otherhost' are *totally differenet* users just ' as 'oneuser'@onehost' and 'otheruser'@'onehost' are. Refer to: http://dev.mysql.com/doc/refman/5.0/en/use…management.html
peterlaursen
Participantok
Use the
option if you can define a subset of columns (in addition to the PK) you are sure is unique. A single column used for a UNIQUE key is obvious to use. Also you may exclude BLOBs. Often rows are unique without them. If you have an 'on update' timestamp in the table you also know a time that can be used with
(it is where timestamp > last_sync_time). The is executed against ordinary data. It is nothing internal. peterlaursen
Participantthis will be solved in the same context as other grid issues pending. We will not 'push' this with priority.
We have started a new code trunk (that will probably end up as SQLyog 7.x). Here it will come.
peterlaursen
ParticipantWe do not issue any explicit LOCK. The server may do this internally shortly for every chunk of data we are syncing. This is not different what what happens when two client are trying to accessing the same table. Sometimes one client will have to wait. This is no problem – we are not talking about seconds but much less.
While data sync is other clients may read/insert/update both before and after where the 'data sync cursor' is pointing. Those inserted before will not be synced by current job – those inserted after will.
SJA for Linux has same data sync code. You get it from our downloads page. Also refer to out FAQ:
peterlaursen
Participantchangelog: http://www.webyog.com/faq/content/33/7/en/…on-history.html
As regards data sync: when syncing to an empty databases you will get this speed improvement only.
peterlaursen
Participantcorrection: we only use scintilla in the editor. But problem is basically still the same: to dientify the characterlength of a utf8 string (and not the byte length) without destroying performance. I think we have an idea about it now. But it requires some testing.
Today was Holiday for most Webyoggers.
-
AuthorPosts