[webtask]

I prefer to select multiple tables (like files in Windows Explorer) and then click on checkbox to include/exclude all selected tables in/from sql-dump

[webtask]

I know about functionality of root check-boxes. But I have more than 50 tables and I need to dump only 30 of them, so I must uncheck 20 tables one-by-one.

[webtask]

navyashree.r wrote on Mar 26 2008, 09:27 AM:

Hi,

1. Resizable of SQL dump dialog box, you can expect this in next beta where the size of the dialog box will be increased.

2. Select/deselect several tables, regarding this issue you can click on table's root node checkbox.

Regards,

Navya

Thank you for #1

#2 Does it mean a possibility to select/deselect ALL tables only?

[webtask]

I tried to do simple test under MySQL 5.0.37 – all queries works without errors. Under 4.1.7 – I got an error. Probably, it is realy server-side problem.

Example data:

Code:

* Insert example data. File encoding is Windows-1251
*
*/

/*
CREATE TABLE `cyr` (
`ROWID` int(10) unsigned NOT NULL auto_increment,
`TITLE` text,
PRIMARY KEY (`ROWID`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
*/

if (($db = mysql_connect('HOST', 'USER', 'PASSWORD')) !== false) {
mysql_select_db('DATABASE');
mysql_query('set names cp1251'); // all data is sending to server is in Windows-1251 !!!
$query = “insert into `cyr`(`ROWID`,`TITLE`) values (1,'Мама'),(2,'мыла'),(3,'раму'),(4,'азбука'),(5,'One'),(6,'Two'),(7,'Three')”;
mysql_query($query); // that's all
echo 'OK';
} else {
echo 'Was not connected!';
}

?>

id = 1,2,3,4 – are cyrillic titles

All the same, I think all problems may solve custom SET NAMES command, but this way is deprecated in SQLYog 6.

[webtask]

MySQL Server 4.1.7

[webtask]

When I do not use set names cp1251 it is possible to view table data, but not possible to use queries which selects rows with 'like' statement and international characters. And for those queries I MUST use cp1251. And in this case results are unreadable but they exists!

I know that server transforms encodings, but I suppose that SQLYog not convert data from sql-editor to utf8 and send it as is.

When there is only international characters in the query – everything ok, but when I want to select 'cyrillc' data and use or or calculate 'cyrillic' values in the field list <(case when D='cyrillic' then 1 else 0 end)> – query fails.

[webtask]

Oops.

I solved this problem by converting sqlyog.ini to UTF8. 🙂

[webtask]

Thank you, I read it.

[webtask]

peterlaursen wrote on Nov 28 2006, 11:39 AM:

1) the issue with 'empty database' is confirmed. It is related to 'autocomplete'. 'drop database' and 'truncate database' are not affected.

We will release 5.21 beta1 with a fix for this in a few days.

2) However we cannot reproduce the slow import.

Can you tell what 'Remote connection' means? HTTP??

If so that could depend on the server load then.

Can you reproduce with both versions installed at the same time?

(import with 5.19 … measure time .. drop database .. measure time)

I mean “running” sql-script, not “import”. My sql-script consists over 70 “create table” operators. SQLYog successfully connected to remote MySQL server (not to localhost). When I run script – SQLYog not freezes, but execution goes extremely slow.

[webtask]

BETA7 works ! Thank you!

[webtask]

Ritesh wrote on Apr 5 2006, 11:28 AM:

By any chance are you using SSH connection?

No

[webtask]

Oh, I'm sorry, I thought about uninstalling process and clear install again, but wrote about upgrading. But if Personal Folder store important examples of quieries, do not delete this folder anyway so user can use own sources. I think when SQLyog is uninstalling it is enough to notificate user about Personal Folder is not deleted.

[webtask]

Well done! RC1 show non-enlish characters properly

[webtask]

I'll try

[webtask]

Hmmm. But SQLyog 4.1 works fine with fonts and font charsets…

[Author]

Posts