RE: Tabel Referencing Question
Hello everyone, I have the following line in my create table code: SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES SCAN_PARAMETER(SCAN_PARAM_ID) I need to make it so that scan_param_id references to two differences tables? Will this work? SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES SCAN_PARAMETER(SCAN_PARAM_ID) REFERECES SCAN_ACQUIRED_DATA (SCAN_PARAM_ID) Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 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 just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hello everyone, I have the following line in my create table code: SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES SCAN_PARAMETER(SCAN_PARAM_ID) I need to make it so that scan_param_id references to two differences tables? Will this work? SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES SCAN_PARAMETER(SCAN_PARAM_ID) REFERECES SCAN_ACQUIRED_DATA (SCAN_PARAM_ID) Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB question
Hello everyone, I have this database, I'm using InnoDB type tables. I wanted to know the following: How can I manipulate the tables, so that db supports multiple users trying to access the same table for writing or reading purposes at the same time. Thanks, Oganes Demirchyan Motorola 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 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, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hello everyone, I have this database, I'm using InnoDB type tables. I wanted to know the following: How can I manipulate the tables, so that db supports multiple users trying to access the same table for writing or reading purposes at the same time. Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 and Drug Administration) standards approval. Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 all .sql source files, and then I think you know what I'm getting to. Every table in DB1 got overwritten by new and empty tables. How can I get my stuff back I have all innodb_data and innodb_logs folders. I'm sure I should be able to use those, but don't know how. Please help. P.S. I'm using MySQL 3.23.46 w/InnoDB tables. Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 getting to. Every table in DB1 got overwritten by new and empty tables. How can I get my stuff back Please help. P.S. I'm using MySQL 3.23.46 w/InnoDB tables. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql create table error
I have the following create table, and I get the following error when I create it. It used to work before. Can anyone help? CREATE TABLE PROTOCOL_GROUPING( PROTOCOL_GROUPING_ID MEDIUMINT(20), GROUP_NAMEVARCHAR(50)NOT NULL, PROTOCOL_ID MEDIUMINT(20) NOT NULL, PROTOCOL_STEP_NO MEDIUMINT(10) NOT NULL, foreign key (PROTOCOL_ID, PROTOCOL_STEP_NO) REFERENCES PROTOCOL_STEP(PROTOCOL_ID, PROTOCOL_STEP_NO), UNIQUE INDEX PROTOCOL_GROUPING_PK (PROTOCOL_GROUPING_ID))Type=InnoDB; I get the following error: can't create table .\test\protocol_grouping.frm (errno 150) Oganes Demirchyan Oganes Demirchyan Motorola 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 04, 2002 11:02 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, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have the following create table, and I get the following error when I create it. It used to work before. Can anyone help? CREATE TABLE PROTOCOL_GROUPING( PROTOCOL_GROUPING_ID MEDIUMINT(20), GROUP_NAMEVARCHAR(50)NOT NULL, PROTOCOL_ID MEDIUMINT(20) NOT NULL, PROTOCOL_STEP_NO MEDIUMINT(10) NOT NULL, foreign key (PROTOCOL_ID, PROTOCOL_STEP_NO) REFERENCES PROTOCOL_STEP(PROTOCOL_ID, PROTOCOL_STEP_NO), UNIQUE INDEX PROTOCOL_GROUPING_PK (PROTOCOL_GROUPING_ID))Type=InnoDB; I get the following error: can't create table .\test\protocol_grouping.frm (errno 150) Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: exporting data to a new DB
Hello everyone, I need to export some data from one DB to another. Suppose I'm connected to DB1 and my trying to get stuff from there and insert into DB2. I'm using Insert Select statements. Once I'm connected to DB1, do I have to establish separate connection for DB2? An example Insert Select : Insert into db2.Pad_Analysis_Data (column names) Select * from db1.Pad_Analysis_Data; Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[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 in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hello everyone, I need to export some data from one DB to another. Suppose I'm connected to DB1 and my trying to get stuff from there and insert into DB2. I'm using Insert Select statements. Once I'm connected to DB1, do I have to establish separate connection for DB2? An example Insert Select : Insert into db2.Pad_Analysis_Data (column names) Select * from db1.Pad_Analysis_Data; Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 questions with regards, to a table size. In my case it will be (4GB)/36 bytes per table? Is it distributed uniformly, or some tables can grow bigger on the expense of the others (if some only have limited data, and others keep having new data inserted into them). Sincerely, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) ) Type=InnoDB; where I want to create table with 2 primary keys, but it won't let me. How could I do it. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 check to see how much of pre-allocated space has been used. Is it the actual size? I'm using MySQL 3.23.44 max with InnoDB tables. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 within my network to connect to my DB. For that I need a valid host name. I have tried %, which supposed to let everyone in, but no luck. I also tried something like 10.45.*.* or 10.45.%.% but no luck. I'm stuck. What else can I do? Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql Innodb data files
Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file. innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb allocated space to store all the InnoDB data in? What happens if I exceed 200Mb? Can I alter the size in the future, once I define a size for it? Also, if I had innodb_data_file_path = ibdata1:200M; ibdata2:200M And my data exceeded 200M, would the rest of the data transfer over to data2? What is the best configuration, having multiple datafiles that are small in size or have one datafile which will be big. Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 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,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file. innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb allocated space to store all the InnoDB data in? What happens if I exceed 200Mb? Can I alter the size in the future, once I define a size for it? Also, if I had innodb_data_file_path = ibdata1:200M; ibdata2:200M And my data exceeded 200M, would the rest of the data transfer over to data2? What is the best configuration, having multiple datafiles that are small in size or have one datafile which will be big. Thanks, Oganes Demirchyan Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 approved by the FDA. Any other suggestions would be appreciated. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 I'm expecting something like 1000 John Doe. And when I do another insert, then it will be 1001. Why this Default Value definition not making sure that I start with 1000? Thanks, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 I manually create iblogs and ibdata folders. I save the .ini file. Then I try to install mysqld-max-nt service by Typing c:\program files\mysql\bin\mysqld-max-nt --install It fails to install the service. In addition if I shut down my server, and fire it up again it won't start. As soon As I get rid of the new parameters except the innodb data file path, it starts working again. Does anyone knows what is going on. I'm using mysql 3.23.39 on Win2000. All I want is to be able to make it so that I can work with InnoDB as oppose to MYISAM as default. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php