Somebody install Mysql and apache for me, but forgot to set it auto-boot
Each time i reboot i need to do
# safe_mysqld --log --user=mysql &
and
# apachectl restart
I want it auto-boot, what can i do?
François Boucher
[EMAIL PROTECTED]
Thank you very much for your help. I got it fixed with the command
'safe_mysqld--old-protocol &' Thank YOU!!!
-Original Message-
From: Nico D [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:44 AM
To: Simon Green
Cc: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject: RE: emergency hel
mysql> desc logs ;
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---+
| USERNAME | varchar(8)| | PRI | | |
| TITLE
Disclaimer: I am new to MySQL, and don't know the correct procedure for
submitting bugs. A quick search on Google and the MySQL site provided no
clear answer to my problem.
My setup: Pentium II 350 MHz, running Win98. 64MB RAM.
What I tried to do: I attempted to run C:\mysql\bin\mysqld from
thats because your server isn't running. mysql is the client
(AFAIK). But if your running redhat, you can
/etc/rc.d/init.d/mysql start
and it should work
-nico
> -Original Message-
> From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]]
> Sent: 04 June 2001 15:10
> To: 'Simon Green'; '[EMAIL PRO
What is the owner/group permissions on /usr/local/var also is there
an error message in the file /usr/local/var/myserver.mydomain.err ?
The mysql user must have all permissions on the directory in order to
read and write.
Ken
-
Ken Menzel ICQ#
Hi!
It was the same rollback bug which caused also crash in the case
you ran out of tablespace. I had overlooked that the same bug causes
problems also if you rollback a transaction which has updated the
same row more than once.
You can download the fixed /mysql/innobase/row/row0undo.c from
my w
when I run this query
SELECT TT101991666187.crcid, TT101991666187.sum,
TT201991666187.sum, names.item
FROM TT101991666187 USE INDEX(PRIMARY)
INNER JOIN names USE INDEX(PRIMARY)
ON (TT101991666187.crcid = names.crcid and names.type = 29)
LEFT JOIN TT2000
"Ouyang, Sunny" wrote:
>
> Yes. Here it is:
>
> mysqld started on Sat May 5 14:02:18 EDT 2001
>
> /usr/local/libexec/mysqld: ready for connections
>
> mysqld started on Wed May 9 19:19:34 EDT 2001
>
> /usr/local/libexec/mysqld: ready for connections
>
> 010524 10:41:04 Found invalid pass
> >php nothing error: when make and make install
> >./configure --with-mysql=/usr/local/mysql \
> >--with-apache=/usr/src/apache \
> >--enable-track-vars
I have a question. What should go after --with-mysql for RPM installtions?
I cannot find the answer to this question anywhere.
Thanks,
Neil
Yes. Here it is:
mysqld started on Sat May 5 14:02:18 EDT 2001
/usr/local/libexec/mysqld: ready for connections
mysqld started on Wed May 9 19:19:34 EDT 2001
/usr/local/libexec/mysqld: ready for connections
010524 10:41:04 Found invalid password for user: '[EMAIL PROTECTED]';
Igno
ring us
"Ouyang, Sunny" wrote:
>
> Yes. All of our mysql databases are there.
>
Do you have error log file? It should be in /usr/local/var
> -Original Message-
> From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 04, 2001 10:28 AM
> To: Ouyang, Sunny; '[EMAIL PROTECTED]'
> Su
I found my '/tmp/mysql.sock' is also empty. Is this supposed to be empty?
my '/tmp/myscript' is empty, too. Are they correct?
-Original Message-
From: karel pitra [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:33 AM
To: Ouyang, Sunny
Subject: Re: emergency help
check whethe
Hi Brian,
I checked boot.log and found the following message. I don't know whether
this causes the problem. Do you know what is DSO module? Do I really need
to recompile it? If so, how I can recompile it?
Jun 4 09:44:23 mothra httpd: [Mon Jun 4 09:44:23 2001] [warn] Loaded DSO
modul
es/mod_
Oh. forget it. it is not free!
tks again
regards
Peter Kok
Below is script for installing apache + php + mysql, it worked before
MySQL/PHP3/Apache Installation:
By default RedHat will have installed Apache web server on your computer. We
will need to remove it before we can
continue. If you ex
Hi Britt
Tks for your reply
is it free of charge? if yes
please guide me. tks much
regards
Peter
>From: "Britt Johnston" <[EMAIL PROTECTED]>
>To: "Peter Kok" <[EMAIL PROTECTED]>
>Subject: RE: install apache, php + mysql on linux redhat 6.2
>Date: Mon, 4 Jun 2001 09:55:30 -0400
>
>You might w
Alright alright...
I didnt want to believe it, but our disk is really full (got some funny
things going on at server terminal UGH!).
I hope my query will work okay once we get the server organized.
Thx anyways ;)
Nessi
-
Befo
I got the message:
[root@mothra /tmp]# safe_mysqld &
[1] 3922
[root@mothra /tmp]# Starting mysqld daemon with databases from
/usr/local/var
mysqld daemon ended
This is what I got when I rebooted the Linux server.
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Se
Yes. All of our mysql databases are there.
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:28 AM
To: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject: Re: emergency help
> I got the message:
>
> [root@mothra /tmp]# safe_mysqld &
>
> [1] 392
Hello,
I am trying to make a fulltext search over columns from two tables.
The queer thing is: sometimes it works, but more often I get the error message:
Got error 28 from table handler (in mysql_error output).
I am not sure what error 28 is, I checked the manual but couldnt find anything.
The q
> I got the message:
>
> [root@mothra /tmp]# safe_mysqld &
>
> [1] 3922
>
> [root@mothra /tmp]# Starting mysqld daemon with databases from
> /usr/local/var
> mysqld daemon ended
>
Are your databases in there? If you do a
ll /usr/local/var
Do you see a directory for each database of yours,
Ok so have you tride runing /usr/local/mysql/safe_mysqld &
Simon
-Original Message-
From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 15:10
To: 'Simon Green'; '[EMAIL PROTECTED]'
Subject: RE: emergency help
no. Not at all. I logged into Linux server, type mysql. the s
> Last Saturday when I rebooted Red Hat
> Linux, mysql database server didn't come back any more.
Try typing this on the command line:
safe_mysqld &
Then tell us what happens. :-)
L.A.
-
Before posting, please check:
htt
no. Not at all. I logged into Linux server, type mysql. the server gave
the message says : "error 2002: can't connect to local MYSQL server through
socket '/tmp/mysql.sock". Anyone has idea what's wrong with it?
-Original Message-
From: Simon Green [mailto:[EMAIL PROTECTED]]
Sent: Mond
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class:
Paul
I am a newbie regarding MySQL but have been using Postgresql, DB2 and
for years Sybase..
My installations are Linux (Caldera 2.3 & 2.4), OS/2 and WinNt.
My needs are a lan / Wan database..encompassing above OS's.
Problems: DB2 in Lan format too expensive
Postgresql w/ JDBC will not
Ok. This is what I think you are wanting. Have a datetime field or even a
datestamp. Before you insert, do a select to find the value of the most
recent row that was added then you can calculate what you should insert from
there.
BTW you should include history incase some else has ideas.
Is mysqld runing?
Simon
-Original Message-
From: Ouyang, Sunny [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 14:56
To: '[EMAIL PROTECTED]'
Subject: emergency help
Hi,
I am seeking emergency help to start up mysql database server. I tried to
use myodbc to connect mysql database from win
Hi,
I am seeking emergency help to start up mysql database server. I tried to
use myodbc to connect mysql database from windows. I added a user on mysql
database user table and db table. Last Saturday when I rebooted Red Hat
Linux, mysql database server didn't come back any more. I don't know
Hi Richard,
In order for people to help you you will need to be more specific.
As specific as possible. Many of us here run FreeBSD and could help
you with more information. Possibly the problem is you are running
FreeBSD-current instead of FreeBSD-stable? Or FreeBSD 4.3? The
output from una
I am trying to get a (third party) client application working which needs to be
linked with "libmysqlclient". The application is implemented as a shared
library. I can't get this working: I have installed MySQL from the Solaris
binary release, which has a "libmysqlclient.a", but I do see mention
> I have only had a quick look over this and already have a question for the
> simple example you've provided. How are you determining the last value
> entered before entering the new value? The only way I see you of
> effectively accomplishing this is through the use of a datetime column. Or
>
Hi,
I notice a strange behaviour with OPTIMIZE TABLE and ANALYZE TABLE (on MyISAM table) :
Before analysing my table, mysql show me :
mysql> show index from forumcontpresencepc6;
+--++---+--+-+---+-+--+-
David Ayliffe writes:
> Does anyone have any SIMPLE proggies written in C++ using the MYSQL++
> API library? Preferably MS Visual Studio 6 format. If so can you please
> provide me a link for them or contact me over email directly.
>
> I'm having problems compiling a project that just connects t
Does anyone have any SIMPLE proggies written in C++ using the MYSQL++
API library? Preferably MS Visual Studio 6 format. If so can you please
provide me a link for them or contact me over email directly.
I'm having problems compiling a project that just connects to the server
issues a query and
> I have only had a quick look over this and already have a question for the
> simple example you've provided. How are you determining the last value
> entered before entering the new value? The only way I see you of
> effectively accomplishing this is through the use of a datetime column. Or
>
Hi!
The MySQL manual states that you can use ORDER BY in combination with the
UPDATE statement.
So I tried to use it, but it didn't work. Here is the sql query that's causing
the trouble:
mysql> UPDATE alarms SET is_parsed=1 WHERE is_parsed=0 ORDER BY is_parsed LIMIT
1;
ERROR 1064: You have a
On 04-Jun-01 Harsh wrote:
> I have a table1 in mySQL with the following recordset :
>
> +++-+
>| siteno | deptid | agentid |
> +++-+
>| 0 | 27 | 35 |
>| 0 | 25 | 30 |
>| 0 | 19 | 30 |
>| 0 | 19 |
Ben Escoto writes:
>
> For the first:
>
>
>+---+--+---+---+-+---++-+
> | table | type | possible_keys | key | key_len | ref | rows | Extra
> |
>
>+---
database, sql
Hi there
I am battling to find out how to insert images into a blob field with visual
basic, and then read the information from the db and display in a picture
box. Has anyone got a sample of how to do this? I have inserted the image
into the blob field, but am not sure if the way
hello,
does mysql allow for recursive SELECTS?
is there a way to select a 'path in a tree' in one query ?
(the tree is stored in the following form:
parent_id int
id int
)
i know the ID of an element in n-th level of the tree, and i need
to get all its parent elements
-
I have a table1 in mySQL with the following recordset :
+++-+
| siteno | deptid | agentid |
+++-+
| 0 | 27 | 35 |
| 0 | 25 | 30 |
| 0 | 19 | 30 |
| 0 | 19 | 26 |
| 0 | 20 | 26 |
Hi
Within mysql, all queries return the time taken to execute, ie
20 rows in set (0.77 sec)
35 rows in set (1.33 sec)
etc.
Is it possible within perl, or C for that matter, to get the time taken for the MySql
server to get the data ?
Thanx
Simon
--
Simon Windsor
CricInfo http://www.crici
I have only had a quick look over this and already have a question for the
simple example you've provided. How are you determining the last value
entered before entering the new value? The only way I see you of
effectively accomplishing this is through the use of a datetime column. Or
am I miss
Hello,
i'm writing an application in java and i have the following problem :
when i insert a record into a mysql table through the executeUpdate() method
of either Statement or PreparedStatement, does the method return immediately
or does it wait until MySql has the data written into the dat
I've been frying my brain over this problem for the past 24 hours and I'll
be very grateful for any hints.
I'm trying to recognize when the value for a field is changing value from
one record to the next. For an example, look at this:
mysql> select sezione from faq limit 20;
+---+
| sezi
Hi,
We are developing a portal which has pictures
of machines in the form of HTML pages.
I want to know whether I can store HTML in Database
& can I do search in the HTML pages stored.
Please let me know at the earliest.
Thanks in advance
Infiniti. Infotech India
Powered by MediaRing
select abc AS date from mytables;
Simon
-Original Message-
From: Alec Smith [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 09:30
To: Don Read
Cc: [EMAIL PROTECTED]
Subject: RE: Proper date query conversion structure?
Ok, dumb mistake... Remind me not to code so late at night. :)
With t
How can I install the perl MySQL module (along with DBI) on a system
that will only be used as a client without installing the MySQL source
tree ?
Thank you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
Is it possible to use in MySQL 3.23.xx data type DECIMAL with 20 (maybe
more) significant digits?
Tests so far failed above 16 digits.
Thanks you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Ted Fiedler
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Releas
Hi,
I have trivial a question: how long can a MySQL query be?
Robert
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this th
Ok, dumb mistake... Remind me not to code so late at night. :)
With that fixed, I now get
mysql> select DATE_FORMAT(post_timestamp, '%M %d, %Y') from guestbook;
+--+
| DATE_FORMAT(post_timestamp, '%M %d, %Y') |
+--+
www.devshed.com has a nice tutorial.
Bye,
B.
At 22:41 3-6-01 -0400, Peter Kok wrote:
>Hi all
>
>I installed the following version on redhat 6.2 but failed on installing
>apache finally!
>Please teach me
>
>apache 1.3.19
>php-4.0.5
>mysql-3.23.38-pc-linux-gnu-i686.tar.gz
>
>mysql can start: /
On 04-Jun-01 Alec Smith wrote:
> What would be the correct query to convert a date stored in MySQL in
> a
> DATETIME field to month_name month_date, year format at the same time
> I'm
> pulling a bunch of other data from the same row as the field with the
> date I need converted? I've tried somet
What would be the correct query to convert a date stored in MySQL in a
DATETIME field to month_name month_date, year format at the same time I'm
pulling a bunch of other data from the same row as the field with the
date I need converted? I've tried something like the below without
success:
SELECT
Hey,
First of all, I want to say thank you to everyone that replied to my post a week
ago. I find it exceedingly humorous that large companies refuse to embrace open source
in favor of Microsoft or Sun because they fear not having the support when they need
it. I don't think that M
57 matches
Mail list logo
