Re: Needing help about PHP+mysql on RedHat 9.

Mario Miyojim wrote: I am trying to revive an existing LAMP system. I recently installed RedHat9. I had several LAMP applications working under RedHat 7.1, but now they don't function properly. For instance, I have many scripts that use the construct, but they are not working as they should. I tr

Needing help about PHP+mysql on RedHat 9.

I am trying to revive an existing LAMP system. I recently installed RedHat9. I had several LAMP applications working under RedHat 7.1, but now they don't function properly. For instance, I have many scripts that use the construct, but they are not working as they should. I tried to get help from

java.net.SocketException: errno: 48, error: Address already in use

Hi, I'm getting the following error while connecting to a MySQL databases using JDBC. Any clues?? Thanks, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Preventing data collisions

On Mon, Nov 17, 2003 at 11:06:39PM -0600, David Dice wrote: > I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find > an answer. > > How do I prevent data collision in the following scenario: > User A and User B are examining the same data (say a customer's name and

Preventing data collisions

I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find an answer. How do I prevent data collision in the following scenario: User A and User B are examining the same data (say a customer's name and address). User A modifies something (say the customer's phone number

Column type

Hi I have a .txt file that is loaded into my table. This is done using LOAD DATA INFILE One of the columns data is a unix timestamp from the .txt file. The column is called begin. I have created the column as a varchar before and then converted the date using FROM_UNIXTIME(), so it can be rea

Re: mysql: not found

- Original Message - From: "Kelley Prebil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 9:33 PM Subject: mysql: not found > When I try to start the database with : > > mysql -h host -u user -p > > I get the response : > > mysql: not found > > What does thi

Re: Saving a table to a text file

mysqldump is a program like mysql not a command within mysql. Bernard On Monday 17 November 2003 21:46, Lay Hoon Tan wrote: > I keep on getting errors for saving table to an external file. I think > there is something wrong with the syntax. Could someone help me to correct > it ? > > mysql> mysql

performance problems, maintence on one table slows down others

Hi, I have a performance issue I've tried resolving and I can't get rid of it. Basically I have a database called lobby that any queries to it must be as fast as possible inserts, and selects. It must do about 60 queries a second with no queries taking more then 50ms. I also have another databa

Saving a table to a text file

I keep on getting errors for saving table to an external file. I think there is something wrong with the syntax. Could someone help me to correct it ? mysql> mysqldump -r database table1; Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

mysql: not found

When I try to start the database with : mysql -h host -u user -p I get the response : mysql: not found What does this mean? Installation went smoothly as far as I could tell. Also, when I try to start the database with : bin/mysqld_safe --user=mysql & It starts the mysqld daemon from the ri

RE: Please help DB Error: unknown error

I see the only message "DB Error: unknown error". Even when I run mysqld.exe with --log and --error-log options, I still cannot get a more descriptive error message. I guess the problem is because of the number of joins is too large or the number of *temporary* rows is too large. But I don't k

Re: [Mysql] mysqld ended

On Nov 17, 2003, at 4:13 PM, Matthew Hagen wrote: I executed the command: fuser -n tcp 3306 and it returned: 3306/tcp: 187 I then ran ps -ef to find what program was using this port and I found it was: root 187 1 0 Nov13 ?00:00:00 /usr/sbin/inetd Is it ok to ki

RE: [Mysql] mysqld ended

I executed the command: fuser -n tcp 3306 and it returned: 3306/tcp: 187 I then ran ps -ef to find what program was using this port and I found it was: root 187 1 0 Nov13 ?00:00:00 /usr/sbin/inetd Is it ok to kill this process ? If not, is there a way to spec

Re: row-level locking question...

On Mon, Nov 17, 2003 at 10:10:52AM -0500, Andre Charbonneau wrote: > Hi, > > Let say that I have the following transaction: > > 1. Read value v1 from table t1. > 2. Do some computation using v1. > 3. Update value v2 from table t2. > > If in the above I don't want any other concurrent transaction

Re: Some help with a complex query

* Elisenda [...] > So, the good way to write joins will be as follows, doesn't it? > > FASE.SQL_ID_CE=CA.CA_ID_CE AND > FASE.PR_PP_ID_COORD=PP.PP_ID_PP AND > CA.CA_ID_CE=CE.CE_ID_CE AND > FASE.AU_PR_AULA=AU.AU_AULA Those are the exact same criteria as you had, only in a different order, isn't it?

Load Data Infile confusion

This one has had me scratching my head all afternoon. I have a comma delimited text file that I am using to "import" data from a legacy system into a MyISAM table. My server is 4.0.16 as is my client. Both run on Redhat 8.0. An example line of imput looks like "041502f","1","25.00","$","25.0

RE: replace query + RTFM?

Worked like a dream Dan Thanks Paul for being patient :) Thank you Andrew >-Original Message- >From: Dan Greene [mailto:[EMAIL PROTECTED] >Sent: 17 November 2003 21:27 >To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista >Subject: RE: replace query + RTFM? > > >you need to tell mysql what f

Re: MySQL on Win32 vs Linux ?

Hi, As I remember : MySQL's programmers use windows tools for developing. You can use Win32-MySQL without any problem. But I suggest APACHE for PHP! best regards özgür YÖNSIS ltd, Istanbul - Original Message - From: "Paul Fine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday,

Re: replace query + RTFM?

On Monday 17 November 2003 01:18 pm, Andrew wrote: > Can someone kindly tell me what I doing wrong and help with this query? > > I want to replace / update the text for every record within table items > field ItemDescription. This is what I have so far and its isn't corroect :( > > UPDATE items SET

RE: replace query + RTFM?

you need to tell mysql what field to equate to the value in your where clause: update items set ItemDescription = '' where ItemDescription = '' replacing the < > items with the text you have below > -Original Message- > From: Andrew [mailto:[EMAIL PROTECTED] > Sent: Monday, November

RE: replace query + RTFM?

Can someone kindly tell me what I doing wrong and help with this query? I want to replace / update the text for every record within table items field ItemDescription. This is what I have so far and its isn't corroect :( UPDATE items SET ItemDescription='A-Z Business Directory Please call 0870

Re: [Mysql] mysqld ended

On Nov 17, 2003, at 12:40 PM, <[EMAIL PROTECTED]> wrote: Hi, I am installing a binary version of mysql 4.0.7, but I cannot get the mysql daemon running. Mysqld ends right after I start it up. I attached the command I use and the output. I also cut and pasted the output from the log file. [...]

RE: [MySQL] mysqld ended

do a ps -ef | grep mysql (or the equivalent for your system) and see if you have any other mysql daemons running? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 2:40 PM To: [EMAIL PROTECTED] Subject: [Mysql] mysqld ended Hi, I am ins

[Mysql] mysqld ended

Hi, I am installing a binary version of mysql 4.0.7, but I cannot get the mysql daemon running. Mysqld ends right after I start it up. I attached the command I use and the output. I also cut and pasted the output from the log file. I am on a Sun Sparc running Debian. Any help would greatly be a

RE: Simple comparison operator failure

Hello All, Upon further review, my question involving the unexpected comparison operator behavior IS discussed in the documentation, specifically section A.5.7 "Problems with Floating-Point Comparison". My bad -- thought I'd checked everywhere. Doesnt' look like there's a great solution, th

Re: Merging duplicate rows

Hi Nathan, you can use a group by, like this: select from table group by Put this result in a separate table, delete the data from the old table and put the the merged rows from the separate table into it. I tried using a DELETE with a subquery and a group-by, but MySql is not capable of hand

RE: Reading and Executing a source...

At 2:42 PM -0500 11/17/03, Ola Ogunneye wrote: Thanks Paul, Just to be crystal clear, at the mysql prompt, I will typesource stations.sql \. E:\Apache\apache2\htdocs\public_html\weather\stations.sql Looking something like this: mysql>source stations.sql \. E:\Apache\apache2\htdocs\public_html

Re: Birthday calendar

Hi Olaf, try something like this: AND gebdatum between now() and date_add(now(),interval 7 day) However, I have no idea if this can be done with 3.23.49a. -- Peter Sap. - Original Message - From: "Olaf van Zandwijk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17,

RE: Reading and Executing a source...

Thanks Paul, Just to be crystal clear, at the mysql prompt, I will typesource stations.sql \. E:\Apache\apache2\htdocs\public_html\weather\stations.sql Looking something like this: mysql>source stations.sql \. E:\Apache\apache2\htdocs\public_html\weather\stations.sql Or am I not supposed t

Re: Subselect Problem

At 2:28 PM -0500 11/17/03, Peter J. Krawetzky wrote: Could someone please tell me what is wrong with this query: select * from personnel where dept_id not in (select dept_id from attendance_respond) I keep getting a 1024 error message. It looks pretty straightforward to me. I am running 4.0.16 o

Subselect Problem

Could someone please tell me what is wrong with this query: select * from personnel where dept_id not in (select dept_id from attendance_respond) I keep getting a 1024 error message. It looks pretty straightforward to me. I am running 4.0.16 on Redhat Linux 8. -- MySQL General Mailing List

RE: Backslash and full text searches

Matt, Yes, database could be cleaned with a query, but I don't even want to think about the code problem. I was being hyperbolic with the "500,000"; it's actually more like 50,000 lines of code - but still, who wants to change 50,000 lines of code. And yes, it's PHP. However, as an update, I di

RE: replace query + RTFM?

>Looks to me like you want to use UPDATE instead. Specify a WHERE clause >that identifies the rows you want to update, and in the SET clause specify >the new value for the description column. > >To pre-flight your UPDATE, you can write a SELECT that has the same WHERE >clause. This will show you

RE: User Variables

At 6:45 PM + 11/17/03, Bruno Mustone wrote: Hmmm they seem to work in version 3.23.57. Given that they were introduced in 3.23.6 (as stated below), that is not surprising. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 17 November 2003 18:38 To: Bruno Mustone; [EM

RE: Reading and Executing a source...

At 10:28 AM -0500 11/17/03, Ola Ogunneye wrote: Can you elaborate please? Like I said, the sql file I am executing is in E:\Apache\apache2\htdocs\public_html\weather I see that you typed \ c>\loadfile.sql - Please explain. I really am new to this. No, he typed \., not \, and c:, not c>. If you cha

RE: replace query + RTFM?

At 6:39 PM + 11/17/03, Andrew wrote: I understand what the manual is saying and I was asking for confirmation that what I was doing was indeed the right way forward, instead of going a head and potentially fucking up 2500 records! But alas it seems that people are repared to spend more time wr

RE: User Variables

Hmmm they seem to work in version 3.23.57. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 17 November 2003 18:38 To: Bruno Mustone; [EMAIL PROTECTED] Subject: Re: User Variables At 12:05 PM + 11/17/03, Bruno Mustone wrote: >Hi Guys, > >Do you know what version

Deleting tables?

I have created tables in mysql using a weblog. I now realize that I need to reinstall the plugin that I originally installed. Can someone tell me how to delete specific table from a database? I use phpmyadmin to manage mysql and I figured checking the check boxes next to the tables that I want to

RE: replace query + RTFM?

I understand what the manual is saying and I was asking for confirmation that what I was doing was indeed the right way forward, instead of going a head and potentially fucking up 2500 records! But alas it seems that people are repared to spend more time writing shite about reading manuals and rea

Re: User Variables

At 12:05 PM + 11/17/03, Bruno Mustone wrote: Hi Guys, Do you know what version user variables were introduced? I can't seem to get them working in 3.22 and yet they work in 3.23. They were introduced in 3.23.6. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysq

Re: The correct way to deal with name_1, name_2, name_3

- Original Message - From: "Paul Fine" <[EMAIL PROTECTED]> To: "'Stephen Fromm'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 11:49 AM Subject: RE: The correct way to deal with name_1, name_2, name_3 Thanks. I do mean " Do you mean one column for each name,

RE: replace query + RTFM?

Andrew, Please allow a small amount of grief to come from these lists... People are usually glad to help, and Mike sent the info that he knew to you. There is a certain amount of frustration that develops when people repeatedly ask questions of the mailing list that are clearly documented in

Simple comparison operator failure

I encountered a problem where a simple comparison operation seemed to fail. Has anyone else seen this? Take a simple table: a FLOAT(10, 2) b DOUBLE With data: +--+--+ | a| b| +--+--+ | 1.50 |1 | | 6.00 |4 | | 5.60 |4 | +--+--+ Then do a simp

RE: replace query + RTFM?

amazing, and you guys are errr intelligent!!! can't actually help but you can make an abbreviation for RTFM how fucking sad is that, what a bunch of pathetic losers. >-Original Message- >From: Rodolphe Toots [mailto:[EMAIL PROTECTED] >Sent: 17 November 2003 18:11 >To: [EMAIL PROTECTED] >Su

RE: replace query + RTFM?

Hi Mike I really appreciate you getting back to me so quickly :) Can I just clarify this becuse I have over 4000 records and not all of the records have anything in items - description but there are about 2500 records with this exact text-> A-Z Business Directory Please call 0116 27 960 41 for

Re: secure automated access (was "Re: Backing up all databases")

On Monday, November 17, 2003, at 11:51 AM, Michael Stassen wrote: I'm glad this worked for you, but now I'm confused. The manual clearly indicates the use of quotes around the password. See . The "typical user option file" starts with [clien

Re: replace query

On Monday 17 November 2003 18.04, Andrew wrote: > I have a MySQL database with records in a table that i would like to > replace. The table is > > items and the field is description. I would like to replace the existing > text within this filed with some new text. > > I did this before and it was

replace query

I have a MySQL database with records in a table that i would like to replace. The table is items and the field is description. I would like to replace the existing text within this filed with some new text. I did this before and it was successful but I have lost the query to do it :( Could som

replace field records

mysql test -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: secure automated access (was "Re: Backing up all databases")

Ed Leafe wrote: On Monday, November 17, 2003, at 02:58 AM, Michael Stassen wrote: cat $HOME/.my.cnf [client] password="rootpassword" /usr/local/mysql/bin/mysql --defaults-file=$HOME/.my.cnf ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Oh. That changes things.

RE: The correct way to deal with name_1, name_2, name_3

Thanks. I do mean " Do you mean one column for each name, in which case these would comprise 10 columns, most of which would have NULL most of the time?" Is this your suggestion in this case: Table 1 | blahblah | blah | blah | CustID (PK) | Table 2 | CustID (FK) | Name | Table 2 Sample Data

Errors compiling Mysql 4.0.16 on fedora core 1

Hello, I tried to compile the latest mysql rpm on fedora. The compilation is ok , but when I try to install the compiled MySQL-client rpm the system exits with: perl(the) is needed by MySQL-client-4.0.16-0 Does someone have an idea? Thanks Daniele -- MySQL

Birthday calendar

Hello, I want to have a query that returns the names from people that are having their birthday one of the coming 7 days. I currently have a buggy query that deals with this, but that query fails when the birthday is the next month, and we're now in the last week of the month before. Can anyon

Re: copy the result content from one db to another

This works just like doing it from table to table, just specify hte db insert into dbname.tablename select * from db1.tablename where id < 3; HTH Jeff

Re: The correct way to deal with name_1, name_2, name_3

- Original Message - From: "Paul Fine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 17, 2003 10:37 AM Subject: The correct way to deal with name_1, name_2, name_3 > Greetings, I would be greatful for any advice on the correct way to do this. > > If I have something

RE: copy the result content from one db to another

insert into ... select ... -Original Message- From: Dr M Karthikeyan [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 9:51 AM To: [EMAIL PROTECTED] Subject: copy the result content from one db to another I would like to copy the contents of result set by single command e.g.,

copy the result content from one db to another

I would like to copy the contents of result set by single command e.g., select * from db1 where id < 3; result 1 result 2 now how to write this results into another db without writing to a text file (outtext)... when both source and destination has the same structure thanks m.karthikeyan -

Re: MySQL on Win32 vs Linux ?

Running Win2K and the latest MySQL 4 release. I have a little more than half a billion rows in three databases and about 50 tables. For about six hours a day, MySQL is hammered like there's no tomorrow adding/deleting/updating millions of rows. No problems at all. I've been using MySQL for almost

RE: mysqldump query

Are you running on a Linux platform? File => .my.cnf Location => ~ Contents => line one: [client] line two: user=userName line three: password=userPassword Security => chmod 600 .my.cnf -Original Message- From: patrick kuah [mailto:[EMAIL PROTECTED] Sent: Monday,

The correct way to deal with name_1, name_2, name_3

Greetings, I would be greatful for any advice on the correct way to do this. If I have something dynamic, for example customer names where usually there are 1 or 2 unique customer names but possibly say up to 10, what is the "correct" design? For example I could simply create a table with name_1,

RE: mysqldump query

Hi Victor, Sorry...I'm not a SQL guy. Can advise me how to i procced with this??? Thanks :) From: Victor Pendleton <[EMAIL PROTECTED]> To: 'patrick kuah' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: mysqldump query Date: Mon, 17 Nov 2003 07:06:18 -0600 you could put the password in your .m

RE: MySQL on Win32 vs Linux ?

I have been developing with Windows2000, Apache, MySQL and PHP (WAMP ?) platform for about two years now and have had no problems. However, I have been deploying onto a Linux server so my observations may not be valid for your purposes. John Griffin -Original Message- From: Paul Fine [m

RE: Reading and Executing a source...

Can you elaborate please? Like I said, the sql file I am executing is in E:\Apache\apache2\htdocs\public_html\weather I see that you typed \ c>\loadfile.sql - Please explain. I really am new to this. Thank you >>> Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:56AM >>> \. c:\loadFile.sql

Re: MySQL on Win32 vs Linux ?

At 07:45 AM 11/17/2003, you wrote: Greetings. Can anyone comment on the stability of MySQL on Win32? Unfortunately I may have to use IIS for a project and am just wandering if I can expect the same sort of stability and performance using MySQL (and PHP) on a Windows Server. Paul, Someone d

Re: MySQL on Win32 vs Linux ?

> Greetings. Can anyone comment on the stability of MySQL on Win32? > Unfortunately I may have to use IIS for a project and am just wandering if I > can expect the same sort of stability and performance using MySQL (and PHP) > on a Windows Server. In two years of light but increasing use of MyS

RE: Database Dump

Swati, You can also use mysqldump to be part of the mechanism to move the database(s) from one computer to another. Something like: Prompt> mysqldump --add-drop-table databasename -uuserid -ppassword | mysql --host=your.new.host.IP databasename -uuserid -ppassword -Original Message-

myisamchk Error 22 WinServer 2003 Large table

Hello, I am following the advice of the manual when bulk loading a large table by turning off index builds before LOAD DATA INFILE. The load ends normally (73 GB). The mysamchk build of the indices fails: myisamchk: warning: Can't change size of indexfile, error: 22 myisamchk: error: 22 for r

row-level locking question...

Hi, Let say that I have the following transaction: 1. Read value v1 from table t1. 2. Do some computation using v1. 3. Update value v2 from table t2. If in the above I don't want any other concurrent transaction to read v2 until I'm done updating it, how should I put an exclusive lock on it? Us

RE: Error message problem

Yes there was a syntax error. I used an "and" instead of && in the where clause. However, my concern is that the error message was truncated. Jeff > -Original Message- > From: Victor Pendleton [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2003 9:53 AM > To: Jeff McKeon; [EMAIL

RE: Error message problem

Was there actually a syntax error? Can you please post the query? The display for the error message appears to be truncated. -Original Message- From: Jeff McKeon [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 8:44 AM To: [EMAIL PROTECTED] Subject: Error message problem I just

Error message problem

I just upgraded to Server version 4.0.15-standard, I just tried to do a query and got a syntax error but the error message is incomplete. ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where Remot

Re: MySQL on Win32 vs Linux ?

Paul: In my experience, MySQL on Win32 platforms is very stable. Of the 80+ customer systems we have running our applications in conjunction with MySQL, the vast majority are on Win32. The DB server needs to be properly tuned for the application and environment, but that is the case with RDBMS yo

php and passing implicit connection identifiers

The connection identifier returned by mysql_connect() need not be passed to calls to MySQL-related functions. What is the "scope" of this claim? In particular, if I open a connection and then call a function I wrote myself, which then calls a MySQL related function, can I still omit the connectio

RE: Reading and Executing a source...

\. c:\loadFile.sql -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:41 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Reading and Executing a source... The problem is that I was getting an error message. I am not at home right no

MySQL on Win32 vs Linux ?

Greetings. Can anyone comment on the stability of MySQL on Win32? Unfortunately I may have to use IIS for a project and am just wandering if I can expect the same sort of stability and performance using MySQL (and PHP) on a Windows Server. Thanks for any advice! -- MySQL General Mailing List

RE: Reading and Executing a source...

The problem is that I was getting an error message. I am not at home right now, and should have posted the message last night. However, my main question is trying to know based on what the instruction says: Using mysql - connect as your root or other privileged user connect to your geeklog datab

RE: [PHP-DB] TABLE_PRIV

table_privs is going to assign privileges at the individual table level grant select on database.tablename to user@'192.168.0.10' IDENTIFIED BY 'password' -Original Message- From: Nikos Gatsis [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:20 AM To: [EMAIL PROTECTED] Subject:

Re: Access denied error

"Shane Korosec" <[EMAIL PROTECTED]> wrote: > I have recently installed MySQL my mac running OS X 10.3 and can connect to > MySQL using the command: > /Library/MySQL/bin/mysql > However, once connected, I have tried to create a database and received the > error message: > ERROR 1044: Access denie

[PHP-DB] TABLE_PRIV

Hello List. Does anybody knows how to configure table_priv table of Mysql? I didn't find something in manual I have v. 3.23.41 in Linux Thanx Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problems retrieveing int unsigned fields

It seems that 4294967295, the max value for an unsigned int, is not large enough. Is there an issue with using bigint or storing the value in char format? -Original Message- From: John A. Sullivan III [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:18 AM To: [EMAIL PROTECTED]

RE: Reading and Executing a source...

What seems to be the problem? Are you getting an error message? If so can you post the message? The syntax is \. fileName -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:10 AM To: [EMAIL PROTECTED] Subject: Reading and Executing a source...

Re: secure automated access (was "Re: Backing up all databases")

> >> In the case of root cron jobs then, you need a .my.cnf readable only by >> root in root's home. It should include >> >> [client] >> password="mysql_root_password" > > This is incorrect, unless the double quotes are part of the password. > Removing them so that the entry reads: > > [clien

Re: secure automated access (was "Re: Backing up all databases")

>> >> Mac OS 10.2.3. Maybe Panther has an issue with the build? > > 10.2.3 is Jaguar, not Panther. Did you mean 10.3.x? As I said, I'm > running mysql 4.0.16 on Mac OS 10.2.8, and this works for me. I suppose > an issue with Panther is possible, though I'd be surprised if something > simple l

Problems retrieveing int unsigned fields

We are building a large GPL'd application to manage network security (firewalls, VPN, etc - http://iscs.sourceforge.net) using Trolltech's Qt and their database drivers to our MySQL backend. We originally thought this was a Qt problem but it now appears to be a MySQL problem. We st

Reading and Executing a source...

I am using a program that says I should use source to read in and execute a file. I tried using the direction in Mysql second edition I think on page 795 or something thereabout, source file_name, /. file_name I do not have the complete syntax, but what I did reesembled something like the above.

RE: mysqldump query

you could put the password in your .my.cnf file and change permissions so that only the MySQL user can read the file. -Original Message- From: patrick kuah [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 5:15 AM To: [EMAIL PROTECTED] Subject: mysqldump query Hi guys, I have co

RE: Access denied error

You need to connect as a privileged user. You should delete the anonymous account for security reasons. -Original Message- From: Shane Korosec [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 1:56 AM To: [EMAIL PROTECTED] Subject: Access denied error I have recently installed My

RE: Please help DB Error: unknown error

Can you please post the error? -Original Message- From: Thai Thanh Ha [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 8:10 PM To: '[EMAIL PROTECTED]' Subject: Please help DB Error: unknown error Hi all, I have a problem with my query on mySQL 4.0. DB Error: unknown error I do

RE: MySQL 4.0.16 stop working

Can you check to see what messages are logged in the error log? Did you install MySQL as a service? Is the service set to start up automatically? -Original Message- From: William IT [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 6:41 PM To: [EMAIL PROTECTED] Subject: Mysql 4.0.

Re: Grant privilege removed from root

"W. Bauer" <[EMAIL PROTECTED]> wrote: > > Getting confused in the mysqlcc as a [EMAIL PROTECTED], I managed > that I cannot grant privileges any more. Any hint how I can undo > that? If you still have privileges on the database 'mysql' you can set Grant_rpiv to 'Y' with UPDATE statement. -

datetime vs timestamp for speed

If most of my queries against a DB are goign to be related to when things happened/within a date range... would it be more efficient to use timestamps or datetime fields? I plan to index either column, as it will be in many where clauses. I'm currently still running 3.23.38 with plans to upgrade

Re: InnoDB Set-up

"Mulugeta Maru" <[EMAIL PROTECTED]> wrote: > My background is Micorosoft Access and SQL server. The InnoDB table type > gives me a much close option to move my databases. I found the database a > little complex and would like to know if there is a better step-by-step > explanation of setting up

User Variables

Hi Guys, Do you know what version user variables were introduced? I can't seem to get them working in 3.22 and yet they work in 3.23. Best regards, Bruno Mustone

Re: secure automated access (was "Re: Backing up all databases")

On Monday, November 17, 2003, at 02:58 AM, Michael Stassen wrote: cat $HOME/.my.cnf [client] password="rootpassword" /usr/local/mysql/bin/mysql --defaults-file=$HOME/.my.cnf ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Oh. That changes things. The error says "U

Database Commit transaction !!!!!

hi all, I am trying to insert data into MYSQL via a excel sheet. But the minute i disconnect ..the data disappears from the data base.. some how the transaction is not getting committed.. I am using ADO Recordset and USing both insert and Update for Data manipulation.. Do advise as to why this co

mysqldump query

Hi guys, I have configure a daily backup for mysql database. the problem is that i need to specifiy the password when using mysql mysqldump --all-databases --opt --password=1234567 >testing.sql how can i encypt this --password=1234567 Thanks patrick ___

Re: Bug? mysql replication mysql 4.0.16..

Peter Larsen <[EMAIL PROTECTED]> wrote: > > Replication does not happend if inserts (update not tested) is made without > "mysql_select_db("database", $connection); " (yes, I use php..). > > > Working: > mysql_select_db("database", $connection); > mysql_query("INSERT INTO table (text1, text2) V

Re: mysql error

"vikas kamble" <[EMAIL PROTECTED]> wrote: > > I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or > access database it's given me > following error. > > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (111) > > Please guide

mysql error

Hi, I Install R.H. 9.0 one dedicate pc but when i going restart mysql service or access database it's given me following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Please guide me what should i do. even i try to instal nushere tool o

  1   2   >