batch mode
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 how can we write a sql statement on the command prompt. I looked into the manual but didnt find it. Is there anyone who can tell me the exact syntax. Please help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table protection
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.com/[EMAIL PROTECTED]
table protection
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.com/[EMAIL PROTECTED]
mysqld max
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 file but how can I get rid off this error??. My computer have just 64MB ram. Do u think that less ram is causing this error??. Please help thanx Kamran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: creating table type innodb
I am working on mysqld-max. I have created the my.cnf file yet. The manual does not have clear instructions on that. Can you help me in making mysqld-max to work?? I mean can u explain me the procedure if possible. Appreciate it thank U Kamran >= Original Message From "Subhakar 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- >From: azamka [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 08, 2003 11:38 AM >To: Quinlan, Grant; mysql >Subject: RE: creating table type innodb > > >Yeah I though about that too. But i am not able to find the command for >creating a database in an innodb mode.?? DOu have an idea about it Grant??. > >thank u >kamran > > > > >>= Original Message From "Quinlan, Grant" <[EMAIL PROTECTED]> = >>I am a newbie myself, so please someone correct me if I am wrong, but here >>is how I understand it: >>A MySQL installation can support several databases. The system tables are >>always in a system database that uses tables of type ISAM. You create >>another database of type InnoDB, in which you keep your InnoDB tables. >> >>With the ISAM database every table is stored in a separate file. With InnoDB >>all tables in the database are stored in one or more database files, and >>data from single table may be stored within several of these database files. >> >>To use InnoDB tables and other InnoDB features 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: creating table type innodb >> >> >>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 table tablename type = >> >>innodb". Command runs fine but the table type doesnt change. I tried to >>create >>a new table of type innodb but its not working either. I dont know what the >>problem is. Do we have any command to enable the innodb property or what?? I >> >>am stuck badly. Please help. >> >>Thank you in advance >> >>Kamran >> >> >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: creating table type innodb
Yeah I though about that too. But i am not able to find the command for creating a database in an innodb mode.?? DOu have an idea about it Grant??. thank u kamran >= Original Message From "Quinlan, Grant" <[EMAIL PROTECTED]> = >I am a newbie myself, so please someone correct me if I am wrong, but here >is how I understand it: >A MySQL installation can support several databases. The system tables are >always in a system database that uses tables of type ISAM. You create >another database of type InnoDB, in which you keep your InnoDB tables. > >With the ISAM database every table is stored in a separate file. With InnoDB >all tables in the database are stored in one or more database files, and >data from single table may be stored within several of these database files. > >To use InnoDB tables and other InnoDB features 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: creating table type innodb > > >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 table tablename type = > >innodb". Command runs fine but the table type doesnt change. I tried to >create >a new table of type innodb but its not working either. I dont know what the >problem is. Do we have any command to enable the innodb property or what?? I > >am stuck badly. Please help. > >Thank you in advance > >Kamran > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
creating table type innodb
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 table tablename type = innodb". Command runs fine but the table type doesnt change. I tried to create a new table of type innodb but its not working either. I dont know what the problem is. Do we have any command to enable the innodb property or what?? I am stuck badly. Please help. Thank you in advance Kamran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
linux and mysql socket
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 to figure out why is this happening. Please help me. thanks in advance. Kamran -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]