[peterlaursen]

I asked you to show line 60 of your script (take lines 55-65 for instance). I also asked with what tool/program this dump was created.

[peterlaursen]

You may also execute “SHOW VARIABLES LIKE ‘warning_count’;” after the import. (refer https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_warning_count).

 

The purpose of all this is to check how many warnings the server records and sends.  

[peterlaursen]

Have you tried simply to execute “SHOW WARNINGS;” from the editor after import?  Does this also truncate?  

[peterlaursen]

You posted the same in the “SQLyog” category (the right place), and I replied there.

[peterlaursen]

Then let’s see line 60 of the file (paste lines from around 50-70). Also tell how the SQL dump was created – with what tool/program? 

[peterlaursen]

I don’t think this Forums is relevant place to post this. 

 

You can mail to [email protected] and we will forward to our HA team.

[peterlaursen]

I don’t understand the term “priority” in this context.  

 

Anyway did you read the documentation at the Query Builder? 

[peterlaursen]

If you don’t want to share in public (what I don’t think you should), you can mail to [email protected].

[peterlaursen]

Did you check your spam/junk folders for the mail?

[peterlaursen]

Also such reports without exact version information is really not usable at all. Actually if your SQyog versions are not 12.12 please upgrade. There were some issues in early 12.0 versions caused by introduction of the ‘session restore’ feature.

[peterlaursen]

Let us summarize the requests you posted last month into one trhead.  I think this covers the most important (for you) things (feel free to add):

 

 

• Customizable keyboard shortcuts. SQLyog has been lacking in the shortcuts department for quite some time. If you don’t like one of the default key binding, tough luck—you are stuck with it.

   

• Pref to specify the folder for favorites. By default, favorites live in AppdataroamingSQLyog. This makes them easy to lose if you change computers. It would be great to be able to specify the folder. 

   

• Autocomplete for MariaDB functions. MariaDB has new functions, such as regexp_replace(). It would be nice if the editor recognized them.

   

• Ability to hide the icon bar. Hiding it would save real estate.

   

• More server information. Apart from Status and Variables, it would be nice to be able to see command statistics and processes, like in HeidiSQL. 

   

• Where’s the manual? The manual has been removed from the software with a brief explanation about chm files—which to me sounded like a weak excuse as chm help files work great in my other programs. Worse, there’s no online manual. Instead, there’s a knowledge base search that never seems to find the information I need. I understand cost-cutting, but for users the loss of the manual is a big step backwards. 

[peterlaursen]

Was Windows restarted in between? 

[peterlaursen]

You may simply install and register the program again. You will also have access to download again from our Customer Portal (we do recommed however taht userskeep a safe backup of installers and registration details). Information about our Customer Portal  will be shipped along with download links and registraton details after purchase. 

[peterlaursen]

Can you please contact [email protected].  We will not discuss registration logic etc. in public.

[peterlaursen]

You will probably need to JOIN tables to achieve this. Refer MySQL documentation on this https://dev.mysql.com/doc/refman/5.6/en/join.html.

 

SQLyog Query Builder fully supports JOINs. Refer http://sqlyogkb.webyog.com/category/185-query-builder.

[Author]

Posts