mysql-test-run --> func_compress failed with out of memory error...

Hi! I am in the process of upgrading the machine with everything to a newer versions. This time, I'm getting rid of the IBM DB2 as it won't be there. So, I downloaded the MySQL 64 bits for the AIX and extracted it there. The AIX server use 64 bits kernel and Enhanced Journal File

Does MySQL support server with 2 cpu??

Hi! We wanna know is does MySQL support the use of the server with 2 cpu? I have trouble finding that on the mysql.com website. If so, how does the configuration for the use of 2 CPU work?? Thanks, Scott D. Fletcher

RE: How to make 1 primary key work for 2 columns????

>Seldom wrong and right again, Shawn! Yes, I forgot to cover the >reflexive case. I don't have a magic bullet for that scenario; >you'd just have to check that with application code. > >But on re-reading his original post, it occurred to me that I >had misread it completely. I just sent a note o

RE: How to make 1 primary key work for 2 columns????

that with with DB2 but MySQL is different. Thanks, Scott - Original Message - From: "Scott Fletcher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 20, 2004 3:54 PM Subject: How to make 1 primary key work for 2 columns Hi! I'm tryin

RE: How to make 1 primary key work for 2 columns????

a Scott From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 3:28 PM To: Scott Fletcher Cc: [EMAIL PROTECTED] Subject: Re: How to make 1 primary key work for 2 columns I couldn't understand exactly what you were asking for. Did you want n

RE: How to make 1 primary key work for 2 columns????

ddress, if not matched then it's okay to enter it into the database. It's the only way... Thanks, Scott -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 20, 2004 3:30 PM To: Scott Fletcher Subject: Re: How to make 1 primary key work for 2 columns?

How to make 1 primary key work for 2 columns????

Hi! I'm trying to figure out how to make this possible... What I have here is a company address, along with both the primary contact and secondary contact. In them is one email address from the primary contact and one other email address from the secondary contact. Problem is setting an unique

my.cnf - do we need it or not?

Hi! Do we really need the my.cnf file to tweak MySQL? Mine doesn't have it and it just work fine... Thanks, Scott

Do Analyze Table before Optimize Table or the other way around??

I wanna know is do I do the Analyze the table before the Optimize the table or should I do it the other way around??? Thanks, FletchSOD

Bash Shell issue with the mysqldump's password.....

I am struggling to get the bash script to use the password. What I'm doing here is to assign it to a variable.. --snip- MySQLdump_FilePath="/usr/local/mysql/bin/mysqldump" UserId="root" DB_Production="DB_NAME" #Emarket_Production_Filepath=`/home/website/ProductionDB.sql` #Prefix_Produc

FW: Using the Index (Tables)....

-Original Message- From: Scott Fletcher Sent: Thursday, August 05, 2004 11:00 AM To: 'KSTrainee' Subject: RE: Using the Index (Tables) One more question. Does the column's name have to be in order by col1, col2 and col3? Or does it not matter which order, like c

Using the Index (Tables)....

I have one question. Once I create 2 or more indexes to a table, should I instruct MySQL to use which index in certain order? (Like use that 2nd index, not the 1st one). Another question, do I need to run the maintance on the index? If so, how? With IBM DB2, I had to run the index maintance we

Verify the database backup from mysqldump???

Is it possible to verify the database backup. Like most machines, that make backup of files then verify that all of it is backed up without an error? I use mysqldump to make a backup but I have no idea about the verify Thanks, Scott

Grant privileges to a new database...

What I have here is a database-driven website. In the past, I created a database and grant privileges to it. Now, I'm creating a carbon copy of it into another website which will be a test website with a test database. So, when I try the grant privileges to the test database, it returned a zero

Using SQL's JOIN to return all rows regardless of non-exist rows in other tables....

I'm trying to figure out how to get the table FUNDED_INFO to return all rows, even if there is no row(s) in the two other tables, STOCK & CUSTOMERS. This one doesn't really work 'cause either one of the two tables, STOCK and CUSTOMERS doesn't have a row which would cause a row from FUNDED_INFO not

Using function followed by "order by function_name(table.field_name)".....

I'm having a little bit of a trouble with the use of the SQL function... What I have here is a webpage that show the row of data, the web user get to click on the field to sort the row by the field name. So, when I use "order by char(field_name)", the data doesn't turned out right in alpha-numeric

MySQL Storage Engines and Table Types.....

Hi! How do I know which of the storage engine am I using or running, or whatever that use the databases/tables? Thanks, Scott F.

Questions about MySQL's INSERT syntax....

Hi! The SQL's INSERT Syntax that have been frequently been used is --snip-- INSERT INTO TABLE1 (COLUMN1,COLUMN2,COLUMN3,COLUMN4,COLUMN5) VALUES ('ONE','TWO','THREE','FOUR','FIVE') --snip-- where the TABLE1 have 5 columns, "COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5". What I wanna know is wi

MySQL -- SQL syntax error.....

When I use this SQL statement, ... --snip-- UPDATE BUSINESS_CATEGORY SET (BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) = ('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788' --snip-- I get the SQL syntax error saying, --snip-- You have an error in your SQL syntax.

Column's DataType -- TEXT vs BLOB...

rate from the table data and is related by a reference number in the table. This keeps the table smaller and faster as I understand. --snip--   So, I don't feel too sure what to decide on...  Care for some advice or recommendation??   Thanks,  Scott Fletcher

A Table with a timestamp as transaction date and primary key...

I read some articles that the use of SQL's TIMESTAMP in a table is use for recording the actual date/time that the row was inserted and for row(s) that is/are updated. I'm a little troubled by that because I want a table with a timestamp in the first column to be the transaction date which can be

GRANT PRIVILEGES doesn't perform the way I expect it to....??

I'm having a little trouble with granting the correct privilege to the user with one database instead of all databases. When I do this with all databases, it work great.. --snip-- //Issued SQL Command... GRANT ALL ON *.* TO 'Username'@'localhost.domain.com' IDENTIFIED BY 'Password' //Corre

MySQL Control Center - One quick question...

One quick question here. I just installed the MySQL Control Center and get the "host not allowed" connection error. So, do the database have to exist on MySQL Server and set-up permission for that database in order for MySQL Control Center's connection to work?? I'm new here as I switched fro

How to get MySQL to startup at boot up for AIX 4.3.3???

Hi! I'm using AIX 4.3.3 and I'm still not able to get the MySQLDaemons to start automatically at every bootup. AIX use the inittab, not the init.d Can anyone show me the way? Thanks, FletchSOD