[peterlaursen]

There is no dump attached!

 

It can be a little tricky to add files here.  First you must select and upload, next “attach to post”.

[peterlaursen]

The automatic reconnection is not handled by our code but by setting the “reconnect flag” in the MySQL API (of what we use the version from MariaDB and not from Oracle).

 

Links:  

https://dev.mysql.com/doc/refman/5.6/en/auto-reconnect.html

https://mariadb.com/kb/en/mariadb/mariadb-client-library-for-c-api-functions/

 

 

So if this is reproducible, it looks like a bug in the API or MariaDB’s version of same.  We will check and report to MariaDB, if it is reproducible for us.

[peterlaursen]

We really cannot comment on why the “configuration” was lost in your case. 

 

But it is a good idea to include the file C:Users{user}AppDataRoamingSQLyogconnrestore (I think this is the file you refer to as “configuration”) in a routine backup plan (just in case) if you use ‘session restore’ – and in particular if you don’t backup each tab to separate files. 

[peterlaursen]

In ‘preferences’ there is an option to turn off backquotes. There is no option to turn off brackets.

[peterlaursen]

Pleae check this FAQ: http://faq.webyog.com/content/23/15/en/error-no-2003-can_t-connect.html

 

The difference as compared with phpMyAdmin is that with SQLyog you connect from a remote host, with phpMyAdmin from localhost. So please try HTTP tunnel with SQLyog – refer http://sqlyogkb.webyog.com/article/155-connecting-using-http-tunneling.

[peterlaursen]

Did you try to specify database(s) in the connection settings/connection manager?  

[peterlaursen]

.. but our documentation at http://monyogkb.webyog.com/article/17-linux-installation should deal with use of the “zypper” command. yast/yast2 are deprecated as commands and yast is now only the name of various interfaces for system management on SuSE.

 

I never installed MONyog from neither yast/yast2 nor zypper commands. They will check for dependencies in the software repositories registered on the system. MONyog has no dependencies and SuSE’s repositories don’t know MONyog. I simply always right-clicked the RPM and chose “install package” (this will bypass dependency checks, but with MONyog it is OK as there is no need to perform a dependency check)

[peterlaursen]

Do you have a GUI desktop? If so please go to YaST .. “Service Management” interface and see the status of MONyog there (and if it shows up there at all).

 

 

On my OpenSuse 12.3 it is like this:

 

[attachment=2044:service.jpg]

 

 

[peterlaursen]

hmmmm .. one idea and a few more questions

 

1) Try lowering CHUNKS and/or BULKS. Refer http://faq.webyog.com/content/24/101/en/about-chunks-and-bulks.html. Note that the setting in ‘preferences’ has no effect for ‘scheduled backup’. The settings are in the wizard – please see image [attachment=2043:chunkbulk.jpg].

 

2) Can you view the table in SQLyog “Data” tab?

 

3) Is it a very big table?

 

 

 

If 1) does not help. I think you will have to contact your hosting support for help with this. There may be some permissions issue or some setting on this server allowing only small amounts of data to be processed per query.

[peterlaursen]

I don’t know why it was closed. It should not have been. I have re-opened it now. 

 

There is no planned activity as regarding this at the moment. We are doing some minor things now what will likely take around 6 weeks. At least for that period there will not be either.

[peterlaursen]

This request is basically the same as here, I think? 

https://github.com/webyog/sqlyog-community/issues/1526

[peterlaursen]

This happens with HTTP tunnel, I think? 

 

Anyway, if you have SUPER privilege then try to SHOW FULL PROCESSLIST and kill threads having been idle for very long time (or restart MySQL would also terminate any locks, it this is the problem).

[peterlaursen]

No.

[peterlaursen]

Looks strange. 

 

It could be a network issue. In particular if one machine is connected with cabled ethernet and another with Wifi.

 

Try to temporarily disable firewall, AV and wha t other ‘secrity software’ you have in order to check if this is related. 

[peterlaursen]

[attachment=2042:database.jpg]

 

You just do in the connections setting.. ‘MySQL’ tab. it will be enforced in the MySQL protocol – not in PHP.  Please see image.

 

 

 

So create one connection for yourself in SQLyog and another for your brother.

[Author]

Posts