Question on V5.0.9 and SHOW command

Hello, I have a strange issue. When I issue the command SHOW COLUMNS from TABLE XYZ I get the usual output.The key field is blank because there is no key on the field. However, when I issue the command from a PERL script the the DBI::DBD it returns MUL in the key field. There is no index asso

Date/Time Problem with V5.0.6 views

Hello everyone, I cannot figure this out. I have a table like the following: Tab_A datetime_field datetime not null, num_field bigint not null I do a SELECT as follows: Select datetime_field, num_field from Tab_A where datetime_field='2005-03-10' and num_field = 1234; I return 2 ro

MySQL / DBI Question

Hello all, This may be a little bit off topic for MySQL newsgroup but here goes.I'm trying to retrieve variables such as basedir and datadir. PERL/DBI returns 2 rows for each varialbe. The first is the name and the second is a value. Is there a way to get PERL/DBI to return each variable

Found Wrong Record xxx (using 5.0.6 windoz)

Hi, I will give the output below. I just ran an insert of a small amount of data into Windoz/MySQL 5.0.6. Then, I ran a "myisampack" agains it. Finally, I ran a myisamchk against it and keep coming up against this error: Found wrong record at 687081 Now, I'm the only one who has access to this

Re: Connection Issue with DBI::DBD::Mysql (more information)

Hi, My "bad". I forgot to explain that the IP address returned is NOT that of the machine where I'm running the program (the Linux server). That address is different from the one returned. Sorry for the confusion. George [EMAIL PROTECTED] wrote: >looking at this the ipnumber 192.168.2.1

Connection Issue with DBI::DBD::Mysql

Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with the following output: imp_dbh->connect: dsn = databas

RE: discuss: user management

Danny, My 2 cents (American dollars): From a security standpoint (if you are a financial institution) you'd would never get away with #2 because there is no audit trail with multiple users using a "generic" user id. The MySQL implementation of security is not implemented with auditing and

Repost: Lower Case Problems with Win XP Pro and 5.0.6 MySQL

Hi, Anyone experience this problem. I did the following: C:\perlsrc>mysql -f --user=root --password= --port=3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 48 to server version: 5.0.6-beta-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the

Lower Case Problems with Win XP Pro and 5.0.6 Mysql

Hi, Anyone experience this problem. I did the following: C:\perlsrc>mysql -f --user=root --password= --port=3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 48 to server version: 5.0.6-beta-nt-log Type 'help;' or '\h' for help. Type '\c' to clear th

MERGE Table Question

Hello everyone, We're going to be using the "MERGE TABLE" option of Mysql when we build our Data Warehouse. Basically (for you Oracle folks), we're going to mimic PARTITIONS. My question is this: Other than dumping syntax through a utility and comparing text, is there any way I can read the

RE: DBD::Oracle issue

Wrong forum for MySQL but you're getting the error because unless you created a view/table for "all_tables" then it doesn't exist. I suspect you're trying to use the view "USER_TABLES" or "DBA_TABLES" (if you have the GRANT to view that DBA view. [EMAIL PROTECTED] wrote: >ALL, > > > >Can so

Re: MySQL give up on a query after a certain length of time

There is a variable called --network-timeout ! You can set it to 300 (5 minutes, etc.). "Tony Yau" <[EMAIL PROTECTED]> wrote: >Hi Guys, >you can always set a max time out for your php script (php.ini) >Tony > >- Original Message - >From: "Gleb Paharenko" <[EMAIL PROTECTED]> >To

RE: Solution to slow queries

I'm somewhat a newbee on this database but some observations: As your table grows (and indexes) INSERTS will definitly slow because of the indexes. Consider MySQL's version of Oracle's partitioning and using MERGE TABLES "feature". Just remember that if you change 1 table, all of them have to b

myisamchk and myisampack

Hello everyone, When running these utilities does the MySQL daemon have to be "down"? There's no activity against the database other than an occasional query. George __ Switch to Netscape Internet Service. As low as $9.95 a month

Re: MyISAM error 127

Hi, Thanks for the reply. Are u suggesting that I shutdown MySQL? I thought that a FLUSH table command would take care of things. Stupid me! gerald_clark <[EMAIL PROTECTED]> wrote: >[EMAIL PROTECTED] wrote: > >>Hi, >> We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux fo

MyISAM error 127

Hi, We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data warehouse. I have a group of tables (9/2004 through 2/2005) that average about 95 million rows (215 byte rows). Using PERL and piping to mysql LOAD DATA is the way we've been loading. That all worked as ad

Message repeating every second in Error Log

Does anyone know why this message keeps repeating: 050425 11:31:40 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS 050425 11:31:41 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS 050425 11:31:42 229 Query SHOW S

Changing the Prompt for timing purposes

Hi, The MYSQL command line interface is very basic. Can it be modified like the shell command prompts so that I can include date/time for timing benchmarks? Secondly, is there an "echo" command in MYSQL command prompt so that I can see the command I issued or a log file that I can write to

Re:ERROR 2013: Lost connection to MySQL server during query

Hi, I'm having a similar problem using the LOAD DATA. I get an intermittent error: ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query The command is: LOAD DATA local infile 'pipefile' into table FACT_TABLE fields terminated by '~' lines terminated by '\n'; I cannot