[ashwin]

Follow these steps to attach files here:

1) Click on “Add Reply”. (“Fast reply” option does not have an option to attach files)

2) Below the editor there is an Attachment section.

3) Here, click on browse to select the required file.

4) Now click on “Attach This File”.

[ashwin]

Hello,

1)

Quote:

allow to customize our own keyboard shortcuts

We already have this request in our issue-tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1409

2)

Quote:

Remember the last opened .sql file, so we don't have to keep opening it manually each time the program is started.

Noted here: http://code.google.com/p/sqlyog/issues/detail?id=954

3)

Quote:

Would like to be able to customize the toolbar so I can put frequently used commands there and remove commands that are rarely or never used.

I have added the request here: http://code.google.com/p/sqlyog/issues/detail?id=1744

Currently our developers are busy for atleast 2-3 weeks. We will schedule these according to priority.

Thanks for using SQLyog.

Regards,

Ashwin A

[ashwin]

Hi Mitch,

Issue confirmed. We have added this in our issue-tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1743 We will schedule this according to priority.

Regards,

Ashwin A

[ashwin]

We are checking this.

[ashwin]

Hello,

Can you please tell your MySQL version(SELECT VERSION()), SQLyog version(Help->About) and connection method(Direct/HTTP/SSH)?

Attach the screenshot of the program window when you get the error. Also, attach the MySQL configuration file (my.ini/my.cnf). You can also create a support ticket by mailing us to [email protected].

Regards,

Ashwin A

[ashwin]

Hi,

Quote:

Whenever I initially connect I get the success window, but strangely, the MySQL version is blank. No biggie.

Can you please tell your SQLyog version and MySQL version(SELECT VERSION())?

Quote:

If I do not specific a specific database when logging in I see the correct number of databases, but none of them have any names or labels. If I log in with the database names specified, I see those, but the table names have no names/labels.

We are not able to reproduce this. Can you please try uploading the SQLyogTunnel.php again and check whether it is working fine or not?

If it is not working properly then please tell:

— Can you connect to the tunneler URL from a browser? If so attach the screen-shot.

— Attach your SQLyogTunnel.php(From the folder where you have copied to)

— Tell your web server(Apache/IIS etc)

— Can send us the phpinfo() page?

If you don't want to disclose the above information in a public forum, kindly create a support ticket by sending a mail to [email protected].

Regards,

Ashwin A

[ashwin]

Hello,

Quote:

SQLyog only warns with a message box “[…]unless one or more USE statements[…]” when you want to import a SQL script into a database. I think it would be nice when SQLyog actually scanned the file for such statements and only if present would give that warning.

SQLyog has to parse the sql file looking for a USE statement and as you told- “On the downside, it could take some time to scan a big sql dump, so perhaps make it configurable.” So the only option left is to add an option in Preferences. But it is not a helpful option to make it configurable. So it is not going to be in our priority list.

Thanks for your comments.

Regards,

Ashwin A

[ashwin]

Hello,

This is a server error and not an error with SQLyog.

Please try the following:

1) Stop MySQL server.

2) empty the /tmp folder (The file '/tmp/#sql_1acc_0.MYI' is a temporary file created by MySQL with a random file name. If such file exists already creation of new file will fail. So try emptying the TEMP folder.)

3) restart MySQL server.

Refer MySQL documentation: http://dev.mysql.com/doc/refman/5.5/en/cannot-create.html

Regards,

Ashwin A

[ashwin]

Issue is confirmed. This will be fixed and included in the next public release. Thanks for reporting this to us.

[ashwin]

Hello,

Can you please tell your MySQL server version(SELECT VERSION())? If you are using server version less than 5.1.49 then you will be hitting this server bug: http://bugs.mysql.com/bug.php?id=52711

This is the bug fix in server 5.1.49:

– Security Fix: Using EXPLAIN with queries of the form SELECT … UNION … ORDER BY (SELECT … WHERE …) could cause a server crash. (Bug #52711, CVE-2010-3682)

Refer: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-49.html

When you executed in command line you did not encounter “Lost Connection To Mysql Server During Query” because EXPLAIN SELECT was not included in the query. If the Profiler is ON and when you run the query, EXPLAIN SELECT is executed.

You can verify this by including EXPLAIN SELECT query in command line 🙂 .

Regards,

Ashwin A

[ashwin]

Hello,

Quote:

I tried to edit the values of scanline_setup in the result tab and it won't let me. I switched to Form view and the field is not editable. Is there something I'm missing?

As you are having two tables in resultset, Result tab will contain a combo-box that allows you to choose table to edit. This table columns are highlighted and all other columns are grayed. Please refer attached screen-shot.

Regards,

Ashwin A

[ashwin]

Hello,

Quote:

The problem is that some of my fields contain data with “, e.g. The place of the meeting is at “Plaza hotel”. This “corrupts” the data and the fields are not shown as they should be. Is there a way I can fix this?

When using a “”” inside a string the enclosed character(Escaped by) must be specified as “””(Double quote) itself. Please refer MySQL documentation: http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html#character-escape-sequences

Regards,

Ashwin A

[ashwin]

Issue confirmed and fixed. It will be available in the next public release. Thanks for reporting this to us.

[ashwin]

Hello,

Quote:

ERROR: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysRelationships'.

The “MSysRelationship” is an Access system table. It must be readable for SQLyog to migrate Access 'relationships' to MySQL 'Foreign Keys'. By default, read access to the system tables of an Access database is restricted for external applications.

Please refer the link: http://www.webyog.com/en/whitepapers/Preparing_Access__Migration.pdf

Regards,

Ashwin A

[ashwin]

Hello,

Quote:

In a language setup of those other than English, it does not operate.

A Copy Database/Table　Function

result message id 1090

We have released SQLyog 9.31 with this bug fix.

Please refer to:

http://www.webyog.com/blog/2011/11/07/sqlyog-mysql-gui-9-31-released/

Regards,

Ashwin A

[Author]

Posts