Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 7,398 total)
  • Author
    Posts
  • in reply to: #26331
    peterlaursen
    Participant

    We 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!

    in reply to: #26329
    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.

    in reply to: #26328
    peterlaursen
    Participant

    1)

    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 1

    HTTP 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.

    in reply to: #26313
    peterlaursen
    Participant

    I 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.

    in reply to: #26325
    peterlaursen
    Participant

    1) 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.

    in reply to: #26311
    peterlaursen
    Participant

    Paypal (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.

    in reply to: #26323
    peterlaursen
    Participant

    I 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:

    http://webyog.com/faq/content/27/114/en/in…agent_-sja.html

    http://webyog.com/faq/content/15/47/en/is-…or-windows.html

    in reply to: #26309
    peterlaursen
    Participant

    Silly mistake. Sorry for this. It was cnfigured to start April 10th – and today is 9th. Now corrected. Please try again!

    in reply to: #26303
    peterlaursen
    Participant

    It 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.

    in reply to: #26300
    peterlaursen
    Participant

    It 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

    in reply to: #26283
    peterlaursen
    Participant

    ok

    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.

    in reply to: #26297
    peterlaursen
    Participant

    this 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.

    in reply to: #26299
    peterlaursen
    Participant

    We 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:

    http://webyog.com/faq/category/25/sqlyog-job-agent-sja.html

    http://webyog.com/faq/category/11/mysql-da…ronization.html

    in reply to: #26281
    peterlaursen
    Participant

    changelog: 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.

    in reply to: #25546
    peterlaursen
    Participant

    correction: 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.

Viewing 15 posts - 3,016 through 3,030 (of 7,398 total)