Forum Replies Created
-
AuthorPosts
-
Manoj
MemberI never faced any problem with 5.1.9…till now….
here I am pasting my one session…just look to it once….
G:Installmysql519bin>mysql -h localhost -u root -P 3310
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 9 to server version: 5.1.9-beta
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> select version();
+
+| version() |
+
+| 5.1.9-beta |
+
+1 row in set (0.00 sec)
mysql> use test;
Database changed
mysql> show tables from test;
+
+| Tables_in_test |
+
+| n.s |
| stu.new |
+
+2 rows in set (0.00 sec)
mysql> show create table `stu.new`;
+
+
+| Table | Create Table
|
+
+
+| stu.new | CREATE TABLE `stu.new` (
`ID` int(11) DEFAULT NULL,
`Name` char(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+
+
+1 row in set (0.00 sec)
mysql> rename table `stu.new` to `stu.cls`;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
Bye
G:Installmysql519bin>mysql -h localhost -u root -P 3310
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 10 to server version: 5.1.9-beta
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> use test;
Database changed
mysql> show tables from test;
+
+| Tables_in_test |
+
+| n.s |
| stu.cls |
+
+2 rows in set (0.00 sec)
mysql> rename table `n.s` to minw;
Query OK, 0 rows affected (0.00 sec)
mysql> rename table mine to `mine.csv`;
ERROR 1017 (HY000): Can't find file: '.testmine.frm' (errno: 2)
mysql> rename table minw to `mine.csv`;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
G:Installmysql519bin>mysql -h localhost -u root -P 3310
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11 to server version: 5.1.9-beta
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql>
MemberCan you post little more details like how to reproduce it. Actually i am not able to find any inconsistencies
MemberChris Owens wrote on Apr 6 2006, 02:38 AM:Disabling auto complete doesn't work either… although it does cause SQLYog to immediately shut down when clicking “OK” in the prefences panel.Yes, there is one crashing bug in preferences.
you can disable autocomplete by editing the sqlyog.ini in the installation folder. Insert one string AutoComplete=0 in [GENERALPREF] section if it is not there, if it is there and it is =1 make it =0
Membernicmar wrote on Mar 31 2006, 01:38 PM:Don't know the reason for this, I'm using Beta 5 and just installed MySQL:1. Install MySQL
2. Connect to localhost – Sqlyog hangs
3. Restart program
4. Connect to external host – It works
5. Connect to localhost – It works
6. Restart program
7. Connect to localhost – Sqlyog hangs
This means I have to connect to another mysql-server before the one on localhost, or else it doesn't work.
Any clues on this?
-nicmar, the bugfinder 😉
Can you post the version of MYSQL you are trying to connect?, or it is happening with all servers?
Memberstom2005 wrote on Mar 31 2006, 11:36 AM:I think I happens on all “bigger” tables …..What u mean by “bigger”?, too many columns/too many rows?
I am able to reproduce this crash with one table having 192 columns.
Memberstom2005 wrote on Mar 29 2006, 03:46 PM:Hello Support,I think I found a little bug in the beta 5 (same problem in beta 4). If I connect to a database webyog crashes tring to navigate with curosr uip down through the tables.
Example:
Ich connet to the database foo
I have some tables:
Table 1
Table 2
Table 3
Table 4
Table 5
…
I klick table data (and show all)
now I klick on table 1 and the table data is shown. Everything OK
Now if I try to go to the next table with cursor down webyog freezes for about 2-3 secs and then closes without any (error)message.
Best Regards,
Marcus
Whether it is happening for all tables or when you select a specific table?
if so can you post the table schema?
-
AuthorPosts
