HI
I am trying to install mysql++.
I did automake, autoconf ./configure, make and make install.
When I add this row in kdevelopp / C++
#include
this message appears:
"In file inclued from /usr/local/include/sqlplus.hh:9,
from main.cpp:24:
/usr/local/include/defs:5: mysql.h: No folder or director
On Wed, 24 Jan 2001, Xinkun Wang wrote:
|
|I've got a problem about Mysql table. if I insert several records in a
|certain order, firstly it is ok, but when I delete them and insert those
|records again (in the same sequence), But the order in MySql is totally
|different. For instance, I have 7
Hello there,
We have a number of Sun sparcs connected to 2 NetApp file servers, and are
currently using 1 sparc running mysql with the databases residing on one
of the NetApps. I would like to run a 2nd sparc mysql server, also
serving the same databases (read-only) from the same NetApp. Is th
Hello,
I'm using FORTRAN (f2c, g77) on an linux machine (SuSE 6.4,
7.0). Is there any solution to
use mysql from my programs? I have experience in using mysql
from Perl and from VB (Win**).
Thank you for help.
Manfred Meier
Hello there,
We have a number of Sun sparcs connected to 2 NetApp file servers, and are
currently using 1 sparc running mysql with the databases residing on one
of the NetApps. I would like to run a 2nd sparc mysql server, also
serving the same databases (read-only) from the same NetApp. Is thi
I think I have stuffed up the installation of the MySQL thing. I am trying
to get it installed onto a Debian box and am not having alot of luck :o|
http://www.scanners.8m.com/config.html
Any help would be appreciated,
Cheers
Dan Clark
Information Systems
System Support
HealthCare Otago
5046
so you want to list all of them starting with the highest level and going
up to the lowest level?
On Mon, 29 Jan 2001, Oliver Joa wrote:
> Hi,
>
> I have a recursive Problem. I have a Table with columns "id", "name" and
> "pid". E.g:
>
> name1
> name11
> name12
> name121
> name122
I just want to ask a quick question which is probably only indirectly related
to this group. Where can I find some useful info on how to integrate MySQL
into Apache authentication scheme? Basically, I want to use MySQL database
to store users' ids and passwords rather than .htpasswd file gen
Are you sure that your select is in fact using the index on that column? Could
you please explain select for us.
John Jensen wrote:
> To: "Scott Gerhardt" <[EMAIL PROTECTED]>
> >From what I have heard from a local guru. you shoud double that
> again. I had mysql working fine on 150 meg for dev
Hi,
I have a recursive Problem. I have a Table with columns "id", "name" and
"pid". E.g:
name1
name11
name12
name121
name122
name13
name2
name21
In the Table it would look like:
id, name, pid
1 name1 0
2 name11 1
3 name12 1
4 name121 3
5 name122 3
6 name13 1
7 name2
To: "Scott Gerhardt" <[EMAIL PROTECTED]>
>From what I have heard from a local guru. you shoud double that
again. I had mysql working fine on 150 meg for development purposes,
but I was warned that as soon it had to support any kind of traffic,
anything less than 500 meg would be quickly maxed o
On Sun, Jan 28, 2001 at 02:59:21PM -0700, Andrei Cojocaru wrote:
> Where can I see a list of changes that were made in 3.23.3x versions
> of mySQL?
They are listed in the manual. Check the table of contents.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 3
Your TEXT does not appear to be defined as a fixed-length variable.
As I understand it, you can't index and search on a variable-length
TEXT field.
On 28 Jan 2001, at 21:46, Richard Heyes wrote:
> Hi,
>
> Having trouble with indexing TEXT column types, for the purpose of a
> basic search engin
Where can I see a list of changes that were made in 3.23.3x versions of
mySQL?
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Hi,
Having trouble with indexing TEXT column types, for the purpose of a basic
search engine (without match/against). I've got the following table
structures, the second being the index table containing an entry for each
word in the TEXT (from the first table), minus stop-list type words. The
col
> Hello smart people,
>
> My question is:
>
> Is this three stage action possible with one SQL statement?
>
Yes you can do a query like:
select books.title from
words as w1,words as w2, wordlinks as v1,wordlinks as v2,books
WHERE (w1.WordNumber =v1.WordNumber ) AND (w2.WordNumber =v2.WordNum
> Here's the situation:
>
> table: books
>
> |BookNumber |Author|Title |
>
> | ... | ||
> | 312 |'TWAIN, MARK' |'H
Hello smart people,
Here's the situation:
table: books
|BookNumber |Author|Title |
| ... | ||
| 312 |'TWAIN, MA
no I started with the command line client and you don't need a shell, if
you have the client you can connect to remote mySQL servers if they allow
outside connections
On Sun, 28 Jan 2001 [EMAIL PROTECTED] wrote:
> can one 'get in' and control MySQL through OS X pb's Terminal app?
> (various Uni
can one 'get in' and control MySQL through OS X pb's Terminal app?
(various Unix shells.)
i think i need a GUI to start though, don't you?
At 11:48 AM -0700 1/28/01, Andrei Cojocaru wrote:
>there is the mysql command-line client, it's under bin under the
>mysql
there is the mysql command-line client, it's under bin under the mysql
base directory, it's called mysql on UNIX and mysql.exe on win32
:-) command line all the way!
and dumb too!
if(?) there is no app to launch, i.e., no GUI (Mac OS Xpb) -how do i
manipulate MySQL?
if you say "RTFM" -where is that? or a site perhaps?
thank you.
(seems kind of broad for a list archive search.)
p.s. i know there are front-end GUIs available, which do you folks
recommend?
Good Evening!
I've been working with VB and MySQL for awhile now, but not together. I've used VB to
use the built in database that comes with VB, but I doubt I'm using it to its full
potential.
I like the way PHP and MySQL interface, very naturally actually. I was hoping that I
could take my
I'm a newbie so this may be a simple one to answer. If you can give me the specific
commands that I need to do that would be appricated.
Ok, I am running on A Cobalt RAQ 4 Server with MySQL installiaton. one of my sites
is running a MySQL database. When he trys connecting to the database, h
I posted the solution a couple of nights ago. The mysql folder and some of
the files within have the owner set to root. You need to change that to
mysql.
> From: anthony ortega <[EMAIL PROTECTED]>
> Date: 27 Jan 2001 22:46:25 -0800
> To: [EMAIL PROTECTED]
> Subject: simple problem with mysql inst
Unfortunately, the OpenBSD threads library has been known to be
problematic at the moment, try using MySQL with the Pth threads library
in the meantime. This can be automated quite easily by using the pth
FLAVOR of the MySQL port. "make FLAVOR=pth install".
// Brad
[EMAIL PROTECTED]
[EMAIL PROTE
Very, very cool. What will happen to the licensing and/or price for this
version?
Lee
-Original Message-
From: Britt Johnston [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 28, 2001 2:16 AM
To: Vinny; Mysql List
Subject: RE: OK, I'll bite
NuSphere announced Gemini a few months a
Hello
I realised several SSL keywords in the Makefiles but cannot find a way to
activate SSL/TLS via ./configure. Did I miss something or is there no SSL
support implemented yet? Can I expect it for the future? (Would be great!)
bye,
-christian-
--
Save the forests, eat more
I have no idea what 'apt-get' is. MySQL, IMHO, should always be
installed from the sources by compiling by hands. Get the sources
and learn to install it correctly.
- Original Message -
From: "John-Mark" <[EMAIL PROTECTED]>
To: "Artem Koutchine" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Se
OK I get what you mean except that I installed on debian potato and
therefore do not have the reinit step since I used apt-get. Do you have any
ideas on this one.
Thanks again jm
- Original Message -
From: "Artem Koutchine" <[EMAIL PROTECTED]>
To: "John-Mark" <[EMAIL PROTECTED]>; <[EMAIL P
David Wilde writes:
> Hello All,
>
> I am new to MySQL and I am sure you have all heard this question a million
> times, so I appologize in advance. My question is, I have installed MySQL
> on a slackware 7.1 box, as well as a SuSE 7.0 box, and both seem to be
> running fine with one minor
Why not just reinit the database as specified in the
last step on install (after make install) in the manual.
No need to delete your database, just back them up
somewhere else. Then delete eveyrthing in your
localstatedir (where thedatabases are) including
'mysql' dir. Do reinit, and copy back al
Hello all
I have made a mess of the grant table and have no way now of gaining access
to any of the databases I have set up or tables. Is there any way I can
start from scratch with the grant table by going back to a situation were
all databases are deleted and no access privileges are set up. is
i don't know exactly, but based on the message it seems to be
a permission problem in the mysql rights. So, RTFM on
the mysql permission model and commands.
- Original Message -
From: "Velamarthy Murthy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 28, 2001 3:08 PM
Dear Sir,
Hello,
We have installed MySql in Windows NT Server.
MysqlAdmin services are doing fine and but when we try
to enter the prompt of mysql.we are getting the
follwing error
ERROR :1045
Access denied for user 'odbc@localhost )using password
yes
port is:3306 and user is :root
How to r
You might take a look at my message about
MySQL 3.23.32 and FreeBSD 4.2-stable
try doing what i did there. I did it only
yersterday but so far not sig 11.
Me message is posted yersterday and it has
FreeBSD 4.2-stable in the subject and it is from
me (Artem Koutchine). Search for it.
- Origi
On the slave err log I have:
010128 11:04:28 Slave: Failed reading log event, reconnecting to retry,
log 'FIRST' position 4
010128 11:04:28 Slave: reconnected to master
'repl@glenastle:3306',replication resumed in log 'FIRST' at position 4
010128 11:04:28 Slave: received 0 length packet from
Running the standard (brand-new) OpenBSD install of MySQL from
/usr/ports/databases/mysql/
Version 3.23.32 - the port that Brad made just a few days ago. No
options. Just "make install".
It works fine exceptI keep getting this error:
ERROR 2006: MySQL server has gone away
It comes back immed
Hallo ...
I tried to create simple replication:
2 machines
mysql-3.23.32
master - name register
slave - nane proxy
master configuration:
[mysqld]
set-variable = max_connections=300
log-bin
server-id=1
slave configuration:
[mysqld]
master-host=register
master-user=replicate_user
master-password
Hello monty,
It seems like something changed in 3.23.31 and 32 in auto_repair
there.
I see on many servers after crash (i've resently got unexpected
powerdown for 10 of my machines so it worked like a good testcase) I
got tables failed to be repaired (or well selects fail on them)
28.Jan 12:26:
Hello All,
I am new to MySQL and I am sure you have all heard this question a million
times, so I appologize in advance. My question is, I have installed MySQL
on a slackware 7.1 box, as well as a SuSE 7.0 box, and both seem to be
running fine with one minor exception. When using mysqlgui from
41 matches
Mail list logo
