disabling wait_timeout?

Can it be done? I tried to disable this timer with wait_timeout = 0 in my.cnf. That changed the timeout (as reported by mysqladmin variables) from the default 28800 to 1. Tested, it was definitely a one-second timeout :-( As a hack-around, I've currently got it set to ten days. Alternatively,

{Virus?} TEST

Warning: This message has had one or more attachments removed Warning: (doc.zip). Warning: Please read the "VirusWarning.txt" attachment(s) for more information. test This is a message from the MailScanner E-Mail Virus Protection Service ---

RE: Replication with HEAP tables & slave insert error

Hi Egor, Thanks for the reply. My responses below - "Vinod Panicker" <[EMAIL PROTECTED]> wrote: > Hi, > > Had a query regarding replication with HEAP tables. It seems like I > cannot use LOAD DATA FROM MASTER to update the stopped slave with data > from the master since it apparently work

connection problems

I am getting the following log entry when ever I try to connect to mysql from the network. mysqld[2857]: refused connect from 192.168.1.28 This is on an SuSE 9.0 linux box and I haven't enabled any firewall yet so I don't know why this would be happening. Any ideas? Chris W -- MySQL General

InnoDB rollback

I just had a script fail unexpectedly and now I've got a couple hundred thousand undo entries rolling back. Yes, I realize that I should be committing smaller groups--my bad. I was really hoping to restart my server tonight to change some server parameters, but a rollback like this will take many

Database problem.

I hope you can help me with this: Incorrect information in file: './sarara/searchindex.frm' Error consulta SQL : SHOW KEYS FROM `searchindex` MySQL ha dicho: #1033 - Incorrect information in file: './sarara/searchindex.frm' How can I fix this??? Thanks ___

Create users : with password

I spend some time to figure how to add users with passwords, but have problem with following: Adding user with password: PROBLEM When I insert users to database: insert into user values('localhost','

Runtime Error '-214767259'

Hi all, help me pls, I try to connect to Mysql server, but it raise runtime error -214767259, "Host C-Xeon is not allowed to connect to this MYsql server" thanks a lot - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

max key length 500 in myisam index

I've got to create a table that has the following: CREATE TABLE access ( query VARCHAR(255) NOT NULL, INDEX (query) ); and mysql is telling that the max bytes allowed is 500 for key length. The docs say I can change this by recompiling, which I would like to avoid having to do. Is there any

Re: MySql and Oracle Forms 6i

Someone posted an answer: "Oh wow... I can't think of how you'd get that to work without a ton of custom. For starters, you'll have to write your own transactional triggers and intercept every one of Oracle's select, lock, update, insert, delete, like On-Lock, On-Insert, etc. since Forms will want

Re: starting a crashed mysqld

Rusma, below it crashes because several data pages are corrupt. You can try starting it on level 6 and dump your tables. Then recreate your InnoDB data files and ib_logfiles and import the table dumps. Since the corruption is extensive, you are probably not able to dump all your data, though. Bes

Re: mysql command line syntax

hi, you can try something like this mysql --force -uuser -ppass -Ddatabase -e"query.sql" where you can put all your SQL commands into to file named "query.sql" - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 02, 2004 8:38 PM Subject: mysql co

RE: My.cnf

> -Original Message- > From: Scott Haneda [mailto:[EMAIL PROTECTED] > Sent: Monday, February 02, 2004 6:13 PM > To: MySql > Subject: My.cnf > > > I have copied my-large.cnf to /etc/my.conf > Mysql 4 on OS X server > > How can I tell these new settings are in effect? > What settings were

My.cnf

I have copied my-large.cnf to /etc/my.conf Mysql 4 on OS X server How can I tell these new settings are in effect? What settings were run prior to this file being in place as there was no my.cnf? -- - Scott Haneda

FW: starting a crashed mysqld

The RAID that we used to hold our mysql data was crashed a few days ago. Although it is fine now (after switching to the secondary host connector), we can't seem to start the mysqld. We tried to start the server using the various innodb_force_recovery options (1-6) with no luck. Below is the err

MySql and Oracle Forms 6i

Is there any way of using MySql as a back end to Oracle Forms? Ken Brown

Re: PHP AND MYSQL

Thank you very much to all. Jason Burfield <[EMAIL PROTECTED]> wrote:This is probably something for the php list, however, how is REGISTER_GLOBALS set on your server? On or off? It is off by default on newer version of PHP. (has been for a while.) If it is off you need to grab the vars from post

[Stats] MySQL List: January 2004

-- Searchable archives for this list are available at -- ==

RE: PHP AND MYSQL

PHP has changed their superglobals, no longer can you just put a $ infront of the assigned name attribute. (You can change this in the php.ini file, but it's discouraged) Instead use $_GET['name'] Or $_POST['name'] So for $manufacturer $_POST['manufacturer'] -Original Message- From: See

RE: Advise on High Availability configuration

Hi, > So how does this bit work? If one master falls over and slaves > move to master two, how do you rebuild master one without downtime? > Don't the slaves try and use Master 1 as soon as it's back > online even though its data is out of sync? If master 1 fails and the slaves move to master

Re: PHP AND MYSQL

Seena, I believe that the proper syntax is ---> mysql_connect( host, username,password) Also I generrally when passing variables use $_POST['name'] ---> $_POST['version'] Good luck, Nestor :-) Seena Blace wrote: Hi, Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can

Re: PHP AND MYSQL

This is probably something for the php list, however, how is REGISTER_GLOBALS set on your server? On or off? It is off by default on newer version of PHP. (has been for a while.) If it is off you need to grab the vars from post like: $softwareid = $_POST["softwareid"]; $manufacturer = $_POST["man

PHP AND MYSQL

Hi, Does any one develop any web pages with PHP,Apache,Win2k,Mysql ? If so,can please help me. When I 'm inserting data thru html FORM ,getting error Notice: Undefined variable: like this.Can some one please send some tips pl? Html code: Software id: Manufacturer: Name: Version: Let m

RE: Multiple mysql servers with the same datadir

Hi, > But when runing multiple myisam & enable-external-locking database > servers with the same NFS datadir, will there be any deadlock problems? I have no experience in this but it sounds like it may cause problems. > I wonder if it is possible to use NFS as the storage backend and > to prov

ERROR 1205: Lock wait timeout exceeded; Try restarting transaction

I did similar insert minutes ago with no problems. Now I try to do the same insert just with differnet parameters and got such error message. insert into users(first_name, last_name) values('john', 'smith'); ERROR 1205: Lock wait timeout exceeded; Try restarting transaction Any ideas how to fix t

mysql deny access to datasource

I am running a web application under tomcat 4.03, and using a database pooling class (below) and all works well. That is until I update a class file. After I update a class file, then I get the error below stating the deny access to datasource. Does anyone know why this happens. I printed to sy

Re: LIMIT not working problem

Matthew Stuart wrote: This query is working fine apart from the LIMIT part. I can’t see what is wrong with it, I have tried it in different places and still no luck. Does anybody know why it’s not working? WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIK

Re: LIMIT not working problem

Limit needs to be the last line in your query >> Original Message << On 2/2/04, 1:55:13 PM, Matthew Stuart <[EMAIL PROTECTED]> wrote regarding LIMIT not working problem: > This query is working fine apart from the LIMIT part. I can't see what > is wrong with it,

RE: Multiple mysql servers with the same datadir

Hi, Andrew. Thank you very much for your explanation. And yes, I actually wanted to mean BDB, instead of DBD. I just checked BDB document. It seems they maintain their own locks. So my two cases will lead to data corruption. I wonder if there are any database management systems implementing lo

LIMIT not working problem

This query is working fine apart from the LIMIT part. I can’t see what is wrong with it, I have tried it in different places and still no luck. Does anybody know why it’s not working? WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_c

mysql command line syntax

Why does the following command, entered as a single line at a bash prompt, prompt me to enter more? mysql -u user -ppass -D database -e 'select field into outfile \'/tmp/field.1\' from mytable where id = 1;' > And is there any way to supress the 300 lines of useless usage that accumpanies ever

RE: Oracle Question

> -Original Message- > From: Ken Brown [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 31, 2004 11:45 AM > To: '[EMAIL PROTECTED]' > Subject: Oracle Question > > Anyone managed to get oracle forms 6i to talk to MySQL - if so how? > > I've got ODBC working but it will not connect and

Re: DOES MYSQL HAS CONCEPT OF SYNONYM

NOT DIRECTLY but if you're using (my)isam you can create softlinks on the underlying filesystem which is a really ugly hack but seems to work. Sid Lane DBA - Site Operations TWCi |-+> | | "Ansari, Raza| | | \(GEI, GEFA

DOES MYSQL HAS CONCEPT OF SYNONYM

Does anyone know if MySQL has the concept of Synonyms, as Oracle does? Raza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MYSQL (SQL ERROR)

Hi, I'm using Win2k,Apache,PHP(V4) and mysql . When I'm running php page ,noticing error " Notice: Undefined variable". Let me know how to fix pl? thx -seena - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!

User Variables in SELECT statement and LIKE syntax

These are the statements that are currently giving me the problems. SELECT @main_id:=ID, @FCSecID:=FCSecID, @Periodicity:=Periodicity, @EOP:=EOP FROM main_data_temp WHERE checked=0 ORDER BY fcsecid ASC LIMIT 1; SELECT * FROM actuals WHERE [EMAIL PROTECTED] AND Period LIKE '[EMAIL PROTECTED]'; # A

Bug Fix - mysql control center

When adding an entry to an existing table in any database, when pressing the tab button at the last column of any table, the column loses focus and then pressing tab once more makes the window for the table close and the entry is not added to the database ( ie: the focus should wrap around to the f

Re: query the data of a fulltext index directly from index?

Hi! On Feb 02, Alexander Bauer wrote: > Hello, > > is there any way to get the fulltext index contents directly? I'm looking > for a way to list all indexed words from a column to provide a filter > selection. > > How can I access the index data without walking through all table rows, get > the

RE: Advise on High Availability configuration

Hello All: Thank you for all the advise provided on this issue. Much appreciate Andrew's detailed answers and alternate solution. I will investigate the Replication method and try to devise some strategy to make sure that the Slave mirrors the Master as closely as possible. Also taking advant

Trouble with correlated subquery

Hello, I am having a problem with this correlated sub query. I get a syntax error at the second SELECT. This is part of a larger query with other aggregated sub queries or I would consider a JOIN instead. I tried running the sub query by itself and it works. I tried LEAST for MIN, same result. T

AUTO_INCREMENT in InnoDB

I can't drop the table. Can't I do without dropping the table? Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: query the data of a fulltext index directly from index?

In the last episode (Feb 02), Alexander Bauer said: > Hello, > > is there any way to get the fulltext index contents directly? I'm looking > for a way to list all indexed words from a column to provide a filter > selection. > > How can I access the index data without walking through all table row

RE: Advise on High Availability configuration

Andrew Braithwaite wrote: > Each slave keeps a heartbeat to the master and in the event of a failure, > changes it's master to master2. So how does this bit work? If one master falls over and slaves move to master two, how do you rebuild master one without downtime? Don't the slaves try and use M

query the data of a fulltext index directly from index?

Hello, is there any way to get the fulltext index contents directly? I'm looking for a way to list all indexed words from a column to provide a filter selection. How can I access the index data without walking through all table rows, get the column and tokenize and collect words? Thanks, Alex

Re: Replication with HEAP tables & slave insert error

"Vinod Panicker" <[EMAIL PROTECTED]> wrote: > Hi, > > Had a query regarding replication with HEAP tables. It seems like I cannot > use LOAD DATA FROM MASTER to update the stopped slave with data from the > master since it apparently works only for MyISAM tables. Any other way of > updating the s

Re: 5.0 replication and stored procedure

I can dupicate this everytime. I have just opened a bug. Bill Andrew Braithwaite wrote: Hi, 5.0 is "sub-alpha" at the moment. If you think there is a problem, go to http://bugs.mysql.com/ Cheers, Andrew -Original Message- From: William Au [mailto:[EMAIL PROTECTED] Sent: Friday 30 J

Re: AES_ENCRYPT returned value

At 07:20 AM 2/2/2004, you wrote: Hi, What's the best data type to store AES_ENCRYPTed text/password (without any data conversion)? I believe it can't be stored in CHAR or VARCHAR due to implicit internal conversions. Thanks. Hassan Hassan, I haven't tried it, but can't you use Binary in t

Re: FULLTEXT Index under InnoDB

At 08:51 AM 2/2/2004, you wrote: "Hassan Shaikh" <[EMAIL PROTECTED]> wrote: > Is there any plan to introduce FULLTEXT indices under InnoDB table > types? > Full-text search is in the InnoDB TODO list: http://innodb.com/todo.html But it's a long-term goal. If anyone has the cash to sponsor t

Re: FULLTEXT Index under InnoDB

"Hassan Shaikh" <[EMAIL PROTECTED]> wrote: > Is there any plan to introduce FULLTEXT indices under InnoDB table > types? > Full-text search is in the InnoDB TODO list: http://innodb.com/todo.html But it's a long-term goal. -- For technical support contracts, goto https://order.mysql.

Figured it out

Hey, The daemon will not start because the socket file cannot be created.. permissions are set properly running red hat 9 Pounded on it some more and figured out what was going on. It is all good now. Thanks /chris

Re: any ideas about it

"Nitin Mehta" <[EMAIL PROTECTED]> wrote: > Hi all, > > I m looking for any function or a work around to fetch numerical data without its > sign (-10 --> 10, 10 --> 10). Any ideas? There is ABS() function in MySQL: http://www.mysql.com/doc/en/Mathematical_functions.html -- For technica

Re: any ideas about it

On Mon, Feb 02, 2004 at 07:16:13PM +0530, Nitin Mehta wrote: > Hi all, > > I m looking for any function or a work around to fetch numerical data without its > sign (-10 --> 10, 10 --> 10). Any ideas? ABS() : mysql> select abs(-10); +--+ | abs(-10) | +--+ | 10 | +--

Re: commit,buffers

"Jamie Murray" <[EMAIL PROTECTED]> wrote: > Hi Guys, > How can I disable autocommit in the database. Can this only be done per session as > opposed to having it done globally at the database level. You can turn off autocommit only per session. > Last where can I get a complete list and explanati

any ideas about it

Hi all, I m looking for any function or a work around to fetch numerical data without its sign (-10 --> 10, 10 --> 10). Any ideas? Thanx

AES_ENCRYPT returned value

Hi, What's the best data type to store AES_ENCRYPTed text/password (without any data conversion)? I believe it can't be stored in CHAR or VARCHAR due to implicit internal conversions. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

FULLTEXT Index under InnoDB

Is there any plan to introduce FULLTEXT indices under InnoDB table types? Regards, Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.0.17-pc-linux-i686

The daemon will not start because the socket file cannot be created.. permissions are set properly running red hat 9 Thank you, Chris

Re: Query time out during login over network

Chris W <[EMAIL PROTECTED]> wrote: > I have recently installed suse 9.0 linux which has MySQL 4.0.15 as part > of the distribution. After I set up my users I was able to use > mysqldump and pipe it into mysql on my windows machine running 4.0.16 to > dump a database to the suse box. However, n

RE: Advise on High Availability configuration

Hi, OK - I'll try to explain in as much detail as I can.. We have redhat linux apache webservers running our apps with fcgi (which uses persistant DB connections). We have about 8 of these. It's important to understand that our MySQL system is optimised for a read-heavy / write-light site (abo

Re: Please help with "check" syntax

"Aaron P. Martinez" <[EMAIL PROTECTED]> wrote: > I am trying to set up a table from a script that came with some software > "Value accounting/CRM" and i'm getting a few errors, one of which i > can't seem to figure out/fix. > > My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb >

Re: Performance Problem

Mike, > Ronan, > If your queries are only returning fewer than a hundred rows, and > if every join is indexed, I would have expected it to take only a second or > two at most. I´m sorry, but I´m not so good in SQL queries, rather joins. If my queries are taking about 15 seconds instead

Re: Privileges By Groups

"Ed Reed" <[EMAIL PROTECTED]> wrote: > > Is there any way to assign Privileges to databases/tables/fields via > Groups rather than user by user? > Nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/

Re: Performance Problem

Mike, > Ronan, > You haven't given us much to go on. I´m sorry. > Is this application running on a web server? Yes, but in a diferent machine connecting via TCP/IP. > 1) How many rows are your queries returning? (on average) and how long does > it take? Hmmm... Most of the queries are l

Re: ORDER BY may remove result rows

[EMAIL PROTECTED] wrote: >>Description: > Instead of ordering rows, ORDER BY may remove rows >>How-To-Repeat: > CREATE TABLE T ( > Id INTEGER NOT NULL, > Id2 INTEGER NOT NULL, > Val FLOAT NOT NULL, > Id3 INTEGER NOT NULL, > KEY Key2 (Id2, Val), > KEY Key3 (Id3) > ); > > INSERT INTO T VALUES(

Re: Can't create/write to file './pricelists/iiptest.frm'

"Louie Miranda" <[EMAIL PROTECTED]> wrote: > What is wrong with this? im just trying to copy the table to another table? > > ## > > MySQL said: > > > #1 - Can't create/write to file './pricelists/iiptest.frm' (Errcode: 28) > ## $ perror 28 Error code 28: No space left on device -- For t

Re: SQL select help required please

I am trying to create a html search results page with the following: SELECT * FROM tbl_allarticles WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue' The above works fine, but the below code is giving me some ji

ANN: Database Workbench 2.4.2 released

Ladies, gentlemen, Upscene Productions is happy to announce the next version of the popular database development tool: Database Workbench 2.4.2 has been released today! Download a trial at: http://www.upscene.com Features and fixes: http://www.upscene.com/news/20040202.htm Database Workbench

Re: Why does MySQL generate internal foreign key id when constrain name

Philip, - Original Message - From: "Philip Walden" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, February 02, 2004 3:39 AM Subject: Why does MySQL generate internal foreign key id when constrain name > I am using MySQL 4.1.1-1. > > When I add a "named" foreign ke

Re: Advise on High Availability configuration

On Mon, Feb 02, 2004 at 09:17:08AM +0100, A.J.Millan wrote: No, when we implemented high-availability MySQL servers we used MySQL's inbuilt replication - this has been running here for years now and we have had constant DB availability during that time, even though individual machines have failed n

Re: Advise on High Availability configuration

> > No, when we implemented high-availability MySQL servers we used MySQL's > inbuilt replication - this has been running here for years now and we have > had constant DB availability during that time, even though individual > machines have failed now and again. We're using 2 masters & 4 slaves wi

Re: FreeBSD 4.9 + MySQL 4.0 + LinuxThreads

Alas, when I tried the binary version, it gave me an error that google helped link me to the following: Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthread/uthread_create.c (errno = ?) mysqld got signal 6; http://lists.freebsd.org/pipermail/freebsd-stable/2003-May/0