Default date format

Hello! Is there a way how to change the date and time format accepted and returned by MySQL from '-mm-dd' to something different? I've seen several posts here telling it's impossible but they are quite old. Is it still true in recent MySQL versions? I can see date_format, datetime_format and t

"Show Innodb Status": Output truncated

Hi, this is on 4.0.22-standard. The output of "show innodb status" is truncated so that the sections FILE I/O, INSERT BUFFER AND ADAPTIVE HASH INDEX, LOG, BUFFER POOL AND MEMORY and ROW OPERATIONS are missing. We have more than 600 concurrent connections so that the TRANSCATIONS section becomes

Re: Default date format

> Is there a way how to change the date and time format accepted and > returned by MySQL from '-mm-dd' to something different? I've seen > several posts here telling it's impossible but they are quite old. Is > it still true in recent MySQL versions? I can see date_format, > datetime_format and

minimal privileges for a replication slave

Hello, I want to set up multiple replication slaves to the same master but with different access to databases, one database for one client... just in case if sb would brake into one of our slaves then he should not be able to download other databases from a master Is it possible? I found that REP

Re: Questions About Creating Tables

I see you found some DB code for a different platform. Most of your questions are based on the fact that these are NOT MySQL commands (or scripts) but SQL statements phrased for a different system. If you know what system it is designed for (Oracle, DB2. ??? ) you should be able to read their d

Can't install Mysql on Windows XP

Hello: I am trying to install mysql on my laptop which is running Windows XP professional. But after installation when trying to connect to the MySQL server I am getting the following error message: Error 2003: Can't connect to MySQL server on 'localhost' (10061). Tried all the options with my k

Re: Can't install Mysql on Windows XP

Did you install MySQL as a service and have you started the service? Sheni R. Meledath wrote: Hello: I am trying to install mysql on my laptop which is running Windows XP professional. But after installation when trying to connect to the MySQL server I am getting the following error message: Erro

mysql memory,users monitoring

First of all, thanks for the mailing list for giving details about myisamchk. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like memory related issues etc). Are there any other ways to find memory used and free memory av

Re: Questions About Creating Tables

Thanks so much for the tips! It's all falling into place now. I'm still using the animal database tables you suggested for me some time ago, but I also wanted to tap into this ITIS database. Combining or linking the two should be interesting. :) --- [EMAIL PROTECTED] wrote: > I see you found som

Re: "Show Innodb Status": Output truncated

Frank, CREATE TABLE innodb_monitor(a INT) TYPE=InnoDB; causes the output to be written to the .err file untruncated. DROP the table to stop the printouts. There is a limit in the mysql client that restricts the output length to 64 kB. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transac

Where can I download HPUX11.0 PA-RISC 2.0 (LP64) platform binaries for 4.1.8 mysql?

Hello- I am looking for "ELF-64 relocatable object file - PA-RISC 2.0 (LP64)" platform binaries for 4.1.8 mysql. Please lemme know where I can download this from? Thanx, Vivek PS: I downloaded this from the mysql.com mysql-standard-4.1.8-hp-hpux11.00-hppa2.0w ptdh172:vkrajan>file lib

Newbie: Using SELECT to Get Table Status?

The mysql>SHOW TABLE STATUS command returns such things as the number or rows and time of the last update. Is it possible to get the same information using a SELECT statement? FYI, I am writing a script to monitor replication status by comparing this information between the master and slave serv

importing data

Hi, I have done an incredibly stupid thing. I have a server that suffered a bit of a failure. It wasn't a hard failure, but it was enough of one to have to rebuild the server from scratch. I was and am running mysql 4.0.22 on Gentoo with a 2.6 kernel. It rocks. However, The dumb thing th

create "set" column with possible values 1 to 64

Hi, Is there any elegant way of saying the following statement in a shorter format: create table dummy ( col1 set(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,..64) ); That is, I would use all the 64 possible values that are offered by the "SET" column structure, and I am lazy to writ

Re: importing data

Curtis Maurand wrote: If I create one of the databases and then put the files for that database from the old installation in place of the newly created ones, the database is recognized, but i get errors saying that the columns in the tables are not recognized. I'd really like to get this data ba

Slow as Christmas join

Hello! I have a couple of tables I am doing a join on. Both have 6 fields. Most fields have fewer than 16 characters in them, but at most 75. Neither table is huge: one with 14004 rows and the other with 23677. I created a temp table to insert the data into. When I perform the join, it take