[EMAIL PROTECTED] wrote:
> Hello to All,
>
> Would you mind to help as the title of mail ?
>
> Thanks !
>
> Edward.
>
What problems are you having?
Have you read the Manual yet?
I'd suggest going with a real operating system (linux) which keeps patc
the script to fix the privileges. The I restarted mysqld -- tested
everything and found that it worked perfect. Then I updated to
4.1.5 which brought me to the current situation.
Help anybody???
Best regards, Stefan Wolf.
--
MySQL General Mailing List
For list archives: http://lists.mysq
14 10:11:00 mysqld ended
>How-To-Repeat:
Install and start server using bin/safe_mysqld --user=mysql
>Fix:
???
>Submitter-Id: Steven Wolf, Wolfgang Mueller
>Originator:root
>Organization:
IuW, FH Darmstadt
>MySQL support: none
>Synopsis: mysqld 3.23.51 crashes at
Hi!
After some tries i finally managed to compile mysql 4.0.17 with
ssl-support (openssl 0.9.7c, compiled with minGW 3.1.0.1)
under windows2000.
SHOW VARIABLES LIKE 'have_openssl' returns YES.
when starting the server the following happens:
$>mysqld.exe --port=3306 --ssl-ca=cacert.pem --ssl-cert=
I am attempting to create a link from a dbase (.dbf) database to a mysql
database. Here's the description:
dbase file is a file that gets updated on a daily basis. Changes to this
file can be a change in a record or the addition of a record. no record
is 'deleted'. Updated/new records include
..
David Wolf
p.s. PLEASE can you put a [mysql] tag on the list???
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Not realy because "ORDER BY" is an MySQL command...
Greetings,
Hakan Wolf
-Ursprüngliche Nachricht-
Von: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 2. Oktober 2001 22:14
An: Hakan Wolf
Cc: 'MySQL Mailinglist'
Betreff: Re: sort mysql data
On Tue
he wrong way.. But, I can't quite
get a clue.
Can anyone help me out here?
Thanks!
David Wolf
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
David
- Original Message -
From: "David Hugh-Jones" <[EMAIL PROTECTED]>
To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 6:19 PM
Subject: Re: Query help...
>
> Try
> SELECT lastip,use
7;t give what I want :(
David
- Original Message -
From: "Steve Meyers" <[EMAIL PROTECTED]>
To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 2:38 PM
Subject: RE: Query help...
I think you're looking fo
Thanks!! Worked like a dream! I'm not quite sure why it knew to pull only
ip's that are in there more than once though?
David
- Original Message -
From: "Steve Meyers" <[EMAIL PROTECTED]>
To: "David Wolf" <[EMAIL PROTECTED]>; "Steve Meyers
I actually find the command line databases way easier to use than graphical
ones. You have more direct control over them, and they are leaner/faster
than GUI based ones. However, there are GUI based admin tools that you can
get from the MySQL website so you can feel more 'at home'.
I was a *real*
I have a query as follows:
SELECT log.entity, log.action,
LEFT(users.username,10) AS username,
LEFT(boards.title,15) AS Board,
LEFT(topics.subject,22) as Subject,
log.postid, log.extraid,
LEFT(from_unixtime(log.logtime),19) AS time, log.ip
FROM log LEFT JOIN users ON log.userid = users.
I've been trying to play with MySQLGUI lately (running the win32 version of
the GUI, Linux version of the server). I can connect fine. Run queries fine.
But, when I try to do any grants on a database or edit a table, the client
connects to the server as many times as it can (before the server runs
I have a query as follows:
SELECT log.entity, log.action,
LEFT(users.username,10) AS username,
LEFT(boards.title,15) AS Board,
LEFT(topics.subject,22) as Subject,
log.postid, log.extraid,
LEFT(from_unixtime(log.logtime),19) AS time, log.ip
FROM log LEFT JOIN users ON log.userid = users.
Yes.. There is an index on users.username :)
David
- Original Message -
From: "Tore Van Grembergen" <[EMAIL PROTECTED]>
To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 28, 2001 8:46 AM
Subject: Re: Optimizing query
How do you do a compound index to index between two tables?
David
- Original Message -
From: "Tore Van Grembergen" <[EMAIL PROTECTED]>
To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 28, 2001 8:57 AM
Subject: Re: Op
-
From: "Tore Van Grembergen" <[EMAIL PROTECTED]>
To: "David Wolf" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 28, 2001 8:57 AM
Subject: Re: Optimizing query (2nd attempt)
> maybe you heva to declare a compound index with userid and userna
Not quite fixed.. When I run the query without limiting by time, it still
fails to use the userid key. i.e. if I only select where
users.username="testuser", I'd expect that users.username to return the
users.id=2, and to search using the indexed log.userid=2
David
4 | log.topicId |
1 ||
+++---+-+-+-+---
--++
4 rows in set (0.00 sec)
It's just simply not using the index on users.. Did I miss something?
David
- Original Message -
From: "Bill Adams" <[EMAI
I'm using the following query
SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
FROM archive a, archive b
WHERE a.status='s' AND a.addrdsp IS NOT NULL
AND a.addrdsp = b.addrdsp AND a.solddate < b.solddate
AND date_add(a.solddate, interval 1 year) > b.solddate
ORDER BY a.add
Yes.. It is the windows version of MySQLGUI that I am using. Windows 2000
SP2
David
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, November 03, 2001 4:14 AM
Subject: Re: MySQLGUI hangs on certain command
I need to replace some data with data from a backup. Here's the scenerio...
I have 2 databases. a and abak
a and abak are the same (but, ones a few hours old with the right data ;) )
a and abak have a table, posts and a field 'attach'. I'd like to take
the data from abak.posts.attach and place
Hello Gleb,
> Please read the notes about MySQL on Linux:
>
> http://dev.mysql.com/doc/mysql/en/Linux.html
I don't find anything specific to my problem there, sorry!
My Linux installation seems to be missing something that the
bdb part of MySQL 4.1 needs and which was not needed by v4.0
and b
Hi!
I am currently installing and testing the latest
stable version of mysql with an sunblade 1000
workstations (2 cpu, 750 MHz, 1 GB RAM).
Does anybody know some hints how to tune
the OS (solaris performance tuning).
Thanks in advance
Wolf
I m running a mysql-server 3.23.49 under suse 6.4 (kernel 2.2.14) and
myodbc 3,51 .. I have an mdb file and want to export the tables from
access 2002 to the mysqldb .. I can connect to the db and read the
tables .. but when I want to export them .. I get a syntax error ???
What is wrong
---
onnel"
DoCmd.Close
DoCmd.OpenForm stDocName
DoCmd.GoToRecord , , acNewRec
Anyone knows ???
Greetings wolf
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
27 matches
Mail list logo
