RE: Tabel Referencing Question

, April 03, 2002 11:03 AM To: Demirchyan Oganes-AOD098 Subject: Re: Tabel Referencing Question Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you

RE: InnoDB question

Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 2:26 PM To: Demirchyan Oganes-AOD098 Subject: Re: InnoDB question Your message cannot be p

MySQL off-the-shelf product

Hello everyone, Would someone know of off-the-self MySQL product that will contain latest MySQL server in it? Something like 3.23.46a max-nt and above. I don't care what it's bundled with, PHP or perl. I just need to use the features of MySQL only. The reason I need it, is for FDA (Food an

Overwritten mysql tables

Hello everyone, I have posted this message 2 days ago, but surprisingly no one responded. I have these scripts that I load when I want to create new tables in the database. I had DB1 full of data. Then I created DB2 and forgot to change the database that I was working in, to DB2. I loaded al

my.cnf

Hello everyone, There used to be a section in mysql documentation, which explained about all the entries in my.ini file. Do you know what happened to it? There is a part about my.cnf but that's not what I want. There was more. -

Ovewritten mysql Tables(I need help)

Hello everyone, I need help. I have these scripts that I load when I want to create new tables in the database. I had DB1 full of data. Then I created DB2 and forgot to change the database that I was working in, to DB2. I loaded all .sql source files, and then I think you know what I'm gett

my.cnf

Hello everyone, There used to be a section in mysql documentation, which explained about all the entries in my.ini file. Do you know what happened to it? There is a part about my.cnf but that's not what I want. There was more. -

RE: mysql create table error

AM To: Demirchyan Oganes-AOD098 Subject: Re: mysql create table error Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message

RE: exporting data to a new DB

EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 1:41 PM To: Demirchyan Oganes-AOD098 Subject: Re: exporting data to a new DB Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words

Re: Database Size Limit

Hello everyone, I guess I have the similar question, that has been brought up. I have 36 InnoDB tables, and I have allocated two 2GB partitions for my data. Provided I have very big hard drive, how many partitions at 2GB each could I allocate? As many as my hard drive can handle? I also have

MySQL error

Hello everyone, I'm getting error 100 from table handler. This is generated by the MySQL ODBC. Does anyone know what this can be caused by? I'm doing an Update, when it results in this error. But not every time, it happens randomly. Regards, Oganes Demirchyan Oganes Demirchyan Motoro

Creating MySQL table w/2 primary keys

Hello everyone, I have this create table statement, drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), GROUP_CONCLUSION_IDMEDIU

Turn off autocommit

Hi everyone, I'm using InnoDB tables, and I would like to turn the auto commit off. I do SET AUTOCOMMIT=0 in my.ini file. And when I restart the server, it won't start. Does anyone know why? Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900

Auto-extending MySQL tablespace

Hello everyone, I've rewrote our existing our existing software to be compatible both for Oracle 8i and MySQL databases. I wanted to know, does MySQL support auto-extending of it's tablespace? I know how to manually do it, by adding data files, and restarting the server. Also, how could I chec

Granting Access in MySQL

Hello everyone, I'm trying to grant rights to several user accessing my database. Right now I'm using their individual IP addresses to grant them privileges. Which works fine. This way I have to assign user name and password to each and everyone of them. What I want is to enable everyone withi

RE: Mysql Innodb data files

, November 09, 2001 9:59 AM To: Demirchyan Oganes-AOD098 Subject: Re: Mysql Innodb data files Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query

Off the shelf MySQL products

Hello everyone, We'll probably be using MySQL with our software. But in order to do that it has to be aproved by FDA( Food and Drug Administration). Are there any off the shelf products that will have all the MySQL capabilities bundled up in it? I think that way our software will be approve

Autoincrement question

Hello everyone, I wanted to ask you 2 questions. 1. I have a table that has 2 columns, user_id, user_name. User_id has been setup to a default value 1000 and to AUTO_INCREMENT. When I insert a record, Insert Into User_Table (user_id,user_name) Values (Null,'Jon Doe'); I get 1 John Doe. But

Creating InnoDB tables

Hello everyone, I really need your help. I have been stuck for couple of days on trying to setup MySQL server such, that it supports InnoDB tables. First of all I copy the following into my.ini after [mysqld] innodb_data_file_path = ibdata1:2000M innodb_data_home_dir = c:\ibdata set-variabl