linux and mysql socket

2003-06-19 Thread azamka
I installed mysql manually on red hat 9. It worked fine couple days but from yesterday i am getting a weird error when i tried to run the mysql. the error statement is " Error 2002: Can't connect to local MySql server through socket '/tmp/mysql.sock'(2). I am new user of Linux and I am unable t

creating table type innodb

2003-07-08 Thread azamka
Hi everyone, I am trying to create tables with type innodb. I created a database and all the tables of type ISAM. Now I am at the point of making relations and establish refrential integrity. For that ofcourse I have to change the tables in the Innodb type. I did that with the commad "alter tab

RE: creating table type innodb

2003-07-08 Thread azamka
you must first create an >InnoDB database, then copy your tables into new tables in the InnoDB >database. > > Grant Q > >-Original Message- >From: azamka [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 08, 2003 10:59 AM >To: [EMAIL PROTECTED] >Subject:

RE: creating table type innodb

2003-07-08 Thread azamka
ar Burri" <[EMAIL PROTECTED]> = >There'z no InnoDB mode for a database, it's only for tables and you can create InnoDB tables in any database as long as it supports InnoDB features. Do you have mysqld-max running? > >HTH, >SB > >-Original Message

mysqld max

2003-07-09 Thread azamka
Hi I am trying to make mysqld max so i can create innodb tables but I am getting the following error when i run mysqld No Variable Match for: -0 'innodb_buffer_pool_size = 40M' ./mysqld version 3.23.56 for pc-linux on i686 I am unable to figure out what to do. This shows that it reads the my.cnf

table protection

2003-07-15 Thread azamka
Is there any command that we can use to view the protection on the tables??. Is there any way that we can convert read only tables to read write?. Please ehlp thank u kamran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

table protection

2003-07-15 Thread azamka
Is there any command that we can use to view the protection on the tables??. Is there any way that we can convert read only tables to read write?. Please ehlp thank u kamran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

batch mode

2003-07-29 Thread azamka
I am trying to right sql statement on the shell prompt but its not going through. Here is the statement: [EMAIL PROTECTED] usr]# mysql security < select * from machine; -bash: select: No such file or directory It is asking for the text file. And it works fine with the text file. I am wondering