[peterlaursen]

I am using latest 5.14 RC

.. but I do no know if there are server settings that may influence this behaviour?

[peterlaursen]

Not reproducable here with latest RC!

1: Open two connections to two different MySQL servers

>> did that

2: Start some heavy query like “SELECT * FROM large_table ORDER BY unindexed_field LIMIT 10;”

>> yes

3: Kill this query from another client –> SQLyog reports lost connection

>> no — SQLyog creates a new connection/new thread!

The 'other client' that I use is another SQLyog instance. I Killed the proces with ID = 7 (the thread that the 'long' query uses) . First SQLyog instance creates a new thread with ID = 8 (first number available) and continues the query from there.

4: Now switch SQLyog to another server without doing anything on the 1st

>> yup!

5: Select some table and try to copy it to the 1st server via “Copy Table To Different Host/DB…” –> SQLyog reports “Error 1146: Table xxxxx doesn't Exist”

>> no, copy succesfull!

6: Confirm error popup with “OK” and try to do same operation (click on “Copy”) again –> SQLyog CRASHES WITH NO MESSAGES!

> No crash here

(7): my addition:

The 'long' query finishes OK after 1-2 minutes.

@Ritesh,

Tested with my chess database (more than 4 mio. games).

It has now finished uploading to /Betas directory

The query: “SELECT * FROM Game ORDER BY dateflags LIMIT 10;” (there is no index on 'dateflags')

[peterlaursen]

to change the server parameters, you will have to edit the MySQL configuration file(my.ini/mycnf) and restart MySQL. The progam 'MySQL Administartor' from http://dev.mysql.com is a GUI program (primarily) for editing the configuration file,

[peterlaursen]

Coul you try latest 5.14 RC build. Quite a lot tunnelling issues are fixed.

[peterlaursen]

The red cross simply does not show up in this situation.

Maybe the order-of-statements in the code?

First show read cross .. next send query ?

[peterlaursen]

@nicmar

you should first of all upgrade SQLyog!

[peterlaursen]

Confirmed fixed with latest RC build.

Now a proper HTTP-error is displayed.

[peterlaursen]

Well .. I can here!

Are you using a recent version (I think i remember there was such issue L-O-N-G time ago …) ?

If there is some problem with latest version (se announcement or 5.14 RC at the top!) then please explain in detail:

1) What does the table look like at the start. (screenshot or dump)

2) What are you doing EXACTLY … words .. screenshots .. flash movie 😆

3) And what happens (or not)?

Always if possible give a 'reproducable test case'. Actually at bugs.mysql.com the don't even consider reports without such 'reproducable test case'. They are closed automatically after 30 days! We are (sometimes) a little more flexible here. …

But as said I can easily ALTER TABLE and SET DEFAULTs in 'one shot'. So please explain yourself better! And try a recent build first if you did not.

[peterlaursen]

I think the problem is that the is no 'total SQL file' for a DATA sync job. When the tool starts at one end it does not 'know' what comes after. To implement your request we would need to enable a 'simulation mode', where it does not execute commands, but writes to a file instead.

I don't know how useful it is. It is individual INSERTS, UPDATES and DELETES for each row where an operation needs to be performed. It may be thousands of individual statements. And I do not know either how (human) readable it will be. It is the WHERE clause that is the problem. Probably Ritesh can be more specific.

Do you think that you can use that information? I'd rather say it is better to backup data before sync'ing. You can run a backup and a sync as a single batch job.

But let us hear Ritesh …

[peterlaursen]

OK .. thanks for the link. Now I understand what software we are talking about.

Well, if you installed the MySQL 4.1 that is linked to (http://dev.mysql.com/downloads/mysql/4.1.html) then you have it. And connection parameters are the same no matter which client you use.

1) But is the MySQL server running? It does not look like it! Do you see a process in task manager named 'mysql'.exe?

2) Try starting MySQL from command line like 'Net Start MySQL'. What does ist say?

3) Do you have the folder 'c:program filesmysqlmysql server 4.1' ? And is there a 'my.ini' file in there?

BTW: You may also find the program 'MySQL Administrator' from http://dev.mysql.com useful.

[peterlaursen]

Quote:

“the server in my pc named L2J lineage 2 java”

Is this a MySQL server?

I have googled with 'lineage 2 java' and looks like it is some java-based game server.

If not a MySQL server you cannot connect with SQLyog.

[peterlaursen]

Please only ask the question once!

the FAQs

http://www.webyog.com/faq/23_15_en.html

http://www.webyog.com/faq/16_66_en.html

http://www.webyog.com/faq/16_67_en.html

Look to me as if there is no MySQL server runnning on your local machine?

Where is the server that you try to connect to?

[peterlaursen]

yes, I have understood!

[peterlaursen]

1)

I cannot explain why the table does not show up in the dropdown.

And not the READ ERROR either. But I understand that this READ ERROR occurs when SQLyog tries to read from MySQL.

If it shall be possible for me to work on it I must have a dump of the database structure and a sample CSV-file like yours (could be with 'dummy' data).

I suggest that you try importing into an empty database. Table will be created. You can 'map' from the tool (preferred) or you can ALTER TABLE after import.

But I still would like to see if I can reproduce this READ ERROR. Can you dump the database structure?

2)

The header line is 'practical' because then the driver and the tool will by itself proposes to import into columns named identically to the names in the header and you won't have to type anything.

How did you generate the .CSV's? From what sort of program? Some programs have that option. MS-Excel does for instance.

If you do not have the header line you will need to type the name of each column name. And if you have more files to import into one file it probably will be fastest to create import of a single file with the wizard and add table no. 2+3 etc. by editing the jobfile (it is basically just a 'block' of lines that must be dublicated.

[peterlaursen]

1)

Did you check program help .. keyboard shortcuts:

Ctrl+B Set Focus On Object Browser

Ctrl+E Set Focus On SQL Window

Ctrl+R Set Focus On Result Window (focusses on the last selected TA:cool:

to switch RESULT/NMESSAGES/DATA/OBJECTS/HISTORY tabs use

Alt+1…n Select Nth Tab In Result Window

2)

I do not think I understand?! closes the BLOB-viewer here.

[Author]

Posts