Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantDelete ???
Nope!
We'll keep in it our archives for ever … :ph34r:
ParticipantAnd if I understand you right script just start ovr and over again??
That sounds strange …
Can you create some small script that does this and zip and attach it here?
Participant“some old VB6 applications I wrote could pick up on the sqlgyog SSH tunnel”
really the SQLyog SSH tunnel? You did not just create a romote SSH shell?
“.. possible for these VB6 applications to do the same with the HTTP tunnel?
The SQLyog executable and the tunneller file communicate using XML. The tunnneller will only work with the SQLyog compiled-in XML-parser. To write something similar yourself you should convince Ritesh that he publish all details of the XML-schema. I don't think you can …
ParticipantCould you explain wore in details what kind of script is is and how you execute it?
ParticipantNow .. one aspect more
let's chenc the use of backsash in identifiers
rename table `test`.`jklddfd` to `test`.`jkl\ddfd`;
show tables;
/*
results in
Tables_in_test
jkl\ddfd
And
*/
rename table `test`.`jkl\ddfd` to `test`.jklddfd; (from SQLpane – not GUI)
and 'table does not exist'. Now 'd' should mean 'd' according to general rusles for escaping ….
Solid garbage MySQL did here IMO!!
ParticipantI felt safe enough to report this one myself:
ParticipantMySQL 5.0 and previous:
mysql> rename table yesno to `maybe.not`;
ERROR 1103 (42000): Incorrect table name 'maybe.not'
mysql>
because:
http://dev.mysql.com/doc/refman/5.1/en/legal-names.html
Quote:There are some restrictions on the characters that may appear in identifiers:No identifier can contain ASCII 0 (0x00) or a byte with a value of 255.
The use of identifier quote characters in identifiers is permitted, although it is best to avoid doing so if possible.
Database, table, and column names should not end with space characters.
Before MySQL 5.1.6, database names cannot contain ‘/’, ‘’, ‘.’, or characters that are not allowed in a directory name.
Before MySQL 5.1.6, table names cannot contain ‘/’, ‘’, ‘.’, or characters that are not allowed in a filename.
… but does not look like the new implementation of MySQL 5.1 is very successfull.
ParticipantI want to add that I am not sure about the garbled table.
I now remember how that came into existence.
Table was created with beta6
(Migration Access yes/no >> BIT '0'/'1' thing)
ParticipantOK .. backticks do some of it
mysql> rename table dummy to `peter.tst`;
Query OK, 0 rows affected (0.38 sec)
mysql> select * from `peter.tst` limit 5;
+—-+
+
+| Id | t | f |
+—-+
+
+| 0 | d | NULL |
| 1 | a | 77.777 |
| 2 | b | 88.888 |
| 3 | c | 99.888 |
| 7 | e | NULL |
+—-+
+
+5 rows in set (0.00 sec)
Next opening another cmd-line client and SQLyog.
cmd-line client shows the change – SQLyog not
ParticipantAnother example:
===========
1)
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 5.1.9-beta-log
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> use test;
Database changed
mysql> show tables;
+
+| Tables_in_test |
+
+| dummy.ext |
| ggg |
| t1 |
| tablename1 |
| tbldependents |
| test |
| yesno |
+
+7 rows in set (0.00 sec)
mysql> rename table `dummy.ext` to dummy;
Query OK, 0 rows affected (0.09 sec)
mysql> rename table tabel1 to `tabel1.ext`;
ERROR 1017 (HY000): Can't find file: '.testtabel1.frm' (errno: 2)
mysql> rename table `dummy.ext`to `tabel1.csv`;
ERROR 1017 (HY000): Can't find file: '[email protected]' (errno: 2)
mysql> show tables;
+
+| Tables_in_test |
+
+| dummy |
| ggg |
| t1 |
| tablename1 |
| tbldependents |
| test |
| yesno |
+
+7 rows in set (0.00 sec)
mysql> rename table t1 to `testtest.test`;
ERROR 7 (HY000): Error on rename of '.testt1.MYI' to '.testtesttest@002etes
.MYI' (Errcode: 2)
mysql> rename table t1 to `testtest.csv`;
ERROR 7 (HY000): Error on rename of '.testt1.MYI' to '.testtesttest@002ecsv
MYI' (Errcode: 2)
mysql> rename table ggg to `dummy.www`;
ERROR 7 (HY000): Error on rename of '.testggg.MYI' to '[email protected]
I' (Errcode: 2)
mysql> rename table yesno to `mine.csv`;
Query OK, 0 rows affected (0.41 sec)
mysql> show tables;
+
+| Tables_in_test |
+
+| dummy |
| ggg |
| mine.csv |
| t1 |
| tablename1 |
| tbldependents |
| test |
+
+7 rows in set (0.00 sec)
mysql> select * from mine.csv limit 5;
ERROR 1146 (42S02): Table 'mine.csv' doesn't exist
mysql>
2)
mysql> rename table tablename1 to `test.yog`;
Query OK, 0 rows affected (0.35 sec)
mysql> select * from test.yog limit 5;
ERROR 1146 (42S02): Table 'test.yog' doesn't exist
mysql>
After that opened in SQLyog
See attached
first table was innoDB, second myISAM.
was that a question for Manoj or for me?
I cannot remember in detail what I did three days ago. But you can see what I just did!
I can add that after closing command-line client and reconnection with SQLyog the correct tables show up. However the InnoDB table is still garbled.
Now:
1) are tablesnames with '.' legal ?
2) will client need to be closed for changes to be flushed?
ParticipantWell .. I came, I saw …
Now what do you conclude from that?
ParticipantRitesh' post made me read again.
Do you mean this situation:
On source and target there are two rows having identical (autoincrement) PK's (say '117'), but the data are different?
And you want the row from the source added to the MySQL database (and a new PK-value for that new row generated by the server) ?
ParticipantIf I understand you right what you are requesting is behind the 'advanced' botton (for each table involved).
SQLyog Migration tool automaticlay uses a PK to identify rows if there is a PK available.
Please see attached. Did that answer your question?
Participantlooks like it is over … OK that I restore our own graphics?
ParticipantI think this is a good idea. But I think we will have to think a little on how it should be done.
A general option is one way .. SHIFT+TAB for that meaning is another …
More ideas out there?
-
AuthorPosts
