[peterlaursen]

I just tested with 5.02. I does like attached when running a 'SELECT * FROM a_very_big_table' (@vygi: shut up! <_< ). You must explain what sort of qurey you are doing, I think!

[peterlaursen]

QUOTE

… into a php file that you could run from your php server

What you need is then to generate a PHP statment like

CODE

$goforit = mysql_query('here goes 1st query') or die (mysql_error());

$goforit = mysql_query('here goes 2st query') or die (mysql_error());

etc …

Now if you 'search and replace' the SQL generated by SQLyog in an editor and replace

CODE

;

with

CODE

;') or die (mysql_error());

$goforit = mysql_query('

it will be 95%. You will need to add the connection string and edit first and last statement. But it is a reasonably good idea of yours I think. One more export option: 'export as PHP-script'.

[peterlaursen]

Well .. the 'green arrow' icon becomes a 'red stop' icon while query is running – doesn't it?

Any special sort of query you are talking about ?

[peterlaursen]

Confirmed fixed as of SQLyog 5.1 beta 3.

[peterlaursen]

Quote:

I had tried to go without the escape character, but it kept skipping the “”

It looks like ” … escaped by ''” is default with a load infile staement. Maybe it could vary with different MySQL version.

[peterlaursen]

About CSV import: http://www.webyog.com/faq/28_73_en.html

the is considered an escape character, unless you change it. 'd' simply become 'd'. This is how MySQL Server treats the the escape character. Probably you don't need to use escape characters at all. Or you must use another character.

There is a setting in the dialogue to skip 'n' number of lines.

[peterlaursen]

Quote:

One thing that I have noticed is that it happens with MySQL 4.0.x and not with v4.1.x.

It might as well be PHP versions that make the difference. I happens on MySQL 5.0/PHP 5.1.2 as well (but not exactly the same way as with MySQL 4.0/PHP 4.4.2). I also don't think MySQL 4.1/PHP 4.3.11 is 'free' of this. But it is hard to generate this sort of error (but not totally impossible either, I think) with MySQL 4.1/PHP 4.3.9. But it is hard to remember details! And when I first researched into this there was no less than 4 different issues at the same time. That made it rather confusing. Now there is only this one left. So a systematic approach should be much easier now.

@ritesh: you can have access to my local server with almost any MySQL version and PHP version that you like. It is all installed. I can switch between them in seconds – just need to move a few comment characters in the config files and restart Apache and MySQL!

Quote:

The error should occur everytime

Well, yes. But where will the error be reported if it occurs with 'copy database to other host'. Not in 'messages' tab, I think. In sqlyog.err? Nowhere ?? It looks to me like 'copy database to other host' 'by-passes' the common SQLyog message queue.

I think @nicmar gets this error with the first row of this table. And the tool skips that table completely then. But as there is no 'abort on error' user option here I can't tell for sure. You (@ritesh) know the code. Will the job abort or proceed to next table with this error?

[peterlaursen]

Now it is not reproducable with MySQL command-line:

Code:

Welcome to the MySQL monitor. Commands end with; or g.
Your MySQL connection id is 43 to server version: 5.0.19-nt-max

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> use test;
Database changed
mysql> select * from t1;
Empty set (0.00 sec)

mysql> show variables like '%character%';
+————————–+——————————————————+
| Variable_name | Value |
+————————–+——————————————————+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:programmermysqlMySQL Server 5.0sharecharsets |
+————————–+——————————————————+
8 rows in set (0.00 sec)

mysql> insert into t1 values (1,'æøå');
Query OK, 1 row affected (0.03 sec)

mysql> select * from t1;
+—-+——+
| id | t |
+—-+——+
| 1 | æøå |
+—-+——+
1 row in set (0.00 sec)

Welcome to the MySQL monitor. Commands end with; or g.
Your MySQL connection id is 45 to server version: 5.0.19-nt-max

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> show variables like '%character%';
+————————–+——————————————————+
| Variable_name | Value |
+————————–+——————————————————+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:programmermysqlMySQL Server 5.0sharecharsets |
+————————–+——————————————————+
8 rows in set (0.00 sec)

mysql> Set character_set_connection=latin1;
Query OK, 0 rows affected (0.00 sec)

mysql> Set character_set_client=latin1;
Query OK, 0 rows affected (0.00 sec)

mysql> Set character_set_results=latin1;
Query OK, 0 rows affected (0.00 sec)

mysql> use test;
Database changed

mysql> select * from t1;
+—-+——+
| id | t |
+—-+——+
| 1 | æøå |
+—-+——+
1 row in set (0.00 sec)

Does this not look like an issue with the API ?

[peterlaursen]

However …

No matter if I set Bulk = 0 or = 100.000 in preferences, and no matter if I enable CHUNKS or not, BULKs are not created. Only one row per INSERT statement. (export tool tested).

[peterlaursen]

OK …

Quote:

Buffer overrun detected

there were more reports of this. I don't remember which version.

I think Ritesh should provide you with a debug build ASAP. I think there is such available for 5.02.

[peterlaursen]

BTW:

I think we will see more charset options in the connections manager for the future.

I request a TAB in preferences where users can check which ones should be displayed in connections manager. Most users will only need a few!

[peterlaursen]

That is strange. 5.02 has been out for some months and this was never reported before.

Do you have any Pop-up killers, Ad-killers, script-blockers, firewalls … anything like that ??

Now please try version 5.1 beta 3: http://www.webyog.com/betas/SQLyog51Ent.exe (registered version – you may install it to another folder, registration information will be shared)

No need to spend time with it if if does not occur with this one. This BETA is allready better than 5.02.

Some descriptions of the new features here; http://www.webyog.com/forums/index.php?sho…view=getnewpost

If it is something related to Office 2003, I don't have any chance to test. Could you possibly try killing unneeded background processes one-by-one to see if there is a conflict?

[peterlaursen]

FAQ done:

http://www.webyog.com/faq/24_101_en.html

[peterlaursen]

One more:

http://www.webyog.com/faq/24_101_en.html

[peterlaursen]

this is a Windows issue. Now if you resize it (smaller), close the program and restart it, it should remember the setting. Doesn't it?

This is related to the program icon on the desktop only. You can create a new .lnk by dragging from installation folder. Also right-clicking on that .lnk gives some setting options.

[Author]

Posts