[Aparna]

Hi,

There was an issue with the double quote character(because of which it used to not display correctly on few systems)and it has been corrected now. It should display fine with our next release. Thank you for reporting this issue to us.

[Aparna]

Hi,

We tried reproducing this issue at our end but it works just fine for us. In order to investigate this further would it be possible to send the “my.cnf” files of both your master as well as the slave servers? Sensitive information such as the password and other log in details can be removed. If it is OK to send these two log files then please attach them and mail them to [email protected]. This creates a private ticket which only our team and you can view.

Thank you!

[Aparna]

Hi,

You said you have a master slave set up right? Could you please give us the exact server versions of both your slave as well as the master. We will try and set up a similar environment here. And also tell us the operating system that you have the set up on.

Thank you!

[Aparna]

Quote:

Is it Shift-F5 or Shift-F9

This depends on the options in the preferences that reads “Switch F9 and F5 functionality”. If this option is checked then shift+F5 will execute all queries instead of Shift+F9. This option is present in tools menu->preferences->others tab. On opening this you can push F1(which opens the help file) for more details.

Quote:

In snooping around I HAVE found the output from the second query under another “Result” tab. So I checked the documentation. Huh! Doesn't tell me that is where I should have found it!

When you have loaded multiple queries in the editor please push F1 and it is mentioned that “Each query would create a new tab for its resultset in the Result Window”.

Please see the attached screen shot for the preferences option. Thank you!

[Aparna]

Hi,

Could you please check in the MySQL.ini file if the 'binlog_ignore' statement is being used and inform us about the same? Thanks!

[Aparna]

Hi,

We have released SQLyog 9.0 GA. The version information bug that you have reported has been fixed.

Thank you.

[Aparna]

Hi,

We have released SQLyog 9.0 GA with this fix.

Please refer to:

http://www.webyog.com/blog/2011/04/13/sqlyog-mysql-gui-9-0-released/

Thank you.

[Aparna]

Hi,

The sample data that you have provided imports absolutely fine without having to change the data type to Varchar. Can you please tell us how you connect to MySQL(Direct/HTTP/SSH) and your MySQL version? In order to find the version of MySQL that you are using please execute

SELECT VERSION();. If it is either SSH or direct connection then goto the table menu and try the option IMPORT CSV DATA USING LOAD LOCAL option to import the CSV file. Can you create a job file using import external data and send it to us(Sensitive information like the MySQL connection details can be removed from the job file). Also request you to send the CSV file in order to replicate and understand the issue at our end. If the data is confidential you can create a support ticket by mailing us at [email protected]

Thanks and Regards,

Aparna.

[Aparna]

Hi Scott,

Post 8.6 we have improved the number of tables that can be populated and handled in the GRID of Import External Data but, it certainly matters where your source server is. While populating the GRID not only is the visual selection involved in the operation but also some background processing that requires time. In order to save time you can save a job file consisting of the tables you want to Import and run them as and when required.

Regards,

Aparna.

[Aparna]

Hi,

As i understand you are trying to check and un-check the tables from the Import External Data wizard and the application freezes for about 15 minutes(correct me if i am wrong). Can you please tell me the version of SQLyog that you are using? This issue is fixed in 8.6 and the versions above that. Kindly upgrade and check if that solves your problem. If not please post the exact steps to replicate the issue you are facing.

Regards,

Aparna.

[Aparna]

Quote:

Does SQLyog currently have any way to show stats for tables and databases?

Yes SQLyog does have an option to display the row count, data size and index size of all the tables present in a database. Select the tables folder and then click on the info tab(see the attached screen shot). This gives you the details of the number of tables/columns present(depending on whether the selection is on the table folder or the table itself), the number of rows, data size and index size. You can get details related to the table in info tab HTML mode as well text mode (which offers more detailed information). SQLyog is a MySQL front end and a database management tool.

If you want graphical and detailed representation of information regarding database then you can try MONyog the MySQL monitoring tool. Here is the link to try the trial version of MONyog:http://www.webyog.com/en/downloads.php#monyog

[Aparna]

Quote:

when the error is ignored – is it recorded in the logs so that we could analyze it later?

Yes. In spite of the errors being ignored while importing, the errors will be logged in the sja.log and you can look into it later. You can get back to us if you need further assistance or have more doubts.

Thanks and Regards,

Aparna.

[Aparna]

Hi,

Request you to do the following.

Create a table in MSSQL with decimal(18,0) as the data type and enter 0.4 and 0.5 as values in it. Save the table, re-open the table and please confirm if you see 0.4 and 0.5 in the table as you had entered earlier.

Thanks and Regards,

Aparna.

[Aparna]

Hi,

Quote:

It imported it, the decimal columns and all, it just didn't import the right data. In most fields it imported for instance 0.0000 instead of the 0.40 that was there

The data type you have used is decimal(18,0) where the “18” stands for the Precision value and “0” stands for the scale value. Scale value indicates the number of digits that can be stored after the decimal point (to the right side of the decimal point). Since you have given the scale value as “0” it does not store any values after the decimal point. So in you case the values that are below 0.5 get rounded off to the previous closest integer which is 0 and the values ranging from 0.5 to 0.9 get rounded off to the next closest integer that is 1. Please read this link for more information on scale and Precision: http://msdn.microsoft.com/en-us/library/ms187746%28v=SQL.90%29.aspx

After entering the values in the decimal(18,0) field and saving it, request you to re-check the values to be sure that the values are stored just as you have entered them. (in your case make sure 0.4 gets stored as 0.4 itself in decimal(18,0) after saving it)

With the right precision and scale value SQLyog imports data successfully. (You can make use of the above link to determine the appropriate precision and scale values for your data)

Quote:

This needs to be an all over filter, not a table per table that I have to enter since there are over 600 tables to import

There is no over all mapping option(Is that what you are referring to as filter?). Please correct me if I have misunderstood.

Thanks and regards,

Aparna.

[Aparna]

Hi,

You could try the following options to get the create table statement in SQLyog:

1. If you are interested in just viewing/copying the create table statement then select that particular table and click on the info tab. This will display the create table statement for you. If you want to copy it then select the option that reads text/detailed and copy the statement into the editor.

2. If you want to duplicate the table then there is an easier option to do so. All you have to do is right click on the table, select more table operations and then select duplicate table structure/data . Once you select this, the duplicate table window will pop up. You have options to duplicate both the structure of the table and the structure and data as well. Please see the attached screen shots that will help you understand both the steps better.

For alter table you can do the following as a work around.

Right Click on the table and select alter table option/ Push F6 on the table. The alter table window will pop up. Alter the field that you want to and then click on preview option. You will be able to see the alter query and also you can copy and paste it into the editor.

Please see the attached screen shot.(In the sample screen shot provided the data type of the Field name UpdateDate is modified to VARCHAR(50). After modifying and clicking the preview option you can see the alter query. Please see the screen shot alter_query )

Please get back to us if you have further queries.

Thanks and Regards,

Aparna.

[Author]

Posts