[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
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
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
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=
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
..
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
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
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/
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
---
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
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'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
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
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
-
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
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
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
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.
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*
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
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
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
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
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
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
27 matches
Mail list logo