Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberSQLyog logs all the queries in the History window. You can cut & paste the query out here.
Also, paste the Create Table stmt. of both the tables. You can get it from the Object Tab of SQLyog.
HTH
Ritesh
MemberWhich option are you using to Backup your database. SQLyog only asks you for password when it is connecting to the MySQL server.
Ritesh
MemberI guess this is for a MySQL server running on Linux. You have to modify my.cnf
Ritesh
MemberHere is a sample from the MySQL command line utility. I ran some queries on MySQL 4.1.1-alpha on Win2K server.
Code:mysql> create table TableName1 ( a char(1) );
Query OK, 0 rows affected (0.00 sec)mysql> show tables from ritesh;
+——————+
| Tables_in_ritesh |
+——————+
| tablename1 |
+——————+
1 row in set (0.00 sec)Ritesh
MemberSQLyog never modifies the case of object names. This is what is returned by MySQL. I guess your MySQL is running on Win-x- server.
Ritesh
MemberGreetings
This feature will be provided in SQLyog 3.6 wherein SQLyog will remember all the last settings.
HTH
Ritesh
MemberCan you tell me the exact error message?
Ritesh
MemberThanks for the suggestion 🙂
Ritesh
MemberCreate to correct DSN to the Access database ( .mdb ). Select the newly created DSN in the dropdown instead of *MS Access Database*.
You will find this imformative – http://www.devshed.com/Server_Side/MySQL/S…Lyog/page1.html
Ritesh
MemberCheck the solution at the bottom
Ritesh
MemberGo to the bin sub-directory of your MySQL installation. Start the command prompt ( type cmd ) in Start->Run ).
You can connect to any server thru the MySQL command line utility by issueing the following command –
mysql -u
-h -p Ritesh
MemberI have asked my development team to look into the matter. I will reply back soon.
Ritesh
MemberGreetings
Are you sure, you have the correct permission to connect to the remote MySQL server?
Ritesh
MemberTry :
Quote:UPDATE order SET `status`=200 WHERE order_id=5;Ritesh
MemberSome old GLIBC library causes the above problem. Can you tell me the exact MySQL version and the RH version?
BTW, are you able to connect thru the MySQL command line utility?
-
AuthorPosts