Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2002-04-02 Thread colin o
Hi Kathy, I don't have that file in my folder, but it still starts. Colin. To fix this i checked the hostname.err file in mysql/data. From looking at this i found the lines that gave me errors, i played around with these and ended up getting an error like 'the socket is already binded' or so

Re: CPU - hog / hangup with replication

2002-04-02 Thread Michael Zimmermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi list, Peter, thanks for the tip with gdb. At the moment I'm not able to reproduce the cpu-hog, I only have the backtrace of one such event. Situation was: After one or two updates of the master (and perhaps some "show slave status" or "show ma

Problem with Sun OS 5.8

2002-04-02 Thread Andrea Soracchi
Hello, I must installer mysql into a server with SPARC processor and Sun Os 5.8. Which is the correct version that I try to download from mysql site? Thanks in advanced. - Before posting, please check: http://www.mysql.com

regarding MySql boolean field/datatypes is there a equvilent bool

2002-04-02 Thread Chuck Amadi
Hi again i didn't get any feed back regarding MqSql boolean field/datatype i note that it is evident in version 4.1 my version is 3.23 ok. Plz advice, as there is nothing in the pdf.manual about bool (boolean true/false values) Only something is regards to MySql keywords bool. Thus i have use

Replication and transaction questions

2002-04-02 Thread Nico Sabbi
HI, I have two questions: 1) is there a way to tell my mysql master not to log failed executions, such as creation of existing tables, drop of inexistant databases etc? Each of these operations lock the slave, and I believe that it' conceptually wrong logging them, since they never took pla

Re: Begging for help.- Linux Box as back End - Front End M$ Access 2000

2002-04-02 Thread Chuck Amadi
Venu wrote: >>-Original Message- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >>Sent: Saturday, March 30, 2002 12:40 PM >>To: [EMAIL PROTECTED] >>Subject: Begging for help. >> >> >>Hi all, >> >>Begging for help. >> >>Newbie so please keep solutions as simple as possible please. >>

select max(dh.maxtid),max(d.tiden) from heaptest dh,diary d;

2002-04-02 Thread tobias
mysql> select max(dh.maxtid),max(d.tiden) from heaptest dh,diary d; +-+-+ | max(dh.maxtid) | max(d.tiden)| +--

Re: InnoDB and Table Corruption

2002-04-02 Thread Steve Edberg
I've been using MySQL on WindowsNT and Solaris for about 5-6 years (don't use any NT machines anymore), and have yet to experience a single corrupted table, mysql daemon crash or any other problem with MySQL. There were a couple of minor snafus when I was setting things up, but they were mostl

mysql@lists.mysql.com

2002-04-02 Thread soracchi
>Description: when I try to start mysqld I have the following problem: ld.so.1: ./mysqld: fatal: libz.so.1: open failed: No such file or directory >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Super-User >Organization: >MySQL support: none >Synopsis: >

Problem with Sun Os

2002-04-02 Thread Andrea Soracchi
Hello, When i try to launch my server mysqld I have the follwing result: ld.so.1: ./bin/my_print_defaults: fatal: libz.so.1: open failed: No such file or directory I have installed the following version mysql-3.23.49 (Official MySQL binary) Environment: System: SunOS lan-ba14ub-04 5

Newbie: MySQL poor performance

2002-04-02 Thread Augusto Pirovano
I'm doing some benchmarks in order to understand where are the bottlenecks in my solution and I found that a SQL query on a table with 12000 records takes 0,87 seconds to preform (Dual 800 G4 MacOS X Server) 0,87 sec may seem fast but it is not on a solution which is going to have a lot of traffic

removing history

2002-04-02 Thread Marek Wysmulek
Dear all. Where is stored and/or how to remove history of command line in mysql client connected to the server ? After the password were changed I would like to delete trace of such activity to prevent plain text passwords in password('...') command against common user. Thanks in advance. Ma

Help with syntax error

2002-04-02 Thread jim and lois flaherty
I have a table that recieves raw data form results for an online quiz. The boss wants to analyse the data , I have it all going to one table for processing. From that table of "Raw Data" I pick out what I need. I want to pick out the test name but I dont want duplicate. I made the column unique in

Re: Newbie: MySQL poor performance

2002-04-02 Thread Augusto Pirovano
On 2-04-2002 15:28, "Ulrik Witschass" <[EMAIL PROTECTED]> wrote: > If many other tasks are running, try to renice it (though not too much). What does renice mean? How can I do that? > I just ran an INNER JOIN query with a result of 21397 records in the set on > my 867 G4 and it took around 0.5

Re: Newbie: MySQL poor performance

2002-04-02 Thread Augusto Pirovano
On 2-04-2002 15:32, "Ulrik Witschass" <[EMAIL PROTECTED]> wrote: > Also monitor top or the process viewer during the query. I noticed that > without renicing, MySQLD never jumped over 10% CPU usage. So theoretically, > I can run 10 queries at the same time and they would be as fast as running > j

Re: Help with syntax error

2002-04-02 Thread Jim Philips
There is no support for sub-queroes in MySQL, so your second select is getting kicked out. You probably want a left join for this. On Tue, 2002-04-02 at 06:54, jim and lois flaherty wrote: > I have a table that recieves raw data form results for an online quiz. The > boss wants to analyse the da

RE: multiple delete for mysql

2002-04-02 Thread Rick Emery
mysql version 4.x does this -Original Message- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 5:28 PM To: [EMAIL PROTECTED] Subject: multiple delete for mysql Hi all, How can i do a delete from multiple table in mysql? Eg : I want ot delete record something

RE: easy query question

2002-04-02 Thread Rick Emery
select id, shortdescription, title from reviews where title REGEXP '^[0-9&#$].*' ORDER BY title ASC -Original Message- From: Jay Paulson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 6:32 PM To: [EMAIL PROTECTED] Subject: easy query question I want to do a query that will find

insert delayed and timestamps

2002-04-02 Thread Viraj Alankar
Hello, When using 'insert delayed' syntax and there is a timestamp field in the table but not specified in the insert query, which timestamp is actually used when the record ends up in the destination table? In other words, will the timestamp value be the actual timestamp that the record was inse

RE: insert delayed and timestamps

2002-04-02 Thread Rick Emery
What happened when you tried this experiment? -Original Message- From: Viraj Alankar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 8:50 AM To: [EMAIL PROTECTED] Subject: insert delayed and timestamps Hello, When using 'insert delayed' syntax and there is a timestamp field in

help optimizing log table deletes

2002-04-02 Thread Viraj Alankar
Hello, We have an 'outgoing' table being used to store email header information defined as follows: CREATE TABLE outgoing ( rpath varchar(80) default NULL, auth varchar(80) NOT NULL default '', ip varchar(80) default NULL, hfrom varchar(80) default NULL, hto varchar(80) default NULL,

RE: help optimizing log table deletes

2002-04-02 Thread Klaus Meine
perhaps you can run this more frequently, say once an hour if it does not interfere with your application logic. > -Original Message- > From: Viraj Alankar [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 4:57 PM > To: [EMAIL PROTECTED] > Subject: help optimizing log table delet

RE: help optimizing log table deletes

2002-04-02 Thread Johnson, Gregert
You can use the LIMIT clause to break up a long DELETE into a series of shorter ones, executed in a loop. So, in pseudo-code: Set delete_row_max = 1000 (or another appropriate value) do { DELETE FROM outgoing WHERE timestamp < last_time LIMIT delete_row_max; row_count = no. of

not really -> Re: LDAP authentication for mySQL databases

2002-04-02 Thread Russell E Glaue
Currently there is no built-in straight-forward methods to authenticate against LDAP Directories. However, I have heard from others who have compiled OpenLDAP using MySQL as a back-end database. OpenLDAP: I do not know if the possibility exists to replicate the MySQL tables storing the Op

mysqlmanager -> Re: FW: To run MySQL Server from the remote machine

2002-04-02 Thread Russell E Glaue
Have you looked at mysqlmanager? It is still being developed and I am told it should not be used other than for testing MySQL. There is a mysqlmanagerc (client) app that goes with it. It looks like it is being made to execute commands remotely. I am waiting for someone to tell me what 'bin/mysq

MySQL - ERROR 2002

2002-04-02 Thread Victoria Reznichenko
Andrew, Tuesday, April 02, 2002, 10:06:42 AM, you wrote: A> I keep on getting the following error message when trying to connect to A> MySQL - ERROR 2002: Can't connect to local MySQL server through socket A> '/var/lib/mysql/mysql.sock' A> This can be fixed by creating a link from the /tmp/mys

Arabic Support

2002-04-02 Thread Egor Egorov
Hytham, Monday, April 01, 2002, 9:29:40 PM, you wrote: HS> how can i use arabic language in the mysql tables data, my data in the HS> table looks like Extended Ascii, and it is re-interpreted in windows HS> programs - as MySQLMaker - into arabic, how can i let MySQL itself HS> understand arab

removing history

2002-04-02 Thread Victoria Reznichenko
Marek, Tuesday, April 02, 2002, 3:20:45 PM, you wrote: MW> Where is stored and/or how to remove history of command line in mysql client connected to the server ? If the variable MYSQL_HISTFILE is set, history is written in the file this var points to. In other case history is written in ~/.my

Random invalid result sets returned

2002-04-02 Thread Victoria Reznichenko
Zack, Saturday, March 30, 2002, 10:52:40 PM, you wrote: That appears to be a PHP script problem, not MySQL one. But first try to upgrade MySQL to 3.23.49a and see how the behavior changes. ZA> Hey, I'm having MySQL exhibit some really weird behavior. I am running ZA> 3.23.41 on OS X. I'm tryin

can't connect

2002-04-02 Thread Victoria Reznichenko
Carl, Tuesday, April 02, 2002, 2:54:45 AM, you wrote: CWK> I downloaded mysqlgui linux semi static binary and installed it. I copy CWK> my.cnf to ~/.my.cnf. I set the user name to my user. When I start it up CWK> it prompts for password then indicates that it can't connect. I am using CWK> the s

Help with syntax error

2002-04-02 Thread Victoria Reznichenko
jim, Tuesday, April 02, 2002, 2:54:13 PM, you wrote: jalf> I have a table that recieves raw data form results for an online quiz. The jalf> boss wants to analyse the data , I have it all going to one table for jalf> processing. From that table of "Raw Data" I pick out what I need. I want to jalf>

Importing function

2002-04-02 Thread Egor Egorov
Everitte, Monday, April 01, 2002, 11:28:31 PM, you wrote: Eeoen> I have the 3.23.49 Version of MySQL and it is saying the load data command Eeoen> does not work with this version. I also read in my book that any version Eeoen> past 3.22.15 should be able to complete this function. Please advise

running the server problem

2002-04-02 Thread Victoria Reznichenko
Bob, Tuesday, April 02, 2002, 12:49:55 AM, you wrote: BL> ./safe_mysqld --user=mysqld --datadir=/db/ BL> ./safe_mysqld --user=mysqld --datadir=/db/ BL> 020401 16:55:04 mysqld started BL> 020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) BL>

mysql@lists.mysql.com

2002-04-02 Thread Egor Egorov
soracchi, Tuesday, April 02, 2002, 2:55:37 PM, you wrote: s>Description: s> when I try to start mysqld I have the following problem: s> ld.so.1: ./mysqld: fatal: libz.so.1: open failed: No such file or directory Seems it's not a bug, looks like that zlib is not installed on your box.

komma and dot

2002-04-02 Thread Egor Egorov
Liivar, Tuesday, April 02, 2002, 10:52:01 AM, you wrote: LP> How I can use ',' instead of '.' in a number values in mysql. I changed LP> charactermap but nothing. LP> MySQL 3.23.41 RH7.2 No, you can't use ',' in a numeric values. If you want to store data separated with a ',' you can store as a

RE: Newbie - Different commands....?

2002-04-02 Thread Gordon Stewart
At this 09:33 2/04/02 +0200 Roger Baklund told us all something interesting :- >* Gordon Stewart >[...] > > http://homepages.slingshot.co.nz/~gordon52/3.txt >[...] > >while ( $row = mysql_fetch_array($result) ) { > > echo("" . $row["JokeText"] . ""); >[...] > > But how do i list the ac

Database Replication

2002-04-02 Thread Eric Baines
I have setup replication between two servers. Everything works great. I wanted to change the location of the bin-log file. I tried 'log-bin=/somedirectory/replication.log' but I get this error 'replication.1 not found (Errcode: 2)'. I took this from the manual: |--

Re: insert delayed and timestamps

2002-04-02 Thread Viraj Alankar
On Tue, Apr 02, 2002 at 08:53:27AM -0600, Rick Emery wrote: > What happened when you tried this experiment? I just did the following: In one client connection, issued 'lock tables outgoing write'. Then in another client connection, tried to do an 'insert delayed' without specifying the timestam

Index problems

2002-04-02 Thread João Paulo Vasconcellos
Hello everybody, I am running mysql-3.23.47 on FreeBSD 4.5, and everytime I use myisamchk I get the following error: >< [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.* myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a correct index

Index problems

2002-04-02 Thread João Paulo Vasconcellos
Hello everybody, I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I get the following error: >< [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.* myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a correct index

swe7 character set - strange mappings?

2002-04-02 Thread Philip Semanchuk
Hi everyone, I am trying to understand what's going on here and I hope you can help me. The swe7 characters set in swe7.conf has some really strange mappings in it. For instance, the to_upper array maps ASCII 0x7E (a tilde) to 0x5E (a "hat" aka Ctrl character). Why doesn't a tilde remain a tilde?

Spontaneous Data Directory Changing

2002-04-02 Thread Adriano Manocchia
A few weeks ago, my mysql 3.23.46 server spontaneously started changing its data directory to /var/tmp/ once or twice a week, and once or twice a day for a short span. Nothing in the error file. Anyone seen anything like this or have any idea what's going on? I changed the data directory to a

Password function

2002-04-02 Thread Ramiro Varandas Jr
I think that this question might be kinda of stupid for all of you but I couldn't find a good answer... When we use the MySQL internal function - Password('string') - MySQL inserts that string codified into the database, so that people that look for that doesn't know the real password. But i h

RE: Password function

2002-04-02 Thread Kenneth Hylton
Okay, here's a hint... 4.2.9 in the manual (;o) Basically, if you encrypt the password, then you have to look it up using the password function, too. Ken Hylton Programmer Analyst IV LEC Systems & Programming Billing Concepts, Inc. 7411 John Smith Drive San Antonio, Texas 78229-4898 (210) 949

RE: Password function

2002-04-02 Thread Lee, Andrew
If user_id and passwd are fields in your table and the passwd field is encrypted : SELECT user_id FROM user WHERE passwd = PASSWORD('plaintext_user_pass') > -Original Message- > From: Ramiro Varandas Jr [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 11:49 AM > To: [EMAIL PRO

Re: Password function

2002-04-02 Thread Sunil S
--- Ramiro Varandas Jr <[EMAIL PROTECTED]> wrote: > I think that this question might be kinda of stupid > for all of you but I > couldn't find a good answer... When we use the MySQL > internal function - > Password('string') - MySQL inserts that string > codified into the database, so > that

Re: Password function

2002-04-02 Thread Rodney Broom
From: Kenneth Hylton <[EMAIL PROTECTED]> > Basically, if you encrypt the password, then you have to look it up using > the password function, too. What he means is this: SELECT user_id FROM user WHERE PASSWORD(user_pass) = PASSWORD('my_var') --- Rodney Broom Programmer: Desert.Net sql --

Re: Password function

2002-04-02 Thread Rodney Broom
From: Lee, Andrew <[EMAIL PROTECTED]> > If user_id and passwd are fields in your table and the passwd field is > encrypted : > SELECT user_id FROM user WHERE passwd = PASSWORD('plaintext_user_pass') Woops, I was typing too fast Ramiro. Andrew's query is right and mine is wrong. --- Rodney Broom

mysql forum

2002-04-02 Thread Javier Gloria
Hi everybody: where i can find a forum than works with php,mysql. for my site. or the source code for one. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --

MySQL and Unidata

2002-04-02 Thread Jane Holloway
I want to use MySQL to connect to a UniData database and 'replicate' (via ODBC) some UniData tables. Has anyone used MySQL in this way? Do I need MySQL and MyODBC? - Before posting, please check: http://www.mysql.com/manual

Re: PigeonRank

2002-04-02 Thread Curtis Maurand
y'all are kidding, right? On Mon, 1 Apr 2002, Dan Zarrella wrote: > i've read the bit on google about thier pigeon rank thing, sounds like a > cross between reality and alittle aprils' fools to me, either way id > apreciate a better explanation of this technology and how it may be > implem

Re: mysql forum

2002-04-02 Thread Daniel Negron/KBE
you can try http://phpnuke.org Thank You <><><><><><><><><><><><><><><><> Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com <><><><><><><><><><><><><><><><> |+> || Javier

Re: PigeonRank

2002-04-02 Thread Rodney Broom
From: Curtis Maurand <[EMAIL PROTECTED]> > y'all are kidding, right? http://www.google.com/technology/pigeonrank.html --- Rodney Broom Programmer: Desert.Net sql - Before posting, please check: http://www.mysql.com/ma

MySQL 3.23.49 Installation - password problems

2002-04-02 Thread Lee P Reilly
Hi, I just installed MySQL 3.23.49 on NT and executed the following commands: UPDATE USER SET password=password("test1") WHERE host="localhost"; UPDATE USER SET password=password("test1") WHERE host="%"; Now, after doing 'mysqladmin reload', I cannot connect... > mysql -p > Enter password:

MACOSX and PHP and MYSQL

2002-04-02 Thread Bensin Joseph
I have MACOSX 10.1.3. PHP runs fine with no problem could someone help me install or direct me to where i can get instruction of how to install MYSQL on my machine please. - Before posting, please check: http://www.mysql.com

read-only mysql table

2002-04-02 Thread Valerie Brooks
Hi all, I have a mysql table, which gives the error read-only when I use LOAD DATA INFILE command. How do I change this, I read the online manaul with no success. Thanks. - Valerie Brooks Fujitsu Software 3055 Orchard Dr. Sa

RE: mysql forum

2002-04-02 Thread Gary . Every
Here's a good one: http://www.xmbforum.com/ -Original Message- From: Javier Gloria [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 11:27 AM To: mysql Subject: mysql forum Hi everybody: where i can find a forum than works with php,mysql. for my site. or the source code for o

RE: mysql forum

2002-04-02 Thread Todd Williamsen
How about newsgroups for php? They have a couple on php/mysql I believe and they respond quite quickly... Look at php.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE:

backup databases

2002-04-02 Thread Kory Wheatley
What is the best method to backup all your MYSQL DATBASES with not a lot of down time. I have read about using "mysqlhotcopy" and "mysqldump" are these the best methods. Also what procedure is followed in backing up the databases. I'm basically looking for the must accurate and reliable way of

Re: MACOSX and PHP and MYSQL

2002-04-02 Thread Adriano Manocchia
Assuming you have the developer tools installed, it compiles just fine: ./configure make make install if you don't have the dev tools, check VersionTracker. Someone probably has the binaries packaged up. On Tuesday, April 2, 2002, at 01:11 PM, Bensin Joseph wrote: > I have MACOSX 10.1.3. > P

Re: backup databases

2002-04-02 Thread Russell E Glaue
We use mysqldump. It is fast and easy. restoration is not hard. If you want more a more percise restoration option, look at using the change-log. It wil allow you to revert back in time to a state of the DB. -RG On Tue, 2 Apr 2002, Kory Wheatley wrote: > Date: Tue, 02 Apr 2002 11:26:58 -0700 >

RE: backup databases

2002-04-02 Thread Jonathan Hilgeman
I regularly back up all my databases with mysqldump: mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar -cf MySQL-Backup-DATE.tar.gz -z tmp.sql && rm -f tmp.sql I use a script (to determine DATE) in conjunction with cron to back all databases up nightly, and I also have the script

Help with mysql and cgi

2002-04-02 Thread Soheil Shaghaghi
Hi all, I hope I am not too far off the topic here. I actually need help with cgi, and mysql. Please refer to the this file to see the program itself: http://www.jhanna.com/ExtraPage4.txt What I need to do is to break apart the subroutine, and do some manupulations on it before displaying the out

SQLState: 28000

2002-04-02 Thread Chris Huisman
Hello, I am having a problem connecting to a mysql database. My url string is as follows: private static final String url = "jdbc:mysql://localhost:3306/test"; and I call the DriverManager with: DriverManager.getConnection(url, userName, password); The output of this is: --SQLException--

RE: backup databases

2002-04-02 Thread David McInnis
Could you share your script for doing the date thing with the rest of us? That sounds useful. David McInnis -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:40 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: backup databa

RE: Newbie - Different commands....?

2002-04-02 Thread Roger Baklund
* Gordon Stewart > (I'll assume you can do EVERYTHING in PHP as you can in dos... ??) yes, almost... when you say 'dos', I assume you mean the mysql client console. There are a couple of things you can do in the client console that can not be done with the client api... like using \c to cancel a

RE: swe7 character set - strange mappings?

2002-04-02 Thread savaidis
Will you never put your files on the net? If so, what will you expect to find at the remote server? Your character set? IMO forget character mapping and use BINARY option at fields creation, usally the contains will be upercase or lowercase, not both. The only exeption I can think is to index - or

SQL Query Help

2002-04-02 Thread Danis Stéphane (NHQ-AC)
I have INVOICE table here is the layout: +-+---+--+-+-+-- --+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+-- --+ | ID

Re: backup databases

2002-04-02 Thread Rodney Broom
From: David McInnis <[EMAIL PROTECTED]> > Could you share your script for doing the date thing with the rest of > us? That sounds useful. > > From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] > > mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar -cf > > MySQL-Backup-DATE.tar.gz

Re: MACOSX and PHP and MYSQL

2002-04-02 Thread Michael Stearne
There is a great page with instructions and binaries for this stuff at http://www.entropy.ch/software/macosx/ Michael Bensin Joseph wrote: > I have MACOSX 10.1.3. > PHP runs fine with no problem could someone help me install or direct me > to where i can get instruction of how to install MYSQL

sql syntax question

2002-04-02 Thread Hathaway, Scott L
I have the following query: select *, max(event_date) as high, min(event_date) as low from schedule where event_date between '2002-03-01' and '2003-04-30' group by week_ending,meeting_id order by name, event_date, start_time If I order by event_date, start_time, name, I get the proper results.

RE: backup databases

2002-04-02 Thread Jonathan Hilgeman
Sure. Just create a new file called something like mysqlbackup.sh and chmod it to make it executable. Change any of the vars you want, and it should work (but remember to update the e-mail part of it to use whatever e-mail client you want, unless you just want to leave that part out) This is a cu

Password function still doesn't working

2002-04-02 Thread Ramiro Varandas Jr
I thank all the people that helped me... was very usefull, I tried each one... But i'm using ASP with a DSN Connection Check the code: Set MyConnection = Server.CreateObject("ADODB.Connection") MyConnInfo = "DSN=MyDSN;UID=MyUser;PWD=MyPass;" MyConnection.Open MyConnInfo SQL = "INSERT INTO user

[Fwd: SQLState: 28000]

2002-04-02 Thread Chris Huisman
I granted all privileges to [EMAIL PROTECTED], and everything worked well. thanks a bunch, c. "Land, Christopher" wrote: > [EMAIL PROTECTED] -- perhaps? > > C:~ > > -Original Message- > From: Chris Huisman [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 10:51 AM > To: mysq

Database Catastrophe

2002-04-02 Thread MySQL
Folks, The database I setup 2 weeks ago was operating fine, if a bit slow. Yesterday, I tried running the OPTIMIZE TABLE command on it, as recommended on this list for improving performance. Yesterday there were 75,000 records in my database. Today, there are 13,000 records. Apart from the Op

How to set up JDBC connection pool with Tomcat?

2002-04-02 Thread rick
How do you set up the server.xml and web.xml files to use connection pooling in Tomcat using the org.gjt.mm.mysql.Driver JDLC driver (version mm.mysql-2.0.11)? I have set up and used a simple data source, but I can't get the pooled one working - do I need to set it up differently? Originally, I

RE: backup databases

2002-04-02 Thread Michael C. Neel
We use mybackup.pl - a perl script found on sourceforge (well, not anymore I just looked). It creates a compressed tarball of each database, with a file for each table. The files can be used with the mysql client without change to rebuild a table. It also can be setup to rotate the backups base

RE: backup databases

2002-04-02 Thread Russell E Glaue
It's easy shell. - #!/usr/bin/bash DATE=`/usr/bin/date '+%Y%m%d%H%M%S'` # or '+%Y%m%d' mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar \ -cf MySQL-Backup-${DATE}.tar.gz -z tmp.sql && rm -f tmp.sql - -RG On Tue, 2 Apr 2002, David McInnis wrote: > Date: Tue, 2 Apr 2002

RE: Password function still doesn't working

2002-04-02 Thread Todd Williamsen
Im going to take a shot in the dark since I have not messed with ASP in years Have you just tried to verify the data is there with a simpler script? Just do the connection script then the user_check then see if it is still there. If it was PHP I would be able to find it. -Original Messa

put jtable in session

2002-04-02 Thread bin cai
Hi,listers, I am using java servlet and mysql to develpe a application. i am wondering can i put jtable in session? Thanks in advance bin __ Find, Connect, Date! http://personals.yahoo.ca ---

RE: Database Catastrophe

2002-04-02 Thread MySQL
[EMAIL PROTECTED] writes: >Not sure what to tell you - check to see if you have logging enabled on your Logging is not enabled. > >This is a longshot, but you might have had a corrupted index that >inaccurately reported 75k records when you really were only at 13k, and >optimizing the table did s

Re: SQL Query Help

2002-04-02 Thread DL Neil
Stéphane, > I have INVOICE table here is the layout: > > +-+---+--+-+-+-- > --+ > | Field | Type | Null | Key | Default | Extra > | > +-+---+--+-+-+-

Mysql installation error

2002-04-02 Thread Jane Tsai
Hello, All: We have encountered the problem to install Mysql-3.23.49 version on Linux Redhat 7.1. 1. Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed. 2. Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compressed data--format violated. Can anyone offer some assistance o

need some help...

2002-04-02 Thread Alex Behrens
Hey Guys, I need help indentifiying why I have an error in this line of syntax: while($a=mysql_fetch_array($r)) { $retval.="  - %s",$a["url"],$a["picurl"],$a["url"],$a["title"])"; } It just gives me a parse error on the page for the $retval. = line Thanks! -

RE: need some help...

2002-04-02 Thread Jonathan Hilgeman
While this should be on the PHP list, here's the problem. You're not doing a printf or whatever function that is that replaces %s with values - you're just assigning the string to $retval. It should look something like: $retval .= printf("  ...yadayada"); look up the syntax - I never use printf,

question

2002-04-02 Thread cwessels
i got a problem thats keep on coming and coming, it's like this: first time i run WINmySqladmin and try to make a database on my localhost (http:/localhost:82/PHPmyadmin/index), it will give no problem, so i make my database and connect it to my PHP scripts, so it worked :). But now, when i re

RE: question

2002-04-02 Thread Rance Hall
sounds like you have a problem in your phpmyadmin config file, I forget the syntax I stopped using phpmyadmin some time ago, but I remember those error messages. opinion: if the mysql database is on your network, you can try mysql front as a tool to add databases, tables, users, and everything

optimizing table space

2002-04-02 Thread David yahoo
Hi all, I d like to now is there any way to optimize mysql table space judging from the data there is in. My table can be read only. I put some arbitrary varchar(x) which ddn t correspond to true max len in table. Is there a free gpl tool to diagnose my tables ? Thanks. ___

RE: need some help...

2002-04-02 Thread Rick Emery
$retval = .= "  ". "- ".$a["title"].""; -Original Message- From: Alex Behrens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:46 PM To: [EMAIL PROTECTED] Subject: need some help... Hey Guys, I need help indentifiying why I have an error in this line of syntax: while($a=

optimizing table space

2002-04-02 Thread David yahoo
Hi all, I d like to now is there any way to optimize mysql table space judging from the data there is in. My table can be read only. I put some arbitrary varchar(x) which ddn t correspond to true max len in table. Is there a free gpl tool to diagnose my tables ? Thanks. query -> sql

Re: backup databases

2002-04-02 Thread Mark Stringham
What would the script look like if I'm on Win2k ? Mark -Original Message- From: Rodney Broom <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, April 02, 2002 12:22 PM Subject: Re: backup databases >From: David McInnis <[EMAIL PROTECTED]> > >> Could you share

Re: backup databases

2002-04-02 Thread Russell E Glaue
On Tue, 2 Apr 2002, Mark Stringham wrote: > > What would the script look like if I'm on Win2k ? Good luck!! But seriously; there is a $300 software package out there (can't remember name) that will give your billy-boy OS some unix shell-like capabilities, including TAR. It was featured in like

Re: backup databases

2002-04-02 Thread David Turner
Check out cygwin.com. I think it's free. Great for unix guys having to run on NT. Dave On Tue, Apr 02, 2002 at 05:25:15PM -0600, Russell E Glaue wrote: > > On Tue, 2 Apr 2002, Mark Stringham wrote: > > > > What would the script look like if I'm on Win2k ? > > Good luck!! > > But seriously; th

Re: backup databases

2002-04-02 Thread Mark Stringham
Could I run something similar as a BAT file? -Original Message- From: Russell E Glaue <[EMAIL PROTECTED]> To: Mark Stringham <[EMAIL PROTECTED]> Cc: Rodney Broom <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, April 02, 2002 4:25 PM Subject: Re: backup databases

Re: backup databases

2002-04-02 Thread Russell E Glaue
Maybe... after some long hours and many lines. I am not sure. I know it won't necessarilly be easy. You'd be better off using PERL. You can download the windows binary of PERL for free. (www.perl.org) You can install PERL anywhere you want on the system just so long as your PERL scripts point a

Re: backup databases

2002-04-02 Thread Russell E Glaue
forgot to mention. you'll have to use ZIP, since TAR is not available on Windows (unless you use the previously mentioned software packages). -RG On Tue, 2 Apr 2002, Russell E Glaue wrote: > > Maybe... after some long hours and many lines. I am not sure. I know it > won't necessarilly be easy.

Procedures

2002-04-02 Thread matt
Does any know if mysql has any kind of stored procedures? If not, is there any plans on including them? -matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

PERL/SQL, again? - Re: Procedures

2002-04-02 Thread Russell E Glaue
On the mysql-internals mail list we had a thread going about this. I was suggesting something like embedding PERL into MySQL to produce something like PERL/SQL (similar to PL/SQL in oracle). Unfortunately, although promising and liked among people of the list, there are no plan right now to devel

libtool 1.3.5 broken on Tru64 4.0F

2002-04-02 Thread long
>Description: mysql 3.23.49 uses libtool 1.3.5. That version of libtool happens to be broken on Tru64 4.0F PK3. It fails 17 of 49 tests that come with the libtool package. libtool 1.4.2 passes all of its tests on this platform. The problem I have when building mysql 3.23.49 is that libtool does

Table Question.

2002-04-02 Thread James Taylor
Hi, I just now signed up for this list a second ago and thought I'd say howdy to everyone. I'm not sure what the typical discussions are like on this list, so I'll go ahead and ask anyhow. If there is another list that would be better suited to this type of question, please let me know. A fr

  1   2   >