mysql problem ( innodb server startup)

2002-03-14 Thread Chetan Lavti
hi, When I am starting the mysqld-max daemon there appears two errors !! I have intalled it on the another machine !! At this machine only, i am facing this problem, previously it was running O.K. anybody who can tell me how to resolve this problem...?? [root@dev1 sbin]# ./mysqld-max

Re: JDBC and MySQL problem, please help.

2002-01-17 Thread TAKAHASHI, Tomohiro
Hi, Michael Tam wrote: Hi All, I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I used m.mmysql.2.0.8 JDBC driver with the following config segment in my resin.conf: resource-ref res-ref-namejdbc/test/res-ref-name

MySQL Problem in Slackware 8.0

2002-01-16 Thread Prasad Paranjape
Hello gurus, I have Slackware 8.0 and RHL7.1 both on my Linux box. In Red Hat mysql is working smoothly but I am having having following problems in Slack8 In Slack8 mysql is installed as a per of standard installtion but not under /usr/local.The scripts are in /usr/bin and includes in

RE: MySQL Problem in Slackware 8.0

2002-01-16 Thread Chris Bolt
when as root I give command /usr/bin/safe_mysqld It gives me following messages: Starting mysqld daemon with databases from /var/lib/mysql and on the next line it says mysqld ended. What does /var/lib/mysql/`hostname`.err say?

Re: MySQL Problem in Slackware 8.0

2002-01-16 Thread Prasad Paranjape
Hi, I also noticed one thing , will the entry in the file /etc/hosts make a diffrenece. In Red Hat it is 127.0.0.1 localhost But in Slack it is 127.0.0.1 prasad( which is my name) Regards, Prasad --- Prasad Paranjape [EMAIL PROTECTED] wrote: Hello gurus, I have Slackware 8.0 and RHL7.1

JDBC and MySQL problem, please help.

2002-01-16 Thread Michael Tam
Hi All, I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I used m.mmysql.2.0.8 JDBC driver with the following config segment in my resin.conf: resource-ref res-ref-namejdbc/test/res-ref-name res-typejavax.sql.XADataSource/res-type init-param

[Start mysql problem (v. mysql-3.23.47-hp-hpux10.20-hppa1.1)]

2002-01-02 Thread carlesi
Description: # ./scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./scripts/mysql_install_db[292]: 16797 Memory fault(coredump)

MySQL problem

2001-12-11 Thread Ken Larkman
I am running MySQL (version 3.23.46a)on a Windows 2000 server. The server has suddenly stopped serving out requests. It appears that localhost is refusing connections, even though the passwords appear to be correct. I am pretty new to MySQL so any suggestions of where to look are

Re: PHP + MySQL problem (strange behavior)

2001-12-06 Thread mjriding
I've had a few queries that worked strangely worked in Mysql monitor, but did not work from PHP. I was able to solve every one of them by ensure that the query in PHP did not have any line breaks in it. It normally doesn't matter if there are line breaks in the code, but on occassion, a

PHP + MySQL problem (strange behavior)

2001-12-05 Thread Javier Muniz
Hello, I'm having trouble determining what's going wrong with a MySQL query that I'm doing from PHP. I have a table with the following columns: id (int) name (varchar 20) starttime (int) duration (int) now, i have a row that has a starttime of 60, when i attempt to do the following update

mysql problem

2001-11-23 Thread Zhi Huan YU system admin
Dear support officer, The followings are generated by the mysqlbug script: SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: yuzh To: [EMAIL PROTECTED] Subject: [50

PHP/MySQL Problem

2001-10-30 Thread Matthew Walker
Does anyone see anything wrong with the following code/query syntax? I'm using the PEAR DB class for PHP. When this runs, it correctly inserts the row to the table, but is failing to retrieve the last_insert_id(). function StartOrder() { global $dbhandle; global $OrderID; global

RE: PHP/MySQL Problem

2001-10-30 Thread Matthew Walker
] Subject: Re: PHP/MySQL Problem Mysql_Insert_ID($dbhandle-connection); gets the last id of the last insert statement - if you do any db activity after the insert, this won't work. On Tue, 30 Oct 2001, Matthew Walker wrote: Does anyone see anything wrong with the following code/query syntax? I'm

RE: PHP/MySQL Problem

2001-10-30 Thread rc
: rc [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 1:58 PM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: PHP/MySQL Problem Mysql_Insert_ID($dbhandle-connection); gets the last id of the last insert statement - if you do any db activity after the insert, this won't

RE: PHP/MySQL Problem

2001-10-30 Thread Don Read
On 30-Oct-2001 Matthew Walker wrote: Does anyone see anything wrong with the following code/query syntax? I'm using the PEAR DB class for PHP. When this runs, it correctly inserts the row to the table, but is failing to retrieve the last_insert_id(). function StartOrder() { global

Python/mysql problem

2001-10-28 Thread Christian Stromberger
Experiencing a weird problem retrieving an mxDateTime value from a mysql db in a Python script using the MySQLdb module. Here's what I'm doing, roughly: connection = MySQLdb.connect(db = DB_NAME) cursor = connection.cursor() cursor.execute('select date_entered, description '

Re: MySQL problem with Traffic and Updates

2001-10-26 Thread Michael T. Babcock
On Thu, Oct 25, 2001 at 08:27:00AM -0700, Bill Adams wrote: At http://www.mysql.com/doc/ do a search for multiple processors. There's a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that might help. And don't forget to make sure you have good/needed indexes. (e.g

RE: MySQL problem with Traffic and Updates

2001-10-26 Thread Steve Meyers
Today after my server got a real traffic hit for the first time since I installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how it happened: watching the top load levels, I saw it slow creep up about to 3, then rockets quickly to 30s, 40s, and on!! MySQL was at this

MySQL problem with Traffic and Updates

2001-10-25 Thread Ryan Shrout
Okay, I was afraid this was going to happen. Today after my server got a real traffic hit for the first time since I installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how it happened: watching the top load levels, I saw it slow creep up about to 3, then rockets quickly to

Re: MySQL problem with Traffic and Updates

2001-10-25 Thread jim barchuk
Hi Ryan! Today after my server got a real traffic hit for the first time since I installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how it happened: watching the top load levels, I saw it slow creep up about to 3, then rockets quickly to 30s, 40s, and on!! MySQL was at

Re: MySQL problem with Traffic and Updates

2001-10-25 Thread Bill Adams
jim barchuk wrote: Hi Ryan! Today after my server got a real traffic hit for the first time since I installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how it happened: watching the top load levels, I saw it slow creep up about to 3, then rockets quickly to 30s,

Re: Major MySQL problem

2001-09-25 Thread System Administrator a.k.a. The Root of the Problem
Quickly what needs to be accomplished? On Tue, Sep 25, 2001 at 09:00:08AM -0600, Virag, Thomas wrote: Hello, The recently upgraded MySQL denies any access to my previously perfectly working database. I learned that in this version new Privilege/Grant tables have to be set up before

Re: Major MySQL problem

2001-09-25 Thread System Administrator a.k.a. The Root of the Problem
PROTECTED] Subject:Re: Major MySQL problem Quickly what needs to be accomplished? On Tue, Sep 25, 2001 at 09:00:08AM -0600, Virag, Thomas wrote: Hello, The recently upgraded MySQL denies any access to my previously perfectly working database. I learned that in this version

PHP and Mysql problem

2001-09-19 Thread Neil Silvester
I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections that is built a table in a MySQL database. This is what I have so far (everything works well, the correct information is displayed for both the Category and ID column values.

RE: PHP and Mysql problem

2001-09-19 Thread Andrew Braund
-Original Message- From: Neil Silvester [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20 September 2001 08:12 To: [EMAIL PROTECTED] Subject: PHP and Mysql problem I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections

Re: PHP and Mysql problem

2001-09-19 Thread Matthew Simpson
Subject: PHP and Mysql problem I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections that is built a table in a MySQL database. This is what I have so far (everything works well, the correct information is displayed for both

RE: PHP and Mysql problem

2001-09-19 Thread Don Read
On 19-Sep-2001 Neil Silvester wrote: I am having a little problem with a PHP 4 statement in one of my webpages. I am using a drop down box of selections that is built a table in a MySQL database. This is what I have so far (everything works well, the correct information is displayed for

DBF to MySQL Problem?

2001-08-21 Thread Nathan Walker
Hello, I have downloaded your dbf2mysql-1.14.tar file from the MySQL.com site. I read through the README and still cannot seem to get this to work. Here is the error I'm getting: [info:admin/Desktop/dbf2mysql-1.14] root# make /usr/bin/cc -O2 -Wall -DVERSION=\1.14\ -I/usr/local/ mysql -c -o

Re: DBF to MySQL Problem?

2001-08-21 Thread Alfredo Cole
El Martes 21 Agosto 2001 15:23, escribiste: Hello, I have downloaded your dbf2mysql-1.14.tar file from the MySQL.com site. I read through the README and still cannot seem to get this to work. Here is the error I'm getting: [info:admin/Desktop/dbf2mysql-1.14] root# make /usr/bin/cc -O2

DBF to MySQL Problem?

2001-08-21 Thread Nathan Walker
2001 16:23:56 -0500 To: [EMAIL PROTECTED] Subject: DBF to MySQL Problem? Hello, I have downloaded your dbf2mysql-1.14.tar file from the MySQL.com site. I read through the README and still cannot seem to get this to work. Here is the error I'm getting: [info:admin/Desktop/dbf2mysql-1.14] root

Re: SMALL MYSQL Problem

2001-08-17 Thread Sinisa Milivojevic
O'SULLIVAN JOHN writes: Hi I am just starting to write my first client with MYSQL 3.23.39 under RH Linux 7.1 and I had the following code. The code compiles fine but the call to mysql_query( ) fails with following error I used the exact same query at the MYSQL prompt and it worked

Re: SMP+mysql problem

2001-07-20 Thread Jeremy Zawodny
On Wed, Jul 18, 2001 at 12:45:57PM +0200, Werner Stuerenburg wrote: What I am stumbling about is this: PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 22889 root 30 330 801M 11M cpu0 23.6H 26.75% mysqld Is this really true: size 801 M How

Re: SMP+mysql problem

2001-07-20 Thread Werner Stuerenburg
It's normal that the mysqld is 795M big? If is not normal which could be the cause of this size? Certainly not. But Jeremy gave some comments; I don't know anything about this, I wonder myself. My processes are between 8 and 25 MB. PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU

Re: SMP+mysql problem

2001-07-20 Thread Igor Brezac
Under solaris 8 you can use pmap -x 22889 which will give address space map. -Igor On Fri, 20 Jul 2001, Jeremy Zawodny wrote: On Wed, Jul 18, 2001 at 12:45:57PM +0200, Werner Stuerenburg wrote: What I am stumbling about is this: PID USERNAME THR PRI NICE SIZE RES STATE TIME

SMP+mysql problem

2001-07-18 Thread Jorge Ruiz Martinez
Hello, i have got a A BIG PROBLEM, help me please!!! I've got installed Apache + MySQL in a Sun Enterp. 250 whith two processors and my problem is the next: When I run MySQL only works one processor with mysqld load averages: 0.68, 0.81, 1.02 01:37:45 259 processes: 251

Re: SMP+mysql problem

2001-07-18 Thread Werner Stuerenburg
What I am stumbling about is this: PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 22889 root 30 330 801M 11M cpu0 23.6H 26.75% mysqld Is this really true: size 801 M How can that be -- Herzlich Werner Stuerenburg

Re[2]: SMP+mysql problem

2001-07-18 Thread Werner Stuerenburg
If you need an archive conf. or something to help me, say me please. -Mensaje original- De: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 18 de julio de 2001 12:46 Para: Jorge Ruiz Martinez CC: '[EMAIL PROTECTED]' Asunto: Re: SMP+mysql problem What I am

Re: Solaris +SMP + mysql problem

2001-07-18 Thread Alexander Belyaev
Hello, I have thread_concurrency=4 already in my.cnf, but mysqld don't want to use more than 50% of CPU resources. (Solaris8 x86 MU3 on Dual PIII Xeon with 1GB RAM) Alexander On Wednesday 18 July 2001 07:41, Alexander Belyaev wrote: Hello, I have a similar results on my Solaris8 x86 + MU3,

(win 2000 + mysql) = problem

2001-07-13 Thread Andrey Goncharenko
I install mysql (v 3.23.39) on Windows 2000 pro, but server is not run:( Plese, help me... What I must to make? ó Õ×ÁÖÅÎÉÅÍ, áÎÄÒÅÊ. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: (win 2000 + mysql) = problem

2001-07-13 Thread Kevin Smith
What does it say in your, C:\mysql\data\mysql.err file? - Original Message - From: Andrey Goncharenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 10:03 AM Subject: (win 2000 + mysql) = problem I install mysql (v 3.23.39) on Windows 2000 pro, but server

RE: (win 2000 + mysql) = problem

2001-07-13 Thread Christopher Thorpe
2000 + mysql) = problem I install mysql (v 3.23.39) on Windows 2000 pro, but server is not run:( Plese, help me... What I must to make? ó Õ×ÁÖÅÎÉÅÍ, áÎÄÒÅÊ. - Before posting, please check: http://www.mysql.com/manual.php

mysql problem

2001-07-09 Thread Kevin Robertson
I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have access to the databases. I think i have lost access as root. Is there a way to restore the root user password and/or change it to something else manually? I have many websites with many 'access denied' errors. Any help

Re: mysql problem

2001-07-09 Thread Rolf Hopkins
create another user with less access. - Original Message - From: Kevin Robertson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 1:43 Subject: mysql problem I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have access to the databases. I think i have

RE: mysql problem

2001-07-09 Thread Noel Clarkson
E R. You should create another user with less access. - Original Message - From: Kevin Robertson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 1:43 Subject: mysql problem I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have access

MySQL Problem

2001-07-01 Thread Anoop K Gupta
Hi Everybody, 1. I am unable to login on my remote Mysql Server installed on Linux.. Perhaps I forgot the password or something else.. How can I solve this problem. 2. My Second problem earlier I use to login successful and when trying to create or use database it gives authontication

Mysql Problem

2001-06-18 Thread úåîø âøñéàðé
Hello I run mysql on a multi proccesoor server and when I run queries from different servers, I see it uses under 100% cpu, even thought it sometimes take 50% from each cpu. how can I get it to use 100% for each query? Thanks Tomer Grassyani. Internet Driver.

MySQL Problem -- Please help

2001-06-09 Thread Vladimir Kravtsov
I'm using MySQL with PHP (just learned MySQL so bear with me). Here's a two part program: Test.php: html body ?php require(common.php); CalculateScore(1); ? /body /html Common.php: ?php //Global variables $Sitename=Toplist; $Siteurl=; $Links_per_page=50; $Base_site_url=localhost; //MySQL

RE: MySQL Problem -- Please help

2001-06-09 Thread Chris Bolt
I thought using the result identifier returned by mysql_query in mysql_fetch_array was perfectly legal. mysql_query() doesn't always return a valid result identifier if an error occurs (echo mysql_error()) or if no rows are returned.

Re: MySQL Problem -- Please help

2001-06-09 Thread oltra jean-michel
When I run test.php I get this: Warning: Supplied argument is not a valid MySQL result resource in common.php on line 27 0 Here are lines 25-27: 25: $sql = select urate, arate, inhits from sitestats where id = $id; 26: $r = mysql_query($sql); 27: $row = mysql_fetch_array($r); I

Re: Mysql Problem

2001-05-14 Thread webmaster
PROTECTED] To: [EMAIL PROTECTED] Copies to: [EMAIL PROTECTED] Subject:Re: Mysql Problem Send reply to: [EMAIL PROTECTED] On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote: I am facing great problems beacuse of Mysql server

Re: Mysql Problem

2001-05-13 Thread Jeremy Zawodny
On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote: I am facing great problems beacuse of Mysql server which is not able to take load. My apache is working fine even when the load average shoots of to 130 but my mysql server goes sleep when the load of apache shoots above

Mysql Problem

2001-05-11 Thread webmaster
Hi I am facing great problems beacuse of Mysql server which is not able to take load. My apache is working fine even when the load average shoots of to 130 but my mysql server goes sleep when the load of apache shoots above 30. I am on a dedicated server. My Mysql Ver 3.22.32 I have red

mysql problem

2001-04-24 Thread J.Heegsma
Dear Sir/Madam and mysql users, I have a mysql database which i can fill with phpadmin, everything is going fine, but when I want to fill the database with php and a form. I got the following problem. I don't know what to do anymore? Can anyone help me? I have made a form, which visitors can

MySQL Problem

2001-04-18 Thread Anoop k gupta
Hi Everybody, I need your help. Thanks .. I was trying to create database on MySQL but it is giving error. I have done the following :- Login through telnet and become root. accessed : mysql -h server name -u username -p Password : password and tried to create database with :

Re: MySQL Problem

2001-04-18 Thread B. van Ouwerkerk
I have done the following :- Login through telnet and become root. accessed : mysql -h server name -u username -p Password : password and tried to create database with : mysql create database cart; ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE 'CART' You say root..

Re: MySQL Problem

2001-04-18 Thread Mani Murugesan
you need to login into MySQL with rights to create databases. Your being root under linux has got nothing to do with root under mysql. Mani. M and tried to create database with : mysql create database cart; ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE 'CART'

RE: MYSQL Problem

2001-04-17 Thread Grimes, Dean
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 11:08 AM To: [EMAIL PROTECTED] Subject: MYSQL Problem Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently

RE: MYSQL Problem

2001-04-16 Thread Huntress Gary B NPRI
l.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 12:08 PM To: [EMAIL PROTECTED] Subject: MYSQL Problem Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend databas

Re: MYSQL Problem

2001-04-16 Thread Andrei Cojocaru
Okay just checking a few basic things, have you indexed your table properly? There is a manual section about performance, also make sure to play around with the mysql configuration file (global one in /etc/my.cnf) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL Problem Date: Mon

RE: MYSQL Problem

2001-04-16 Thread Jan Bruvoll
Hi there, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries

Re: Fwd: MySQL problem

2001-02-06 Thread Danny
eteing all the current mysql rpm with the rpm command and try it without the --no-deps option. - Or install a prevous version of mysql? -- Forwarded Message -- Subject: MySQL problem Date: Wed, 31 Jan 2001 23:01:22 -0500 From: Vadim Selitskiy [EMAIL PROTECTED] whereis m

Fwd: MySQL problem

2001-02-01 Thread Danny
? -- Forwarded Message -- Subject: MySQL problem Date: Wed, 31 Jan 2001 23:01:22 -0500 From: Vadim Selitskiy [EMAIL PROTECTED] whereis mysql shows me two directories: /usr/lib/mysql, which is empty and /usr/share/mysql which has some documentation about mysql. Although

<    1   2