[peterlaursen]

It might be an issue with php configuration.

From my own php configuration file I quote these settings:

Quote:

max_execution_time = 30    ; Maximum execution time of each script, in seconds

max_input_time = 60 ; Maximum amount of time each script may spend parsing request data

memory_limit = 8M      ; Maximum amount of memory a script may consume (8M:cool:

And my experience is that the “cheaper” ISP's are not generous with that!

[peterlaursen]

Did you click the refresh-icon. (the recycler-symbol) ?

[peterlaursen]

Quote:

but I get an error or I can't access the data.

When do you people learn to tell WHAT error you get! 😀

But I think it is likely that you did not unlock/unhide the metadata tables as described here: http://www.webyog.com/whitepaper/Preparing…__Migration.pdf

… that is a special thing about Access that the metadata tables are hidden. SQLyog needs acces to those tables if metadata (indexes etc) shall be imported. But it is of course only a guess of mine, that that is it!

Also read this article of mine:

http://www.databasejournal.com/features/my…p/10897_3550146

If you still are not able to solve the problem then we will need some info about your settings (screenshots, XML-file etc.)

[peterlaursen]

Quite funny that I wrote this just a few days ago:

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

Quote:

a lookup of 127.0.0.1 wil give localhost.localdomain

I believe it is the other way around! a lookup of localhost.localdomain will give 127.0.0.1!

Why do you have “127.0.0.1 localhost.localdomain” in your hosts file when “127.0.0.1 localhost” will normally do? There need not be a “localhost” (actually it is often replaced with “build” on test servers) but there will always be a 127.0.0.1 when there is a TCP-protocol.

But I agree that we have a hosts resolving issue here!

[peterlaursen]

Quote:

but suddenly it stops

Yes! I've heard about similar issues with wireless too. Actually I don't think it is the connection to MySQL the stops. Because then SQLyog would (try to) reconnect. I is somewhere else in the chain. You have no problems with wireless and other types of connections ?

Probably ot is a wireless TCP error. And you can't reconnect then. But can you after a while ? or what do you do actually … ?

I don't queite understand where it is wireles!

client ssh .. wireless .. server ssh … mysql

or

client .. some server host …server host running wireless ssh client .. server ssh .. mysql

and where is the firewall(s) in that ?

Well, yes. A “save all tabs”/”emergency save” would be nice in this situation. When SQLyog opens it should then open what was “emergency saved”.

[peterlaursen]

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

It must in this case be the reconnection from the SSH-server to the MySQL-server that fails. SQLyog reconnects to the SSH server OK.

Don't have the solution. Wireless and SSH …

[peterlaursen]

@chrisryder

and you are willing to PAY for that? How much then?

And this

Quote:

but without tunneling on the linux agent this product is of absolutely no use.

I don't understand. You can sync two unixserver from a client running on windows.

MySQL has replication. Yes but you can't use unless the two servers are your own. In a “shared environment” such as an ISP you will have to find some other way!

[peterlaursen]

……hmmmmmm

I have 3 comments.

1) That would burden the client with those calculations. So concat_ws() on the server side should continue to be used when ever possible.

2) Charset and collation implementations with various MySQL versions would have to be solved too. A table definition of 5.0 and 4.0 are NEVER identical – at least charset definitions differ. I am in doubt whether it can me done in a safe way. English-speaking people (like you?) always forget that there is more than one charset and more than 25 characteres!

3) There are some data type incompabilities. For instance: how to handle a varchar(1000) in a 5.0 database when syncing with a 4.0 database?

Low priority in my opinion. Unicode issues and localization is much more important.

[peterlaursen]

Quote:

This SQLyog issue must be fixed sooner or later. “Strict mode” will become more popular for sure as this is an ANSI SQL standard.

I agree! It is not only Stored Procedures, Views etc. that are new with MySQL 5. That is the spectacular stuff. But there a dozens of small and “medium” novelties. And a general trend in direction of “Standard-SQL”. And BTW – the first MySQL 5.1 alpha is just round the corner with more new stuff, more user privileges, new controls, Foreign Keys (and possible some kind of transactions) with MyISAM etc.

To those that can afford: Buy a few dozens of site licenses today for SQLyog so that they can speed up development!

I use basically three MySQL-clients: SQLyog, Administrator and OpenOffice (for formatted reports and printing). And I use each and everyone of them practically every day. No client has everything.

[peterlaursen]

SELECT @@sql_mode

return an empty set here! What also SQLyog tells (se pic)

Where did you get your my.ini from? Generated by the wizard?

Honestly I don't remember the exact history of mine but it was originally shipped with an early 5 version. And edited quite a lot. At that time I got it 'strict mode' was not standard with the shipped templates.

But we agree that inserting nothing in a NOT NULL column w/o a default will raise an error. And that explains.

Actually this quote is a little bit better I think:

Quote:

If you are not using strict mode MySQL inserts adjusted values for invalid or missing values and produces warnings.

And I can add that when I create a user and issue “show warnings;” just after I get these warnings:

Quote:

Level      Code  Message                                         

---

 

---

 

---

Warning    1364  Field 'ssl_cipher' doesn't have a default value 

Warning    1364  Field 'x509_issuer' doesn't have a default value

Warning    1364  Field 'x509_subject' doesn't have a default value

Actually I have proposed before that the connectiosn manager should have a tab for thes SQL_MODES (strict, ANSI etc). Because actually any client can impose its own SQL_mode setting no matter what is the server default!

First sentence from your mysql-docs go

Quote:

The MySQL server can operate in different SQL modes, and (as of MySQL 4.1) can apply these modes differentially for different clients.

. So if we were able to turn of 'strict mdoe with the connection, then we could create users with SQLyog even if strict mode is server default. It is somewhat a 'hack' I know, but Rome wasn't built in one day.

[peterlaursen]

I reproduced with some simple data of my own:

Code:

CREATE TABLE `tn2` (
 `id` bigint(20) NOT NULL auto_increment,
 `t` varchar(20) default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `tn2` */

insert into `tn2` values (1,'ggg');
insert into `tn2` values (2,'fffff');
insert into `tn2` values (3,'   eee');

and get

Code:

Sync started at Mon Oct 10 13:17:08 2005

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`tn2`                            3        2         1        0        1  

Total time taken – 8 sec(s)

when using HTTP-tunnel on both MySQL 4.1 and 5.0. The row is first inserted and then deleted! Does not happen with direct connection.

The tunneller can't handle leading blanks!

But I have no problems that query runs forever!

[peterlaursen]

However after executing this SQL

Code:

update testtest set name = trim(leading LEFT(name,1) from name) where LEFT(name,1) = ' ';

(1 row affected) 😀

EDIT: there is a much easier use of the TRIM() function when it is a blank character that must be removed! I forgot. But this code of mine will test for and remove ANY leading character.

you get

Code:

Sync started at Mon Oct 10 11:49:05 2005

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`testtest`                       2        1         1        0        0  

Total time taken – 3 sec(s)

and the data in the tables are identical, and charsets different as originally.

You could be a little bit more specific than just writing “Can you duplicate the problem?” WHAT IS YOUR PROBLEM (except for your charset and other localization issues of course 😀 )

[peterlaursen]

Code:

Sync started at Mon Oct 10 11:31:14 2005

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`testtest`                       2        1         1        0        1  

Total time taken – 6 sec(s)

MySQL 4.1 (on localhost over a dyndns backloop)> MySQL 4.0 (on another computer on local network). Both http-tunnelled. php is 5.1 RC.

[peterlaursen]

The create statement for the mysql.user table says here

Code:

CREATE TABLE `user` (                                                                        
         `Host` char(60) collate utf8_bin NOT NULL default '',                                      
         `User` char(16) collate utf8_bin NOT NULL default '',                                      
         `Password` char(41) collate utf8_bin NOT NULL default '',                                  
         `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                        
         `Reload_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `Shutdown_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                    
         `Process_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `File_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                        
         `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                        
         `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                  
         `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                        
         `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                        
         `Show_db_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `Super_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                        
         `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N',            
         `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                  
         `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                      
         `Repl_slave_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                  
         `Repl_client_priv` enum('N','Y') character set utf8 NOT NULL default 'N',                  
         `Create_view_priv` enum('N','Y') collate utf8_bin NOT NULL default 'N',                    
         `Show_view_priv` enum('N','Y') collate utf8_bin NOT NULL default 'N',                      
         `Create_routine_priv` enum('N','Y') collate utf8_bin NOT NULL default 'N',                
         `Alter_routine_priv` enum('N','Y') collate utf8_bin NOT NULL default 'N',                  
         `Create_user_priv` enum('N','Y') collate utf8_bin NOT NULL default 'N',                    
         `ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL default '',      
         `ssl_cipher` blob NOT NULL,                                                                
         `x509_issuer` blob NOT NULL,                                                              
         `x509_subject` blob NOT NULL,                                                              
         `max_questions` int(11) unsigned NOT NULL default '0',                                    
         `max_updates` int(11) unsigned NOT NULL default '0',                                      
         `max_connections` int(11) unsigned NOT NULL default '0',                                  
         `max_user_connections` int(11) unsigned NOT NULL default '0',                              
         PRIMARY KEY  (`Host`,`User`)                                                              
       ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'

Note: `ssl_cipher` blob NOT NULL, no mention of default! Actually I don't believe a BLOB can have a default at all! and I have two MySQL version 5 installations. One “fresh” and one about 3 years old that started as a 4.0 database. And I can ceate users with SQLyog 4.2 beta5 on both.

1) How is the definition of `ssl_cipher` on your system.

2) Does your statement from history pane look like mine:

insert into mysql.user ( host, user, password, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv ) values ( '%', 'test', PASSWORD('*******'), 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N' )

/*[10:47:59][ 110 ms]*/

Note here that there is no value inserted for `ssl_cipher`. That is strange because a NOT NULL column with NO DEFAULT would normally generate an error if no value is inserted. But it does not here! Must be because it is a BLOB. But it does with you … hmmm.

3) I propose you try to create a user with “MySQL Administrator”.

[peterlaursen]

Then I shall repeat my request that the bulk size is user configurable.

Reason for that:

importing to my ISP w/o bulks is incredible slow. But the default bulk size is much too big for the configuration (fails to of three times) I would like an option to choose for instance 200 K as bulk size. That is reasonable fast and safe too.

[Author]

Posts