Re: Changing root access on MySQL

2002-02-25 Thread DL Neil
Hi Jim, Please forgive the elementary question but I am new to MySQL and DBs in general. I have inherited a MySQL DB to which the root password is not available, I have read the documentation on the subject but my best efforts have failed to elicit the desired result from MySQL.

Re: Finding overlapping intervals efficiently

2002-02-25 Thread Colin Dewey
I did some playing around with various indices on the tables and found that the fastest configuration was without any indices! With two tables (t1 and t2) with fields start and end, using an index (start, end) or indices on the on the two fields separately, the speed of joining the two tables

Re: Error Locking Tables

2002-02-25 Thread Gelu
Hi Tom, ... you forgot to put the locking purpose: write or read: Ex: lock mytables write; Gelu G.NET SOFTWARE COMPANY - Original Message - From: Tom Caruso [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday,

Re: Changing root access on MySQL

2002-02-25 Thread Gelu
Hi, My opinion is : - open the mysql client;select the system mysql database with use mysql and update the users table with next SQL statement : update user set Password=PASSWORD('your_new_password') where user='root' and Host='%'; and to make active this change you can do:

Error Locking Tables

2002-02-25 Thread Victoria Reznichenko
Tom, Monday, February 25, 2002, 3:41:27 AM, you wrote: TC Hello, TC I am using MySQL 3.23.47 under Windows 98 (mysql-opt) and I am TC having a strange problem. I issued the LOCK TABLES TC table_name; command at the command prompt and I got the TC following error: ERROR 1064: You have an

Changing root access on MySQL

2002-02-25 Thread Victoria Reznichenko
jim, Monday, February 25, 2002, 5:26:35 AM, you wrote: j Hi all, j Please forgive the elementary question but I am new to MySQL and DBs in j general. j I have inherited a MySQL DB to which the root password is not available, I j have read the documentation on the subject but my best efforts

help wih files in mysql Db

2002-02-25 Thread BLANCHET
Hi, I've a table with a longblob type field. I've a pdf file in a field and I would like to open it in a browser with PHP. How ca I do with which query can I take the PDF file? Thanks Sorry for my english. Sam - Before

help wih files in mysql Db

2002-02-25 Thread BLANCHET
Hi, I've a table with a longblob type field. I've a pdf file in a field and I would like to open it in a browser with PHP. How ca I do with which query can I take the PDF file? Thanks Sorry for my english. Sam - Before

Linux PPC - small footprint - memory files

2002-02-25 Thread Leonard Matherson
Hello everyone, We are about to migrate to a Linux system on an MPC82xx - either 8240 or 8260. With only 32meg of memory, we need mySQL to have a very small footprint. Most of our tables are quite small in volume - maybe 1000 or 2000 rows in total for all of the dynamic tables, and a much

connection with specific host failure

2002-02-25 Thread Marek Wysmulek
Dear all. I have Debian (kernel 2.4.19) and mysql 3.23.49 updated from 3.22. Before update everything was working fine. After it seems to also BUT: I can not connect from other host then localhost (literally - even 127.0.0.1 takes no effect) Iptables rules are wide accepting. In host name

Re: connection with specific host failure

2002-02-25 Thread Jeremy Zawodny
On Mon, Feb 25, 2002 at 01:08:49PM +0100, Marek Wysmulek wrote: Dear all. I have Debian (kernel 2.4.19) and mysql 3.23.49 updated from 3.22. Before update everything was working fine. After it seems to also BUT: I can not connect from other host then localhost (literally - even

Re: MySQL 4.x Timeline

2002-02-25 Thread Jeremy Zawodny
On Fri, Feb 22, 2002 at 08:29:03AM -0500, Anthony W. Marino wrote: On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote: On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote: Is there a timeline/status for 4.x functionality available? No. It'll be ready when it's

Re: MySQL 4.x Timeline

2002-02-25 Thread Jeremy Zawodny
On Fri, Feb 22, 2002 at 08:59:41AM +, [EMAIL PROTECTED] wrote: I would like to second this request. I *really* want the replication failover functionality targeted for 4.x. In fact, if it isn't going to arrive by, say, midsummer, I will have to develop my own failover solutions. Well,

Re: mysql and onboard ide raid

2002-02-25 Thread Jeremy Zawodny
On Mon, Feb 18, 2002 at 03:05:09PM -0500, Andrew Crum wrote: As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I would _highly_ recommend a journaling filesystem such as Reiserfs (http://www.namesys.com) or XFS (http://oss.sgi.com). You do know that ext3 is journaling, right?

Re: connection with specific host failure

2002-02-25 Thread Marek Wysmulek
I can not connect from other host then localhost (literally - even 127.0.0.1 takes no effect) Iptables rules are wide accepting. In host name there is name of the host, and in hosts IP is associated. Are you using the Debian mysql-server package? If so, then check out your

update gweMysql JDBC Driver

2002-02-25 Thread TAKAHASHI, Tomohiro
Hi, All gweMysql JDBC Driver Update!! $B!&(BSupport Borland Enterprise Server5.0 (EJB2.0) $B!&(BSupport JBuilder6 $B!&(BConnectionPoolDataSource support maxPoolSize property ( 0 means no-limit ) [WebSite]

backup with crond

2002-02-25 Thread Victoria Reznichenko
Impex, Sunday, February 24, 2002, 6:05:51 PM, you wrote: IHMH Hello everyone, IHMH I am trying to do backups using the crond daemon on my Linux server. IHMH Can I write a similar line as below on my crontab file. IHMH Any examples would be appreciated. IHMH mysqldump impex

help wih files in mysql Db

2002-02-25 Thread Egor Egorov
BLANCHET, Monday, February 25, 2002, 12:06:09 PM, you wrote: B Hi, B I've a table with a longblob type field. B I've a pdf file in a field and I would like to open it in a browser with PHP. B How can I do with which query can I take the PDF file? Use SELECT statement, but don't forget to

MySQLGUI Problem

2002-02-25 Thread Egor Egorov
Rex, Monday, February 25, 2002, 6:18:41 AM, you wrote: RY Hello, RY When I tried to run mysqlgui, this is the error message that I received: RY can't connect to local MySQL server trough socket (111) RY I've checked and created all the client files. What does it mean? How can RY I correct

Re: connection with specific host failure

2002-02-25 Thread Jeremy Zawodny
On Mon, Feb 25, 2002 at 01:29:27PM +0100, Marek Wysmulek wrote: I can not connect from other host then localhost (literally - even 127.0.0.1 takes no effect) Iptables rules are wide accepting. In host name there is name of the host, and in hosts IP is associated. Are you

Re: connection with specific host failure

2002-02-25 Thread Marek Wysmulek
Are you using the Debian mysql-server package? If so, then check out your /etc/mysql/my.cnf file to see that networking is enabled. It seems to be disabled BUT how to enabled it ? Remove the skip-networking entry. Jeremi youre the best ;-)). Thanks a lot. --

Delphi, ADO and SQL

2002-02-25 Thread Victoria Reznichenko
Pierre, Sunday, February 24, 2002, 10:54:38 PM, you wrote: PdP Don't know if this is the right forum, but you can always flame me if PdP I'm wrong :-) PdP I tried using the mySQL OLEdb (ADO) driver with Delphi. ALthough I can PdP get a data connection and see the table names, the field

Re: MySQL 4.x Timeline

2002-02-25 Thread Anthony W. Marino
On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote: Hi Anthony, On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote: On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm

Re: MySQL TODO List Question.

2002-02-25 Thread Sinisa Milivojevic
Jeremy Zawodny writes: Why is porting MySQL to BeOS still on the TODO list? The OS is esentially dead, right? Just wondering... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL

Re: connection with specific host failure

2002-02-25 Thread Jeremy Zawodny
On Mon, Feb 25, 2002 at 01:48:13PM +0100, Marek Wysmulek wrote: (Hmmm. Zawodny Are you related with a polish family ? - I'm polish too ;- My grandparents came to the United States from Poland sometime around 1910, I believe. I'm 100% Polish, but cannot speak the language. Glad

Re: MySQLGUI Problem

2002-02-25 Thread Sinisa Milivojevic
Rex Yuan writes: Hello, When I tried to run mysqlgui, this is the error message that I received: can't connect to local MySQL server trough socket (111) I've checked and created all the client files. What does it mean? How can I correct it? MySQL server is up and running. Thank

OT: Installing QT client libraries

2002-02-25 Thread David Ayliffe
Hello all forgive me for posting off topic (again - that's only two!) I need to install the QT 2.2.2 client libraries on a Linux Mandrake 7.1 machine. I have created this app using Borland's delphi/kylix combo and it runs fine on my LM 8.1 machine (it must have qt installed by default maybe).

www-mysql

2002-02-25 Thread Marek Wysmulek
Dear all. Have anyone practice in www-mysql package ? I've installed apache, www-mysql. And so ? What next. Marek Wysmulek. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

upgrade ver. 3.22.32 to 3.23.41

2002-02-25 Thread Richard Reina
I am upgrading from MySQL ver. 3.22.32 to 3.23.41. I have installed ver. 3.23.41 on a new server which I will eventually use to replace my old server that's running 3.22.32. I have tar'ed and ftp'ed the datbases files over to the new server. When I copy them over to the table directory (

Re: Mysql dies with Signal 11

2002-02-25 Thread Sasha Pachev
On Saturday 23 February 2002 05:34 pm, you wrote: (gdb) thread 1 [Switching to thread 1 (process 31905, thread 1)] #0 ?0x82011ce in memcpy () (gdb) bt #0 ?0x82011ce in memcpy () #1 ?0x82a33c0 in mysql_bin_log () #2 ?0x80b7cd8 in ha_commit_trans () #3 ?0x8076e24 in mysql_execute_command ()

Do i need licence for using mysql in my project ?

2002-02-25 Thread Ireneusz Piasecki
Hi guys. I made system. it is based on php+apache+mysql. This system i would like to sell a Company. Must i or this Company buy any licence from mySQL AB to legally use mysql with apache+PHP in this system ? I need quickly an answer. Regards. I. Piasecki -- Okresl Swoje potrzeby - my

mysql and java

2002-02-25 Thread Bill Fogarty
Hi, Does anyoone know how to connect to mysql from a Java application in windows 2k? Any help would be greatly apppreciated. I may be writing to the wrong list, anyone got any suggestions of where i could get help with this online. Cheers, Bill

Multiple replace into a SQL query

2002-02-25 Thread Xavier Prélat [webcentric]
Hi , I'm trying to perform a SQL query containing several calls to mySQL replace functions. On the same basis that this : SELECT replace(message, @TITLE@, title) FROM ** in this case, message and title are 2 fiels of the the same table I want to do something like this : SELECT

Re: mysql and java

2002-02-25 Thread Steve Suehring
Hello, You'd probably want JDBC. http://www.mysql.com/downloads/api-jdbc.html Steve On Tue, Feb 19, 2002 at 03:17:49PM +, Bill Fogarty wrote: Hi, Does anyoone know how to connect to mysql from a Java application in windows 2k? Any help would be greatly apppreciated. I may be writing

Re: mysql 3.23.49-1 rpm fails with redhat 7 thu 7.2

2002-02-25 Thread Trond Eivind Glomsrød
[EMAIL PROTECTED] writes: The latest rpms for mysql 3.23.49 produce a signal 4 error when attempting to run the installed mysql server. on all our servers running redhat 7 thru 7.2. Obviously this can't be a kernel 2.2.x issue, since 7.2 is on 2.4.x. I've tried multiple installs now

upgrade ver. 3.22.32 to 3.23.41

2002-02-25 Thread Egor Egorov
Richard, Monday, February 25, 2002, 6:08:53 PM, you wrote: RR I am upgrading from MySQL ver. 3.22.32 to 3.23.41. I have installed RR ver. 3.23.41 on a new server which I will eventually use to replace my RR old server that's running 3.22.32. I have tar'ed and ftp'ed the RR datbases files

Do i need licence for using mysql in my project ?

2002-02-25 Thread Egor Egorov
Ireneusz, Monday, February 25, 2002, 5:08:56 PM, you wrote: IP Hi guys. IP I made system. it is based on php+apache+mysql. IP This system i would like to sell a Company. IP Must i or this Company buy any licence from mySQL AB to legally use mysql IP with apache+PHP in this system ? IP I need

Problem

2002-02-25 Thread Ricardo Javier Aranibar León
I have a problem, when I try to connect to the Data Base [root@hvserver_tja bin]# mysql bash: mysql:command not found [root@hvserver_tja bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through '/tmp/mysql.sock' (2) [root@hvserver_tja bin]# ./mysql -h hvserver_tja -u -p Enter

Re: Problem

2002-02-25 Thread Steve Suehring
Hi, Are you sure that the MySQL server is running? If so, maybe look for the mysql.sock file (find / -name mysql.sock) ./mysql -u username -p --socket=/location/of/socket.sock Steve On Mon, Feb 25, 2002 at 04:38:59PM +, Ricardo Javier Aranibar Le?n wrote: I have a problem, when I

Help Restoring a MySQLdumped database...????

2002-02-25 Thread Miretsky, Anya
How do I restore a Mysqldump of a database? I've found documentation on how to backup a db and have done but I can't figure out how to create a new db from my dump file? Please help. thanks Anya Miretsky Computer Technology Dept. Brooklyn Botanic Garden 1000 Washington Avenue Brooklyn, NY

Problem

2002-02-25 Thread Victoria Reznichenko
Ricardo, Monday, February 25, 2002, 6:38:59 PM, you wrote: RJAL I have a problem, when I try to connect to the Data Base RJAL [root@hvserver_tja bin]# mysql RJAL bash: mysql:command not found RJAL [root@hvserver_tja bin]# ./mysql RJAL ERROR 2002: Can't connect to local MySQL server through

Re: Help Restoring a MySQLdumped database...????

2002-02-25 Thread Georg Richter
On Monday, 25. February 2002 17:47, Miretsky, Anya wrote: How do I restore a Mysqldump of a database? I've found documentation on how to backup a db and have done but I can't figure out how to create a new db from my dump file? Please help. 1) Create an empty db yourdb 2) mysql -uuser

RE: Problem

2002-02-25 Thread Kevin-Neil Klop
Also, check permissions on the mysql directories to make sure that MySql can actually write into it and that other people can read the mysql.sock file. -Original Message- From: Steve Suehring [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 8:42 AM To: Ricardo Javier Aranibar

MySQLGUI

2002-02-25 Thread Steve Traver
FYI- My Environment: - Windows NT 4.00.1381 - MySQL Ver 11.15 Distrib 3.23.43, for Win95/Win98 (i32) Program will not allow me to create or edit tables. Also, bombs when I try to create a database. sT - Before

Re: MySQLGUI

2002-02-25 Thread Sinisa Milivojevic
Steve Traver writes: FYI- My Environment: - Windows NT 4.00.1381 - MySQL Ver 11.15 Distrib 3.23.43, for Win95/Win98 (i32) Program will not allow me to create or edit tables. Also, bombs when I try to create a database. sT Table creation and editing is not done ... If you

max_data_length?

2002-02-25 Thread Eric Mayers
Why is the max_data_length portion of Show table status ... for innodb tables null? Is there a way to get this value? I want to use this and data_length to display a % of space used statistic. Eric Mayers Software Engineer I Captus Networks sql,query

mysql user table is read only by root

2002-02-25 Thread Ari Kahn
Let me try again. I recently installed mysql. I need to change the root password. However, whatever method I try mysql tell me that the user table is read only. mysqladmin -u root password 'mynewpassword' mysqladmin: unable to change password; error: 'Table 'user' is read only' Or mysql

Paul DuBois - Thank You

2002-02-25 Thread Craig Westerman
for the EXCELLENT index in your MySQL book. I developed several questions this morning and was able to find answers to all easily using the index in your book. Much appreciated. Craig [EMAIL PROTECTED] - Before posting,

Re: mysql user table is read only by root

2002-02-25 Thread Rodney Broom
From: Ari Kahn [EMAIL PROTECTED] However, whatever method I try mysql tell me that the user table is read only. It sounds to me like root doesn't have sufficient permissions granted to write to that table, but I could be wrong. There's something in the docs about accessing after you've

Re: Re: Paul DuBois - Thank You

2002-02-25 Thread Paul DuBois
sql,query At 11:56 -0600 2/25/02, Craig Westerman wrote: for the EXCELLENT index in your book. I developed several questions this morning and was able to find answers to all easily using the index in your book. Much appreciated. Craig [EMAIL PROTECTED] Thanks, I'm glad it was useful.

auto increment problem

2002-02-25 Thread Chetan Lavti
hi, I creating a table where I am using one field as Auto Increment. I want to know two things or rather I want to do to thinks for the same column 1. When I am inserting the values and the Query fails, the increment should not took place and 2. When I delete a particular row from the table

Re: starting mysqld on boot (Mac OS X 10.1.3)?

2002-02-25 Thread John McCauley
- Create a dir in /Library/StartupItems called mysql - make a shell file called mysql containing (and make it executable)(this assumes that user-id stuff is in /etc/my.cnf): #!/bin/sh . /etc/rc.common if [ ${mysql:=-NO-} = -YES- ]; then ConsoleMessage Starting MySQL Server cd

3.23.49 and still can't kill mysql in OS X

2002-02-25 Thread John McCauley
Compiled MySQL 3.23.49 from source and I still can't kill the server without -9 in OS X 10.1.3 sigh... -- John McCauley CTGi, Oakton, VA USA - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: max_data_length?

2002-02-25 Thread Keith C. Ivey
On 25 Feb 2002, at 10:03, Eric Mayers wrote: Why is the max_data_length portion of Show table status ... for innodb tables null? Is there a way to get this value? I want to use this and data_length to display a % of space used statistic. I think you're misunderstanding what the

Re: mysql user table is read only by root

2002-02-25 Thread Benjamin Pflugmann
Hi. On Mon, Feb 25, 2002 at 11:22:22AM -0700, [EMAIL PROTECTED] wrote: From: Ari Kahn [EMAIL PROTECTED] However, whatever method I try mysql tell me that the user table is read only. It sounds to me like root doesn't have sufficient permissions granted to write to that table, but I

RE: Paul DuBois - Thank You

2002-02-25 Thread savaidis
Is there any electronic version of this book (e-book)? Because it will be very helpfull if it has an index-content like PDF docs. And why pay for paper? We live on 2000 no? Makis -Original Message- From: Craig Westerman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002

RE: auto increment problem

2002-02-25 Thread Rick Emery
1. The auto_increment will not occur on failure. Try it yourself to verify; I did. 2. When you delete a row, you DO NOT WANT the auto-increment to re-number. You SHOULD have gaps. Why? Because if the auto_incremented field is a primary key, and there are other tables who fields refer to that

Re: auto increment problem

2002-02-25 Thread Paul DuBois
At 0:44 +0530 2/26/02, Chetan Lavti wrote: hi, I creating a table where I am using one field as Auto Increment. I want to know two things or rather I want to do to thinks for the same column 1. When I am inserting the values and the Query fails, the increment should not took place and 2. When I

Re: auto increment problem

2002-02-25 Thread Rodney Broom
From: Chetan Lavti [EMAIL PROTECTED] 1. When I am inserting the values and the Query fails, the increment should not took place and It doesn't. 2. When I delete a particular row from the table there should not be any gap in the auto increment sequence. This doesn't work. Although you

RE: max_data_length?

2002-02-25 Thread Eric Mayers
Okay, this is clearly not what I want. I'm looking for a method to see how much space a table is using compared to the total amount of space available. Is there a way to do this (with innodb tables)? Eric Mayers -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]

Connecting to mysql Server

2002-02-25 Thread Oladejo, Tokunboh
Hi All, Does anyone have an idea why I am getting an error Fatal error: Call to undefined function: mysql_connect() in /var/www in this PHP function mysql_connect(localhost,root,password); Thanx All - Before posting,

Re: Do i need licence for using mysql in my project ?

2002-02-25 Thread Benjamin Pflugmann
Hi. On Mon, Feb 25, 2002 at 04:08:56PM +0100, [EMAIL PROTECTED] wrote: Hi guys. I made system. it is based on php+apache+mysql. This system i would like to sell a Company. Must i or this Company buy any licence from mySQL AB to legally use mysql with apache+PHP in this system ? This is

RE: Paul DuBois - Thank You

2002-02-25 Thread savaidis
I don't take work out of office, NEVER! :) Is not possible to copy e-book either, I think! (PS: You're so sick to read work books at home ? :) Makis -Original Message- From: Georg Richter [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 9:52 PM To: savaidis; 'MySQL

Re: Connecting to mysql Server

2002-02-25 Thread Jeremy 'Circ' Charles
On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote: Does anyone have an idea why I am getting an error Fatal error: Call to undefined function: mysql_connect() in /var/www That's the error you get if you try to call mysql_connect() but don't have the MySQL support compiled in to the PHP module.

RE: ODBC and SystemDSN?

2002-02-25 Thread Carl McNamee
sql,query Is it possible to setup a system DSN with myodbc? We have several databases that need to be linked together for Crystal Reports to use. So far I have not figured out how to do this. TIA! Carl McNamee Systems Administrator Billing Concepts (210) 949-7282

recover lost index

2002-02-25 Thread Brian DeFeyter
sql,query Does anyone know how / if it's possible to recover a lost .MYI file if I still have the .MYD and .frm files? It seems like it should be possible but I haven't found any documentation on it yet. Thanks, - bdf -

Re: Connecting to mysql Server

2002-02-25 Thread Oladejo, Tokunboh
Thanx all, I am new to this and still learning, when I installed Linux, I did not have to do anything to PHP however I did just get the mysql rpm and install without any special configuration, Does anyone have an idea of any article that will help me recompile my php with my apache. Thanx

Re: Linux optimizations for MySQL

2002-02-25 Thread David Turner
If you do that don't you run a greater risk of corruption of the datafiles if the host unexpectedly goes down? Dave On Mon, Feb 25, 2002 at 01:07:06PM -0800, Steven Roussey wrote: I was reading an article on speeding up Oracle on Linux(1) and thought their two optimizations for Linux would

RE: Paul DuBois - Thank You

2002-02-25 Thread Paul DuBois
At 21:35 +0200 2/25/02, savaidis wrote: Is there any electronic version of this book (e-book)? One of the chapters (the C API chapter) is online at the publisher's site, and there are some other pages available at Amazon. All of these are PDF format. There are pointers to this material at the

RE: InnoDB question

2002-02-25 Thread Demirchyan Oganes-AOD098
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

RE: InnoDB question

2002-02-25 Thread Eric Mayers
Oganes, It sounds like what you want is row-level-locking. This is a feature of InnoDB tables. It allows users to write to a table while other users are reading from the same table. Of course, they cannot read and write the same rows simultaniously. Have you tried to do this and had some

RE: Paul DuBois - Thank You

2002-02-25 Thread Paul DuBois
At 16:09 -0600 2/25/02, Paul DuBois wrote: At 21:35 +0200 2/25/02, savaidis wrote: Is there any electronic version of this book (e-book)? One of the chapters (the C API chapter) is online at the publisher's site, and there are some other pages available at Amazon. All of these are PDF format.

SET field=field+1 no longer works?

2002-02-25 Thread Tyler Longren
Hello, I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until 3.23.49 was released. After upgrading to 3.23.49, queries like this don't work: UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND password='blah'; Normally, that would increment the value in

?informix database convert to MySQL?

2002-02-25 Thread Jessica Lee
Hi, I'm new to MySQL and this list. ^_^ My question is: What's the best and fastest way to convert an Informix database to MySQL? Thanks, Jessica - Before posting, please check: http://www.mysql.com/manual.php (the

MySQL php - assigning date variables

2002-02-25 Thread Craig Westerman
$query = mysql_query(SELECT * FROM table WHERE date LIKE '%. $query .%'); // returns all items in database $query = 2001-01-01 mysql_query(SELECT * FROM table WHERE date LIKE '%. $query .%'); // returns all rows that have 2001-01-01 as the date What is proper way to define a variable to

Dumping a MySQL DB Out to Access

2002-02-25 Thread Luis Gonzalez
Hi, First of all, I'm not an expert at all, I'm just a newby who started a week ago,,, But I guess that the answer is very simple: Why don't you link your MySQL database to Access thru MyODBC? This way your customers could use Access as the front-end, while MySQL is the back-end where the data

Re: InnoDB question

2002-02-25 Thread Jeremy Zawodny
On Mon, Feb 25, 2002 at 02:44:45PM -0800, Eric Mayers wrote: Oganes, It sounds like what you want is row-level-locking. This is a feature of InnoDB tables. It allows users to write to a table while other users are reading from the same table. Of course, they cannot read and write the

CPU intensive query

2002-02-25 Thread Tauren Mills
I am hosting websites that use the mysql database. One of my customers has a query that they run occasionally that really bogs down the entire server. The load sometimes jumps up into the double digits (on a Red Hat 6.2 server). Here is their query: select count(*) from aptreviews,

Beginner needs help

2002-02-25 Thread Bob Rea
I'm getting a syntax error when I try to insert more two sets of values into a table. I have looked at the manual on the insert statement, and don't see what is wrong. Can someone tell me. Here's the info. mysql describe book;

RE: MySQL php - assigning date variables

2002-02-25 Thread Daniel Rosher
SQL statement are: What is proper way to define a variable to include all dates newer than 1995-01-01? $query = ??? select * from table where date '1995-01-01' What is proper way to define a variable to include all dates older than 1995-01-01? $query = ??? select * from table where

Re: MySQL php - assigning date variables

2002-02-25 Thread Georg Richter
On Tuesday, 26. February 2002 00:18, Craig Westerman wrote: What is proper way to define a variable to include all dates newer than 1995-01-01? What is proper way to define a variable to include all dates older than 1995-01-01? What is proper way to define a variable to include all

Re: Beginner needs help

2002-02-25 Thread Paul DuBois
At 15:33 -0800 2/25/02, Bob Rea wrote: I'm getting a syntax error when I try to insert more two sets of values into a table. I have looked at the manual on the insert statement, and don't see what is wrong. The error message indicates that the problem is at the word values. The problem with

using mysql as a perl module

2002-02-25 Thread daniel
i'm trying to keep my code nice and clean and one of the ways i'm doing this is keeping all the sql request code in one module the problem is: it's not working. basically, all i really want is a subroutine call in my cgi that looks like this: my $dbh = DBI-connect('DBI:mysql:xx',

Re: Beginner needs help

2002-02-25 Thread Georg Richter
On Tuesday, 26. February 2002 00:33, Bob Rea wrote: I'm getting a syntax error when I try to insert more two sets of values into a table. I have looked at the manual on the insert statement, and don't see what is wrong. ERROR 1064: You have an error in your SQL syntax near 'values(

Re: Beginner needs help

2002-02-25 Thread Nathan
Get rid of the second values. mysql INSERT into book( - isbn, - title, - authlname, - authfname, - publisher, - pubdate, - dewey, - lcnum - ) - values ( - '1-56592-434-7', - 'MySQL mSQL', - 'Yarger', - 'Randy Jay', - O'Reilly, -

RE: Beginner needs help

2002-02-25 Thread Daniel Rosher
Change it to INSERT into book( isbn, title, authlname, authfname, publisher, pubdate, dewey, lcnum ) values ( '1-56592-434-7', 'MySQL mSQL', 'Yarger', 'Randy Jay', O'Reilly, null, null, null ),

synopsis of the problem (one line)

2002-02-25 Thread nick hoffman
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:nick hoffman Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class:

Re: CPU intensive query

2002-02-25 Thread Michael Bacarella
Seems hard to answer without asking more questions, but some basic questions first: Is complex_id indexed in both tables? (SHOW INDEX FROM aptreviews) Have you tried EXPLAIN'ing the query to see if maybe the index isn't being used? Questions: That the queries are stuck on

RE: Beginner needs help

2002-02-25 Thread Eric Mayers
Bob, This is just a guess, but looking at http://www.mysql.com/doc/I/n/Insert_speed.html it appears that the way to do multiple inserts looks like: INSERT INTO a VALUES (1,23),(2,34),(4,33); a(col1, col2).. Perhaps multiple inserts requires that you specify all columns in the order that the

RE: Dumping a MySQL DB Out to Access

2002-02-25 Thread Todd Williamsen
The problem is that the DB resides on a Unix box and he access it through a cgi program -Original Message- From: Luis Gonzalez [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 5:18 PM To: [EMAIL PROTECTED] Subject: Dumping a MySQL DB Out to Access Hi, First of all, I'm not

RE: Linux optimizations for MySQL

2002-02-25 Thread Steven Roussey
I assume you are talking about bdflush only at 100% (I'm actually trying 90%). Thing is, all our tables are constantly changing. Unless the server crashes just after a flush tables command, the tables are likely to get corrupt anyhow. The data altering flow of queries is over 1000/s at the

Re: Linux optimizations for MySQL

2002-02-25 Thread David Turner
I thought there was a problem with the datafile corruption if the cache was lost when you chattr a file. That the file would become corrupt. Dave On Mon, Feb 25, 2002 at 03:55:23PM -0800, Steven Roussey wrote: I assume you are talking about bdflush only at 100% (I'm actually trying 90%). Thing

SQLException error code is different

2002-02-25 Thread Becky McElroy
Hello, I'm running the same code in 2 different environments, but both access the same MySQL database (3.23.47 Max, running on Solaris) and both use mm.mysql-2.0.7. Environment 1: IBM VisualAge for Java, which has JDK 1.2.2, running on a Windows machine Environment 2: JDK 1.3.1 running on Red

RE: Paul DuBois - Thank You

2002-02-25 Thread Marjolein Katsma
Paul, At 23:09 2002-02-25, you wrote: One of the chapters (the C API chapter) is online at the publisher's site, and there are some other pages available at Amazon. All of these are PDF format. There are pointers to this material at the book's companion site: http://www.mysql.com/mysql-book/

RE: Paul DuBois - Thank You [actually brain lock]

2002-02-25 Thread Paul DuBois
Is there any electronic version of this book (e-book)? One of the chapters (the C API chapter) is online at the publisher's site, and there are some other pages available at Amazon. All of these are PDF format. There are pointers to this material at the book's companion site:

RE: CPU intensive query

2002-02-25 Thread Tauren Mills
Thanks for the assistance! Seems hard to answer without asking more questions, but some basic questions first: Is complex_id indexed in both tables? (SHOW INDEX FROM aptreviews) Yes, they are: mysql SHOW INDEX FROM aptreviews;

OpenOffice MySQL

2002-02-25 Thread A. Fiesser
I'm trying to port some stuff to OpenOffice.org from MS-Office. Currently we store a lot of stuff in MS-Access 2000. I figured out how to connect OO to a MySQL DB via MyODBC 3.51. But there are a few problems. 1) I need filtering by date-fileds. Many of our tables have the fields

Problems connecting MS Access to Mysql Server

2002-02-25 Thread delz
Hi All, I'm trying to connect ms access to a mysql server that I installed on my Linux machine. I already downloaded the MyODBC 2.50 which is required to connect to mysql using ms access. My problem is when I try to connect the database in ms access to the mysql server I get the error Host not

HELP: MySQL

2002-02-25 Thread wally liau
Hi there, I have a postgreSQL query like (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) and I'd like to have an equivalent MySQL query. Your help would be greatly appreciated. The reason is that we were running Java

RE: MySQL php - assigning date variables

2002-02-25 Thread Craig Westerman
SQL statement are: What is proper way to define a variable to include all dates newer than 1995-01-01? $query = ??? select * from table where date '1995-01-01' What is proper way to define a variable to include all dates older than 1995-01-01? $query = ??? select * from table where

  1   2   >