Replication is currupted ...Please help me...

2004-06-09 Thread
don't know what this replaction was currepted. Anybody know what I do? Please let me know... this is err_message at that time. - 040609 13:09:14 Error in Log_event::read_log_event(): 'Event too

RE: Replication is currupted ...Please help me...

2004-06-09 Thread Mechain Marc
May be a full off the filesystem where the relay logbin file is ? Marc. -Message d'origine- De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoye?: mercredi 9 juin 2004 09:46 A?: [EMAIL PROTECTED] Objet?: Replication is currupted ...Please help me... Hi all. My company has three

RE: JOINing complication, help please

2004-06-03 Thread SGreen
Fax to: Subject: RE: JOINing complication, help please

JOINing complication, help please

2004-06-02 Thread Luc Foisy
CONTACT_X_CUSTOMER.ID_ADDRESS CUSTOMER.ID_ADDRESS_SHIPTO CUSTOMER.ID_ADDRESS_MAIN What I would like is to be able to JOIN conditionally based on the absence/presence of reference SELECT ADDRESS.ID FROM CONTACT_X_CUSTOMER LEFT JOIN CUSTOMER ON CONTACT_X_CUSTOMER.ID_CUSTOMER = CUSTOMER.ID

re: JOINing complication, help please

2004-06-02 Thread Luc Foisy
Ok, I got a result here, still trying to determine if its correct or not :) LEFT JOIN ADDRESS ON IF(CONTACT_X_CUSTOMER.ID_ADDRESS 0, CONTACT_X_CUSTOMER.ID_ADDRESS = ADDRESS.ID, IF(CUSTOMER.ID_ADDRESS_SHIPTO 0, CUSTOMER.ID_ADDRESS_SHIPTO = ADDRESS.ID, CUSTOMER.ID_ADDRESS_MAIN = ADDRESS.ID))

Re: JOINing complication, help please

2004-06-02 Thread SGreen
: Fax to: 06/02/2004 10:46 AM Subject: JOINing complication, help please

Re: JOINing complication, help please

2004-06-02 Thread SGreen
cc: MYSQL-List (E-mail) [EMAIL PROTECTED] AM Fax to: Subject: Re: JOINing complication, help please

RE: JOINing complication, help please

2004-06-02 Thread Luc Foisy
for that big spew of SQL ) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 11:37 AM To: Luc Foisy; MYSQL-List (E-mail) Subject: Re: JOINing complication, help please Sorry to reply to myslef but I just saw my own typo. Here is a better example

RE: JOINing complication, help please

2004-06-02 Thread Luc Foisy
Oops, that LEFT JOIN ADDRESS ON IF(etc...) shouldn't be in the big long select statement -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Please help..

2004-05-28 Thread Chip Bell
Hello, I have a Red Hat 9 server which runs a qmail/toaster software package. It allows webmail to authenticate against a mysql db and stores mail there too. K, the issue.. Every once in a while, the web client just SITS at authentication. The client just sits there forever. The

Re: Unknown error, urgent help please

2004-05-24 Thread Brian Reichert
On Tue, May 18, 2004 at 10:08:32AM -0400, Ronnie Regev wrote: Hi, Before I go on, I know nothing about mysql, but my db admin is out of town and I need to be pointed in the right direction please. Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual hosting environment

test please ignore

2004-05-20 Thread Steve Davies
had no mysql list mail for a while just testing please ignore mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

tests please ignore

2004-05-20 Thread Victor Medina
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java - MySQL | ~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria

Please help me optimize a MySQL server.

2004-05-19 Thread Mohammed Sameer
, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Egor Egorov
Mohammed Sameer [EMAIL PROTECTED] wrote: I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about

[uniball@gmx.net: Re: Please help me optimize a MySQL server.]

2004-05-19 Thread Mohammed Sameer
#58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Brent Baisley
-- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Mohammed Sameer
suggestions are welcomed. Many thanks! -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Brent Baisley
! -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Mohammed Sameer
woody ?? Any suggestions are welcomed. Many thanks! -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable

Re: Please help me optimize a MySQL server.

2004-05-19 Thread Scott Haneda
on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote: I wouldn't upgrade until you know where the bottleneck is (CPU, disk, network, or RAM). Since you are using professional software, I wouldn't try to change the queries. Have you made changes to your my.cnf file? Since you have

Unknown error, urgent help please

2004-05-18 Thread Ronnie Regev
Hi, Before I go on, I know nothing about mysql, but my db admin is out of town and I need to be pointed in the right direction please. Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual hosting environment on Ensim webppliance-3.5.20-7. When using phpMyAdmin

Re: Unknown error, urgent help please

2004-05-18 Thread Egor Egorov
Ronnie Regev [EMAIL PROTECTED] wrote: Hi, Before I go on, I know nothing about mysql, but my db admin is out of town and I need to be pointed in the right direction please. Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual hosting environment on Ensim webppliance

Please Help ! this might be simple but not for me :(

2004-05-05 Thread amjoe11-3
Hi All Perl Gurus ! I'm in the middle of this and i'm not able to figure out what is wrong ! I have a html file and i want to do a grep for the accourance of !--#include virtual and push every result to an array. Then get only the filepath into another array ... but man !i'm stuck... please

please ignore

2004-04-15 Thread Victor Medina
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please ignore - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java - MySQL | ~ | \ \ \ _| | |_) / _ \ |Dpto

AW: please ignore

2004-04-15 Thread Freddie Sorensen
That's a lot of stuff to ignore but I managed to do so successfully -Ursprüngliche Nachricht- Von: Victor Medina [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. April 2004 13:39 An: [EMAIL PROTECTED] Mysql. Com Betreff: please ignore -BEGIN PGP SIGNED MESSAGE- Hash

Please HELP !!! Can not restart server

2004-04-08 Thread Ginger Cheng
--user=root '. Still the same thing. I even tried to restart the server again but it does not work either. I have also tried to restore the my.cnf file and there is no effect. Please help me. I need it to be fixed as soon as I can. Thank you so much ginger -- MySQL General

RE: Please HELP !!! Can not restart server

2004-04-08 Thread DChristensen
Please look in your data directory and post the contents of the host name.ERR file that you find there. That will give folks the information they need to help solve your problem. -Original Message- From: Ginger Cheng [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 10:21 AM

RE: Please HELP !!! Can not restart server

2004-04-08 Thread Victor Pendleton
What information is being logged in *.err? -Original Message- From: Ginger Cheng To: [EMAIL PROTECTED] Sent: 4/8/04 10:20 AM Subject: Please HELP !!! Can not restart server Hi, MySQL Gurus, Version of mysql is Distrib 3.23.54, for redhat-linux-gnu (i386). I started mysql server

RE: Please HELP !!! Can not restart server

2004-04-08 Thread Ginger Cheng
I don't have such files. Unfortunately. Am I hopeless? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Please HELP !!! Can not restart server

2004-04-08 Thread Ginger Cheng
Here is the error msg: 040408 08:47:14 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB

RE: Please HELP !!! Can not restart server

2004-04-08 Thread Ginger Cheng
I got it fixed with the msg from --err-log. THank you so much for all your help. I couldn't have made it without your hints. ALl the best ginger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Please HELP !!! Can not restart server

2004-04-08 Thread Victoria Reznichenko
Ginger Cheng [EMAIL PROTECTED] wrote: Here is the error msg: 040408 08:47:14 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your

TEST - please ignore!

2004-04-06 Thread Victor Medina
-- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL

opinion please

2004-04-05 Thread joe collins
I am going to have a web hosted MySQL database. It will hopefully have 100+ users. I was thinking of having one database to store all records for all users. I would store a user_id against records where appropriate to relate them to a particular user. The database will have a contacts table, users

Re: opinion please

2004-04-05 Thread Peter J Milanese
it being hammered either way. Hope that helps a bit P joe collins [EMAIL PROTECTED] 04/05/2004 09:00 AM To: MySQL [EMAIL PROTECTED] cc: Subject:opinion please I am going to have a web hosted MySQL database. It will hopefully have 100+ users. I

INODB Please Help anybody in backup!!!!!!!!!!!!!!!!HELP!!!!!!!

2004-03-26 Thread jacobbytech
Hello, I created inodb database with around 150 tables with relation to each table (like Parent -Child Relation ship). My problem is , I take backup using MYSQLDUMP Utility and entre database get backed up. But all the tables in squenitial order. When I restore backup, It does not get

Re: INODB Please Help anybody in backup!!!!!!!!!!!!!!!!HELP!!!!!!!

2004-03-26 Thread Jacek Wozniak
My problem is , I take backup using MYSQLDUMP Utility and entre database get backed up. But all the tables in squenitial order. When I restore backup, It does not get restored because first it should create parent table then child like in hirarchial order of relationship. Here is an

Re: Please help with this: ERROR 1047: Unknown command

2004-03-24 Thread Victoria Reznichenko
Hiep Ho [EMAIL PROTECTED] wrote: i have problem adding user to mysql. I can create a database and there is no problem however I got this ERROR 1047: Unknown command when I tried to add new user. I don't think I have this problem before. I run this command GRANT ALL ON *.* TO usename

Please help with this: ERROR 1047: Unknown command

2004-03-23 Thread Hiep Ho
Hello Any help would be appreciated. i have problem adding user to mysql. I can create a database and there is no problem however I got this ERROR 1047: Unknown command when I tried to add new user. I don't think I have this problem before. I run this command GRANT ALL ON *.* TO

Re: just the list please!

2004-03-19 Thread Sasha Pachev
Michael T. Babcock wrote: Daniel Kasak wrote: When someone has a MySQL problem, it is often urgent. While most of my posts to the list seem to appear withing a few minutes, I can remember many occasions when they took more than a few hours. Its also not that difficult to notice duplicates;

Re: just the list please!

2004-03-17 Thread Michael T. Babcock
Daniel Kasak wrote: When someone has a MySQL problem, it is often urgent. While most of my posts to the list seem to appear withing a few minutes, I can remember many occasions when they took more than a few hours. Its also not that difficult to notice duplicates; only the messages to

just the list please!

2004-03-16 Thread Alan Williamson
Can people please just email the list and not the person *AND* the list!!! i get duplicate emails and its very annoying to what is a great list so far. kinda puts me off from answering peoples questions! thanks! :) - Original Message - From: Alan Williamson [EMAIL PROTECTED

Re: just the list please!

2004-03-16 Thread Tim Cutts
On 16 Mar 2004, at 21:31, Alan Williamson wrote: Can people please just email the list and not the person *AND* the list!!! i get duplicate emails and its very annoying to what is a great list so far. kinda puts me off from answering peoples questions! This is something the list admins might

Re: just the list please!

2004-03-16 Thread Gabriel Guzman
On Tuesday 16 March 2004 02:19 pm, Tim Cutts wrote: This is something the list admins might be able to sort out. It's common for mailing lists to set a reply-to header... snip here we go again -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: just the list please!

2004-03-16 Thread Tim Cutts
On 16 Mar 2004, at 22:30, Gabriel Guzman wrote: On Tuesday 16 March 2004 02:19 pm, Tim Cutts wrote: This is something the list admins might be able to sort out. It's common for mailing lists to set a reply-to header... snip here we go again Oops - is that a bad button to push? :-) If

Re: just the list please!

2004-03-16 Thread Scott Haneda
on 3/16/04 1:31 PM, Alan Williamson at [EMAIL PROTECTED] wrote: Can people please just email the list and not the person *AND* the list!!! i get duplicate emails and its very annoying to what is a great list so far. kinda puts me off from answering peoples questions! Personally, I like em

Re: just the list please!

2004-03-16 Thread Daniel Kasak
Scott Haneda wrote: on 3/16/04 1:31 PM, Alan Williamson at [EMAIL PROTECTED] wrote: Can people please just email the list and not the person *AND* the list!!! i get duplicate emails and its very annoying to what is a great list so far. kinda puts me off from answering peoples

Re: Newbie - Please help with createing database

2004-03-15 Thread jeffrey_n_Dyke
and it gives me this error Error SQL-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list

Test Email - Please Disregard

2004-03-15 Thread Kevin Carpenter
Test Email - Please Disregard -:Kevin Carpenter CHOP - Biomedical Engineering (215) 590-5762 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: Test Email - Please Disregard

2004-03-15 Thread Freddie Sorensen
Successfully disregarded ! -Ursprüngliche Nachricht- Von: Kevin Carpenter [mailto:[EMAIL PROTECTED] Gesendet: Montag, 15. März 2004 19:33 An: [EMAIL PROTECTED] Betreff: Test Email - Please Disregard Test Email - Please Disregard -:Kevin Carpenter CHOP - Biomedical Engineering

Newbie - Please help with createing database

2004-03-13 Thread ryan
SQL-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing

Re: Newbie - Please help with createing database

2004-03-13 Thread ryan
Hey James, Thanks for replying. How do you like ensim? Pretty good, quite easy to use...Got it free with my hosting so no complaints. BTW - I use the CLI(command line interface) and connect using the mysql CLI: Ok, tried it via CLI and heres the output # mysql -u root -p Enter password:

Re: Newbie - Please help with createing database

2004-03-13 Thread Egor Egorov
and it gives me this error Error SQL-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Error 13 means that MySQL doesn't have permissions

Re: Newbie - Please help with createing database

2004-03-13 Thread Hassan Schroeder
[EMAIL PROTECTED] wrote: mysql create database test1; ERROR 1006: Can't create database 'test1'. (errno: 13) In the bin directory of your installation, you should have a program named 'perror' that will interpret MySQL error messages, as in: prompt$ perror 13 Error code 13: Permission denied

Re: Newbie - Please help with createing database

2004-03-13 Thread Hassan Schroeder
Ryan A wrote: prompt$ perror 13 Error code 13: Permission denied Can you give me directions or a URL which will explain how to fix this please...am a newbie remember :-) Assuming you're on some sort of *nix system, `man chmod` will show you how to change permissions of files and directories

Please help with join issue

2004-03-05 Thread Erica L Ridley
I need help with rewriting a sql query. Nested queries that work in MS databases apparently do not work in MySQL databases. Here is what I need in MS query pseudo code: SELECT table1.myfield1, table2.myfield2 FROM table1, table2 WHERE table1.key=table2.key AND myfield1=something AND

Re: Please help with join issue

2004-03-05 Thread Egor Egorov
Erica L Ridley [EMAIL PROTECTED] wrote: I need help with rewriting a sql query. Nested queries that work in MS databases apparently do not work in MySQL databases. Here is what I need in MS query pseudo code: SELECT table1.myfield1, table2.myfield2 FROM table1, table2 WHERE

A problem with access to data source, please help!!!!

2004-03-01 Thread Rafael Diaz Valdes
Hi, I am trying to configure Open CMS 5.0.0 with mysql. But while Database and and table creation I am getting following error. Could no connect to database via: jdbc:mysql://localhost:3306/ java.sql.SQLException: Server configuration denies access to data = source

Re: A problem with access to data source, please help!!!!

2004-03-01 Thread Joshua J. Kugler
I had a bunch of problems setting up OpenCMS until I figured it out. OpenCMS tries to connect via the network socket, so the connection to the database may look like it's coming from the.host.name.com. You may need to add the full host name of the machine you are installing on to the

Test mail (please ignore)

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

Error installing MyODBC - Please help...

2004-02-19 Thread Morgan, Andrew R.
Hello all. I'm trying to 'make' MyODBC, and I receive the following error: gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/mysql/include/mysql -Iyes/include -O3 -DDBUG_OFF -c utility.c -Wp,-MD,.deps/utility.TPlo -fPIC -DPIC -o utility.lo /bin/ksh ../libtool --mode=link gcc -O3 -DDBUG_OFF -o

Installation Problem - PLEASE HELP

2004-02-18 Thread Morgan, Andrew R.
Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error during 'make': ld: fatal: library -lz: not found ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0 make[2]: *** [libmysqlclient.la] Error 1 make[2]: Leaving directory

Re: Installation Problem - PLEASE HELP

2004-02-18 Thread Alex Greg
Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error during 'make': ld: fatal: library -lz: not found ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0 make[2]: *** [libmysqlclient.la] Error 1 make[2]: Leaving directory

Re: Installation Problem - PLEASE HELP

2004-02-18 Thread Michael Stassen
Alex Greg wrote: Hi all. I am trying to install mySql on Solaris 2.6. I am getting the following error during 'make': ld: fatal: library -lz: not found ld: fatal: File processing errors. No output written to .libs/libmysqlclient.so.10.0.0 make[2]: *** [libmysqlclient.la] Error 1 make[2]:

RE: Installation Problem - PLEASE HELP

2004-02-18 Thread Morgan, Andrew R.
Thanks all.. that worked perfectly! -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 12:17 PM To: Morgan, Andrew R. Cc: [EMAIL PROTECTED] Subject: Re: Installation Problem - PLEASE HELP Alex Greg wrote: Hi all. I am trying

MySQL 4.0 crashed; Please help

2004-02-13 Thread Jacob Friis Larsen [Eksperten admin]
Can someone help me find out what caused this crash? My system is a Red Hat 7.3 on a HP Netserver LC2000, dual PIII 800mhz with 2.5G ram. 3 disks in raid 5. The MySQL database is 4.0.17 040212 19:27:36 read_const: Got error 126 when reading table ./exp4/sql_cache Number of processes running

Re: MySQL 4.0 crashed; Please help

2004-02-13 Thread vpendleton
Did you perform a stack trace? Original Message On 2/13/04, 2:36:42 AM, Jacob Friis Larsen [Eksperten admin] [EMAIL PROTECTED] wrote regarding MySQL 4.0 crashed; Please help: Can someone help me find out what caused this crash? My system is a Red Hat 7.3 on a HP Netserver LC2000, dual

Re: MySQL 4.0 crashed; Please help

2004-02-13 Thread Jacob Friis Larsen (Eksperten admin)
[EMAIL PROTECTED] wrote: Did you perform a stack trace? No, how do I do that? /Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.0 crashed; Please help

2004-02-13 Thread vpendleton
Here are the instructions for doing a stack trace. http://www.mysql.com/doc/en/Using_stack_trace.html Original Message On 2/13/04, 2:24:30 PM, Jacob Friis Larsen (Eksperten admin) [EMAIL PROTECTED] wrote regarding Re: MySQL 4.0 crashed; Please help: [EMAIL PROTECTED] wrote: Did you

Re: SQL select help required please

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

Re: Please help with check syntax

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

SQL select help required please

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

Re: SQL select help required please

2004-02-01 Thread Daniel Kasak
Matthew Stuart wrote: I am trying to create a html search results page with the following: SELECT * FROM tbl_allarticles WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue' The above works fine, but the below

Please help with check syntax

2004-01-29 Thread Aaron P. Martinez
I am trying to set up a table from a script that came with some software Value accounting/CRM and i'm getting a few errors, one of which i can't seem to figure out/fix. My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb tables configured with the following statement in my

Test!!!Please ignore this message

2004-01-26 Thread Gelu Gogancea
Title: Test!!!Please ignore this message Hi fellows, ...just a test.Please ignore this message. _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL

Please help with syntax for mysqldump

2004-01-13 Thread Matthew Stuart
I am really struggling with a mysqldump. I am trying to create a dump of a complete database called csi_db01 and I am trying to save the dump file to My Documents on the C drive. I am sure I am doing right, but could somebody email me the full syntax to use which comes after the mysql If I

Re: Please help with syntax for mysqldump

2004-01-13 Thread jeffrey_n_Dyke
I am really struggling with a mysqldump. I am trying to create a dump of a complete database called csi_db01 and I am trying to save the dump file to My Documents on the C drive. I am sure I am doing right, but could somebody email me the full syntax to use which comes after the mysql if

Re: Please help with syntax for mysqldump

2004-01-13 Thread zzapper
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart [EMAIL PROTECTED] wrote: I am really struggling with a mysqldump. I am trying to create a dump of a complete database called csi_db01 and I am trying to save the dump file to My Documents on the C drive. I am sure I am doing right, but could

Re: Please help with syntax for mysqldump

2004-01-13 Thread Hassan Schroeder
Matthew Stuart wrote: I am really struggling with a mysqldump. I am trying to create a dump of a complete database called csi_db01 and I am trying to save the dump file to My Documents on the C drive. I am sure I am doing right, but could somebody email me the full syntax to use which comes

Re: Please help with syntax for mysqldump

2004-01-13 Thread Matthew Stuart
mysqldump is run at the system command-line, not within the mysql client environment. This is most likely to be my problem then. I assumed that what is called the system command line to be the mysql client environment. The tutorial book that I have been going through instructs me to issue this

Re: Please help with syntax for mysqldump

2004-01-13 Thread zzapper
On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart [EMAIL PROTECTED] wrote: Similarly. SELECT intDEVID,txtDEVPOSTCODE INTO OUTFILE c:/aaa/dump.sql from ytbl_development; (dump.sql file must NOT already exist) zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/

Re: Please help with syntax for mysqldump

2004-01-13 Thread Andrew Boothman
Matthew Stuart wrote: mysqldump is run at the system command-line, not within the mysql client environment. This is most likely to be my problem then. I assumed that what is called the system command line to be the mysql client environment. The tutorial book that I have been going through

Fw: Please Help: Can you restore a dropped database

2004-01-06 Thread Gareth Lawrence
there was nothing in the file ... I read http://www.mysql.com/doc/en/DROP_DATABASE.html and it sounds like there is no hope for me But if anyway has any ideas or anything I can do, PLEASE let me know... .. Thanks, G.

Please Help: Can you restore a dropped database

2004-01-06 Thread Gareth Lawrence
there was nothing in the file ... I read http://www.mysql.com/doc/en/DROP_DATABASE.html and it sounds like there is no hope for me But if anyway has any ideas or anything I can do, PLEASE let me know... .. Thanks, G.

Please. i need help compiling mysql under CYGWIN

2003-12-29 Thread Fred
Can you send me the configure file + makefile configured for cygwin ? Version 3.23.58 please thanks alot!

Php mysql question please help

2003-12-25 Thread cohenstudio
I just started working with mysql and I'm very novice Created a simple database and programmed php to connect as follows... ?php include (webvars.inc); // webvars file is this //?php$user = ???;$hostname = ???;$password = pass; //$db=cs? $link= mysql_connect($hostname,$user,$password)or die

Re: Help me - please

2003-12-19 Thread Carlos André Moura de Amorim
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the error again. Please again!!! On Thu, 18 Dec 2003, Chris Elsworth wrote: On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote: 031217 14:32:34 Warning: setrlimit couldn't increase number

RE: Help me - please

2003-12-19 Thread Mechain Marc
You must be 'root' to do a ulimit -n 1024. Marc. -Message d'origine- De : Carlos André Moura de Amorim [mailto:[EMAIL PROTECTED] Envoyé : vendredi 19 décembre 2003 14:55 À : Chris Elsworth Cc : [EMAIL PROTECTED] Objet : Re: Help me - please i added ulimit -n 1024 in mysql_install_db

Re: Help me - please

2003-12-19 Thread Victor Medina
the error again. Please again!!! On Thu, 18 Dec 2003, Chris Elsworth wrote: On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote: 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) It might be worth

RE: Help me - please

2003-12-19 Thread Carlos André Moura de Amorim
de Amorim [mailto:[EMAIL PROTECTED] Envoyé : vendredi 19 décembre 2003 14:55 À : Chris Elsworth Cc : [EMAIL PROTECTED] Objet : Re: Help me - please i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the error again. Please again!!! On Thu, 18 Dec 2003, Chris

RE: Null-safe equal help, please

2003-12-19 Thread Knepley, Jim
. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 8:44 AM To: Knepley, Jim Cc: [EMAIL PROTECTED] Subject: RE: Null-safe equal help, please Please reply to the list so that others can follow this discussion. Thanks. At 8:26 -0700 12/17/03, Knepley, Jim

please give me help in important decision!

2003-12-18 Thread [EMAIL PROTECTED]
hello, i'm working on a java-jsp-page with mysql-connection. now i've created a test-system with myisam-tables where the tables are just read. my plans for next weeks are, to make the owner of the site capable of entering/changing his data by his own - web-based and multi-user-capable. as

Re: please give me help in important decision!

2003-12-18 Thread Martijn Tonies
Hi Hans, i'm working on a java-jsp-page with mysql-connection. now i've created a test-system with myisam-tables where the tables are just read. my plans for next weeks are, to make the owner of the site capable of entering/changing his data by his own - web-based and multi-user-capable. as

Re: please give me help in important decision!

2003-12-18 Thread Martijn Tonies
Hi Hans, Please reply to the MySQL list instead of personally. hi martijn, thank you very much for your help. my replies are further down... * if yes: how can i change them for the real-system (the homepage), that uses packed myisam-tables (because there is no writing, only reading from db

Help me - please

2003-12-18 Thread Carlos André Moura de Amorim
Warning: Changed limits: max_connections: 100 table_cache: 73031217 14:32:35 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin

<    1   2   3   4   5   6   7   8   9   10   >