Hi,
We are doing a project with combination of ASP & MYSQL (backend).
We are having some problem for setting relationship between the tables.
We have to know whether foreign key will be supported in MySQL and we came to know
that there is no use for foreign key(as per your documentation: The
Hello ,
to build a database using SQL Server, from where shall I start ? I mean,
what shall I install on my Server, and how can I work with MySql ? sorry Iam
a new in the area, and I need help ...
Hanan
_
Get Your Private,
MS office professional 2000 FULL version for $140 !!! NEW !!
If interested email at [EMAIL PROTECTED]
Verified Business Paypal owner so purchases FULLY protected
Verified Aol subscriber
Verified Address
Not burns,oem,accademic,charity,demo or otherwisebut FULLY hologrammed
authentic ms off
As of version 3.23.33 MySQL became attractive to deploy in our project
because it now includes (preliminary, though) support for full text
indeces. That is a GREAT advantage to prior versions. So,
congratulations for that feature, with that MySQL is definititly moving
on the right path and I'm
Keneth wrote:
>
> "When I try to dump sql database it gives me some errors 1.Error 1045
> mysqldump --opt database > backup-accp.sql mysqldump: Got error: 1045:
> Access denied for user: 'accp@localhost' (Using pass word: NO) "
>
> can you help?
Please read the manual and list archive!
> Befor
Hi!
On Mar 12, Martin Rode wrote:
>
> Now, unfortunately the FULLTEXT support as it stands right now has a few
> drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
> 60MB) in my test table.:
>
> - searches for words with hits < 100 are reasonably fast (<1 sec.)
> - searches wi
Sorry, it appears to be _not_ a bug in mysql 3.23.34 but a conflict with the
apache module mod_auth_mysql.
It's still weird since i only noticed after installing 3.23.34, and had no
problems herefore.
Downgrading to a earlier version however did not solve the problem!
My collegue installed the mo
I have a mysql server running.
I would like to be able to select from the mysql DB, but get mysql to go
to a remote Informix DB to get the data.
Is there anyway of doing that?
MArk
-
Before posting, please check:
http://www.m
>Description:
I`ve compiled the source package 3.23.32.
CFLAGS="-DHPUX -I/opt/dce/include" CXXFLAGS="-DHPUX -I/opt/dce/include
-felide-constructors -fno-exceptions -fno-rtti" CXX=gcc ./configure --with-pthread
--with-named-thread-libs='-ldce' --prefix=/usr/local/mysql --disable-s
Perl DBI with the Mysql and the Informix drivers installed.
Curtis
- Original Message -
From: "MArk Williams" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 7:21 AM
Subject: Can mysql read from Informix
> I have a mysql server running.
> I would like to be abl
Hi!
just downloaded MySQL, and compiled the c-code example located in
MySQL\examples\libmysqltest
It works fine for the default database called mysql ... but not for any
of the other databases.
Any clue?
Best Regards,
Christer
-
Sergei Golubchik wrote:
> Hi!
>
> On Mar 12, Martin Rode wrote:
> >
> > Now, unfortunately the FULLTEXT support as it stands right now has a few
> > drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
> > 60MB) in my test table.:
> >
> > - searches for words with hits <
Can someone point me to a comparison of the three different transaction-based table
types in MySQL? It is unclear from the on-line documentation what the
benefits/features/limitations are for each of these types.
Thanks
Ray
--
--
Justin writes:
> Thank you Sinisa,
>
> I actually did try the upgade, but rapidly reverted due to errors
> such as these:
>
> mysqld got signal 11;
> stack range sanity check, ok, backtrace follows
> 0x812cfea
> 0x809f541
> 0x809da87
> :
> :
> etc
>
> AND...
>
> read_const: Go
Gary Shea writes:
>
> Sorry, this is my fault for not describing the problem better.
> Here's the result I get with DISTINCT (I've given the columns
> names to make the table smaller, but not changed the SQL from what
> I sent in the bug report):
>
> +---+
> | i |
> +---+
> | 1 |
> |
Jordan Russell writes:
> Seems like MySQL 3.23.34a has a problem (?). I'm using the RPMs from the
> MySQL web site on RH 7.0.
>
> CREATE TABLE files (
> id int(11) NOT NULL auto_increment,
> folderid int(11) NOT NULL default '0',
> name varchar(100) NOT NULL default '',
> date dat
[EMAIL PROTECTED] writes:
> >Description:
> I`ve compiled the source package 3.23.32.
> CFLAGS="-DHPUX -I/opt/dce/include" CXXFLAGS="-DHPUX -I/opt/dce/include
>-felide-constructors -fno-exceptions -fno-rtti" CXX=gcc ./configure --with-pthread
>--with-named-thread-libs='-ldce' --pr
Greetings and salutations,
MySQL Supports FKs. A FK is a table's PK value, stored in another table in
order to relate the records together. It does NOT support FK CONSTRAINTS.
(Cascading deletes, restricts, etc.)
...and now for the opinion portion of our show...
For all the of databases I've w
Do't be offended by the title:
http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0764504150&vm=
GREAT Primer on SQL. Very M$ SQL oriented but you will get enough grounding
in SQL to make the leap to MySQL.
Cal
http://www.calevans.com
-Original Message-
From: hanan khader [mai
Hi,
first,
from c:\mysql\bin run mysql then you can create a database named as you like
with command "create database;"
after you can view it, "show database;".
When you had created your database, you can create your first table.
Regards,
Carlos
-Original Message-
From: hanan khader [m
>Description:
I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql
errors from my scripts that say "mysqld has gone away". The
/var/lib/mysql/host.err log says this repeatedly:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack tra
Here it is in perl/DBI using hashes of arrays:
my $database =
DBI->connect("DBI:mysql:database=$DATABASENAME;host=$HOSTNAME
ST",$MYSQLUSER,$MYSQLPASS,{RaiseError=>0,PrintError=>0});
my $tablea = $database->prepare("SHOW TABLES FROM DATABASENAME");
$tablea->execute();
my @active_table
HI!
Please try to make a repeatable test case if possible.
This means a set of commands that would always lead to MySQL crashing.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*|
I couldn't connect to mysql server, beacuse it said
that user root@localhost couldn't connect (?!)
but before that I did something with the grant tables,
I don't remeber what? But I made one cgi that used
tables, but it coonected to the mysql server as root
user and a password, and it perfectly wo
Hi,
Can anyboby help me out. I am in a fix over how to carry out CREATE TABLE using C
APIs. The manual is of no help in this matter.
So anybody I please help me out.
Thanks in advance.
Shambhu.
_
Chat with your friends as soon as they come
At 05:14 PM 3/12/2001 +0200, Sinisa Milivojevic wrote:
>Please try to make a repeatable test case if possible.
>
>This means a set of commands that would always lead to MySQL crashing.
The problem does seem caused by a sequential set of operations. The script
that I've seen cause the problem so
>The problem does seem caused by a sequential set of operations. The script
oops, I'm meant to say "doesn't seem caused"
-bill
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Hi!
I am currently trying to compile 3.23.34a coming with BDB support.
I have zlib installed in the /usr/local (not normally searched for
libraries), so that until now I have
[CFLAGS etc ] LDFLAGS=-L/usr/local/lib ./configure
When enabling --with-berkeley-db, compilation fails, because I have a
On Saturday 10 March 2001 22:16, Justin wrote:
> Well thats good to know.. although this is sustained 24x7x365
>
> linux 2.2.14-5.0smp, uptime 170 days but e2fsk ok's the
> the database partition, which is a mirror.
>
> in an attempt to get stability, I've been running on the official
> 3.22.32 my
Hi, readers of the mailing list!
the Innobase table handler has finally been released as a part of
the MySQL-3.23.34a source distribution Tarball. Note that the Windows
source distribution or the binary distributions do not contain yet
Innobase.
I have copied below the release note. I will post
On Monday 12 March 2001 17:17, Heikki Tuuri wrote:
> Hi, readers of the mailing list!
>
> the Innobase table handler has finally been released as a part of
> the MySQL-3.23.34a source distribution Tarball.
Great news!
Congratulations for a great addition to the (already) great MySQL software.
--
Rick,
>I wasn't sure if I should email to the mysql list or directly to you. Here
maybe it is best both to post to the mailing list and send a carbon copy
directly to me, so that others can share the advice.
>are my questions about the Innobase tables:
>
>1) Do you have to start a transaction
I was wondering what others are thinking with respect to transaction table
type (BDB, Innobase, or Gemini) choices.
It seems to me that if you want transaction support in MySQL, then you must
pick one of the available transaction table types. And I would also assume
that row level locking would
Hi,
Can anyboby help me.
I'm try to write a UDF which replace substring in string according regular
expression.
When I compile my program with -I ./../regex gcc switch I recive as result
"Segmentetion fault". But when I compile my program without -I ./../regex -
my program works fine. I think gc
Hi,
This is the first time I have ever used or attempted to install my sql. I am
using a Sun Ultra 5 with Salaris 5.8. I have downloaded
mysql-3.23.34-sunsalaris2.7-sparc.tar.gz and have attempted to unzip this
with the command:
gunzip < mysql-3.23.34-sunsalaris2.7-sparc.tar.gz | tar xvf -
All
TranceMaster wrote:
>
> I couldn't connect to mysql server, beacuse it said
> that user root@localhost couldn't connect (?!)
> but before that I did something with the grant tables,
> I don't remeber what? But I made one cgi that used
> tables, but it coonected to the mysql server as root
> user
Shambhu Kumar singh wrote:
>
> Hi,
>
> Can anyboby help me out. I am in a fix over how to carry out CREATE TABLE using C
>APIs. The manual is of no help in this matter.
>
> So anybody I please help me out.
> Thanks in advance.
>
> Shambhu.
>
"CREATRE table" using C API should be treated just
> From: hanan khader [mailto:[EMAIL PROTECTED]]
> Sent: lunes, 12 de marzo de 2001 11:02
> To: [EMAIL PROTECTED]
> Subject: from where shall I start ?
>
> Hello ,
> to build a database using SQL Server, from where shall I start ? I mean,
> what shall I install on my Server, and how can I work w
Phillip Vamplew wrote:
> Hi,
>
> This is the first time I have ever used or attempted to install my sql. I am
> using a Sun Ultra 5 with Salaris 5.8. I have downloaded
> mysql-3.23.34-sunsalaris2.7-sparc.tar.gz and have attempted to unzip this
> with the command:
>
> gunzip < mysql-3.23.34-sunsa
Hi, can anybody help me with this query
mysql> SELECT
-> tblOperation.id,
-> tblRoom.fldRoomName,
-> tblPerson.fldPersonId AS History_Number,
-> tblOrderKind.fldOrderKindName,
-> tblOrderKind.fldOrderKindCode,
-> tblOperation.fldCalculatedEndTime AS operation_end_time
Hi,
I have tried to create a table with two fields. One is type CHAR and other
is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or
i need to do some setting to work properly.
I am working on WINNT machine.
Sanjeev Gupta
Programmer Analyst
Indus Consultancy Services
[EMAIL
"Gupta, Sanjeev" wrote:
>
> Hi,
> I have tried to create a table with two fields. One is type CHAR and other
> is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or
> i need to do some setting to work properly.
> I am working on WINNT machine.
>
http://www.mysql.com/doc/S/
I just installed RH 7.0 selecting the 'install everything' option. Now
when I use safe_mysqld, it starts then ends immediately with the
following message in the log.
010310 12:43:30 mysqld started
010310 12:43:30 Can't start server : Bind on unix socket: Permission
denied
010310 12:43:30 Do y
> All appears to be working but after 10 seconds the process stops with the
> error:
>
> 691 bytes, 2 tape blocks
> tar: directory check sum error.
>
> Fro reading the documentation, it does state that there could be problems
> with Sun Salaris but what is the work around?
The work-around is to
This is a permissions issue. Check the directories mysql is located in
and grant executable permissions. Also verify ownership requirements for
each of these directories.
Charles Hagen
On Mon, 12 Mar 2001, Russ Heaton wrote:
>
> I just installed RH 7.0 selecting the 'install everything' optio
As the RPMs available on the MySQL site are built against RH6.x libraries,
is there someplace where I can get versions linked against RedHat 7
libraries? RedHat themselves don't seem to have anything newer than 3.23.32
whereas I'd like to use 3.23.34.
Yeah yeah, I know I should have installed
As the RPMs available on the MySQL site are built against RH6.x libraries,
is there someplace where I can get versions linked against RedHat 7
libraries? RedHat themselves don't seem to have anything newer than 3.23.32
whereas I'd like to use 3.23.34.
Yeah yeah, I know I should have installed
Well you need to look for updates on the RedHat site. There are conflicts
with the new version, I believe, as I was never able to achieve a
successful loading on my release 7.0 Linux box. I would say this may be a
good time to contact them directly.
Charles Hagen
On Tue, 13 Mar 2001, Alec Smit
Hi Rick,
>In my C code, I use SQL statements, but I use the mySQL C API to pass on the
>SQL statements, check for errors, number of rows returned, and access the
>results. I would assume that this will still work; they still work with BDB
>tables.
ok, it should work like for BDB. There may be s
Well,
My best method has been to do the following:
1. Dumb the existing database to a file: mysqldump databasename >
database.txt.
2. On the new machine, create the new database. create databasename
3. Copy the file (database.txt) to the new machine.
4. Type.. mysql databasename < data
> As the RPMs available on the MySQL site are built against RH6.x libraries,
> is there someplace where I can get versions linked against RedHat 7
> libraries?
Have you tried installing the RPMs from the MySQL site? They installed just
fine on my RH 7.0 box on the first try. I do have all of the
After the vitriolic debates I've seen between the PostgreSQL fanatics and
the MySQL defenders, I thought I'd ask for clarification on the support for
transactions that's supposedly provided by the use of BDB tables:
Having used Oracle for a while (and given my understanding of how
transactions wo
Hi,
Got some tips and trix from some users about big tables,
-Using mysql 3.23.33
-ReadHat Linux 6.0 Kernel: 2.2.5
What I seem to must do is to get the "with-raid" to work
if a going to solve my problem, MERGE will be to complicated
to do when I have 11 diffrent Client prg working towards the DB
Sinisa Milivojevic wrote:
> I was not able to obtain the same effect on my 3.23.33.
BTW, the problem was for 3.22.*34* not 33.
> Please uploat
> your table to ftp://secret.mysql.com/pub/mysql/Incoming , so that I
> can test it.
Well... today I can't seem to reproduce the problem anymore. :/ I w
I'm using Microsoft Visual C++ version 6.0 and Windows 2000 Professional.
The manual samples works ... e.g. to run mysql and enter commandes manually
Anyone ... ?
/Christer
Christer Holmström wrote:
> Hi!
>
> just downloaded MySQL, and compiled the c-code example located in
>
> MySQL\exa
Hi Jordan,
>Well... today I can't seem to reproduce the problem anymore. :/ I was
>getting it very frequently yesterday (on almost every try). I'm not sure
>what has changed since then. I'll let you know if the problem happens again
>and try to narrow down the exact steps to reproduce.
Is it po
Rick,
>Everything you wrote sounds good, except for one thing. I use the result
>count from a select or delete for logical branching within my code. I.e. I
>perform a select and if rowcount is zero, then I can do an update. That is
>a problem.
>
>Any thoughts?
The basic rowcount functionality
> >Well... today I can't seem to reproduce the problem anymore. :/ I was
> >getting it very frequently yesterday (on almost every try). I'm not sure
> >what has changed since then. I'll let you know if the problem happens
again
> >and try to narrow down the exact steps to reproduce.
>
> Is it poss
Hi everyone,
I'm stuck on one issue which is preventing me from using MySQL in production
on one particular database. (This is similar to my last post but this time
I'll explain better what I'm attempting to do.)
I'm trying to create a database of filenames and directories using MySQL. I
have tw
> -Original Message-
> From: Nemholt, Jesper Frank
> Sent: viernes, 09 de marzo de 2001 19:52
> To: '[EMAIL PROTECTED]'
> Subject: Memory problems/bug ?
>
>
> Hej!
>
> Using MySQL 3.22.32 on Tru64 4.0F patchkit 4. Compiled with Compaq CC.
>
> Ran optimize on a table, and after 10 minu
Dear All
I got very excited today when 3.23.34 worked (i.e now show tables bug) !
I then recomplied with optimisations and then with pgcc and bug
reappears.
I am now having a go with different CFLAGS and CXXFLAGS.
Not being a C / complier / libs expert I can not comment any further !
How weir
A .03 sec left join PREVENTS you from using MySQL.
This must be a troll.
You have no where clause, so no index is used.
Jordan Russell wrote:
>
> Hi everyone,
>
> I'm stuck on one issue which is preventing me from using MySQL in production
> on one particular database. (This is similar to my
> A .03 sec left join PREVENTS you from using MySQL.
>
> This must be a troll.
Sigh...
I guess I failed to mention this was a deliberately simplified example in
order to pose my question in a easy-to-understand manner. In reality, there
are much more records, and a more complex query, where the t
> You have no where clause, so no index is used.
Oops, missed this part.
Where exactly do I need a WHERE clause, and for what? The first query
doesn't have a WHERE clause and yet it appears to be using the "date" index.
Jordan Russell
--
This is NOT an RTFM reply.
Hve you read
http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L
EFT_JOIN_optimization
?
Cal
http://www.calevans.com
-Original Message-
From: Jordan Russell [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 2:05 PM
To: Gerald L
Hello,
I have updated my mysql server from version 3.22.25 to
3.23.33. I've noticed that the same query's output I've run
in the old version differs from the new version's.
Eg.
I've got a film database:
SELECT COUNT(*) FROM FILM;
returns me a number of 53.
The same select with a WHERE COM
Hi,
Thanks for the reply.
> Hve you read
>
http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L
EFT_JOIN_optimization
> ?
Yes, many times, as well as just about everything else in the Performance
chapter. Am I missing something totally obvious? Should I even be using a
LE
And
SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL:
returns what?
"P.Peti" wrote:
>
> Hello,
>
> I have updated my mysql server from version 3.22.25 to
> 3.23.33. I've noticed that the same query's output I've run
> in the old version differs from the new version's.
>
> Eg.
>
> I've got a
I don't know if this list still gets read by the staff TcX or not, but I
have this suggestion:
1/ For those of us willing to code the glue logic to make triggers,
constraints, and foreign keys work, it would be VERY helpful if ALL the
commands that are exercised on a table at creation or modifica
Everything I've seen on this list indicates that using LEFT JOIN negates
using an index. (WARNING: This is 3rd hand info and as such should be viewed
skeptically!)
Have you tried:
SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
ORDER BY files.date DESC LIMIT 1;
If so, what were
> Everything I've seen on this list indicates that using LEFT JOIN negates
> using an index. (WARNING: This is 3rd hand info and as such should be
viewed
> skeptically!)
>
> Have you tried:
>
> SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
> ORDER BY files.date DESC LIMIT 1;
>
>
Hi Peter,
and sorry that this response to your Big Mail comes some 12 days late.
We have put together the release 3.23.34a and that has occupied
my mind.
>HT> In pure insertions, copying a table to another, I have measured that
>HT> Innobase is about as fast as MyISAM. In aggregate queries from
/* This table has 5000 rows */
CREATE TABLE files (
id int(11) NOT NULL auto_increment,
dir_id int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
date datetime default NULL,
PRIMARY KEY (id),
KEY date (date)
) TYPE=MyISAM;
for grins and giggles, add:
key dir_id(dir_
Jordan Russell wrote:
>
> > Everything I've seen on this list indicates that using LEFT JOIN negates
> > using an index. (WARNING: This is 3rd hand info and as such should be
> viewed
> > skeptically!)
> >
> > Have you tried:
> >
> > SELECT files.id, dirs.name FROM files where files.dir_id=dirs.i
> /* This table has 5000 rows */
> CREATE TABLE files (
> id int(11) NOT NULL auto_increment,
> dir_id int(11) NOT NULL default '0',
> name varchar(100) NOT NULL default '',
> date datetime default NULL,
> PRIMARY KEY (id),
> KEY date (date)
> ) TYPE=MyISAM;
>
> for grins and giggles,
Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2
(Zoot)
Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I
would reinstall mysql_install_db. This hangs too, see below...
[root@myserver mysql]# mysql_install_db
Creating func table
Creating tables_priv
> Do you have an index on files that starts with dir_id and
> an index on dirs that stats with id and having date in the files
> index (after dir_id) might be helpful although I'm not sure.
Sorry, I don't understand exactly what you mean, but...
> you could provide the output of
> show keys from
Has anyone contemplated using MySQL for DTP through a cluster of
machines where the transactions are related to critical financial
transactions.
For example, in a commerce situation where a customer withdraws from one
account and deposits into another, DTP ensures that all computers commit
concu
Shankar,
MySQL now provides (3.23.34a Unix source distribution) transactions both
through BDB and Innobase tables. I will try to answer your questions
for Innobase.
>After the vitriolic debates I've seen between the PostgreSQL fanatics and
>the MySQL defenders, I thought I'd ask for clarificatio
FYI,
This problem got worse as more users began using the system. I had to
revert back to 3.23.28, which did solve the problem.
I'm sorry that I didn't come up with a reproducible test case. As near as
I could tell it seemed to be intermittent in nature. Things would work,
then not work.
Hello,
>And
>SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL:
>
>returns what?
Sure, I forgot to mention that I know it's all about the
NULL values, i can correct the "problem" (maybe not a
problem but I think it's a weird behavior) i just don't
understand why?
The query you mentioned retu
"Weber, Jeff" wrote:
>
> Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2
> (Zoot)
> Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I
> would reinstall mysql_install_db. This hangs too, see below...
>
> [root@myserver mysql]# mysql_install_db
> Cr
I recently moved to a new server, and successfully copied the database over
to the new server. However, at least half of my queries are returning the
error:
ERROR 2013: Lost connection to MySQL server during query
The error seems to be random, and only with longer queries. I'm guessing
this is o
Hi,
What would be the workaround for migration from linux redhat 6.2 with mysql 3.23 to
windows 2000 with mysql. I have a database dump in mysql 3.23 for linux.
Merci,
Jean-Francois Duckett
[EMAIL PROTECTED]
514.281.0905
- See the world, Set the price - www.thedailyauction.com
"P.Peti" wrote:
>
> Hello,
>
> >And
> >SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL:
> >
> >returns what?
>
> Sure, I forgot to mention that I know it's all about the
> NULL values, i can correct the "problem" (maybe not a
> problem but I think it's a weird behavior) i just don't
> understan
This join works perfectly in Access but if I use the same query in MySQL it
shits it's pants.
SELECT tbl_medien.titel, tbl_medien.ausgabe, tbl_medien.URL,
tbl_medien.medientypID, tbl_autor.name, tbl_autor.vorname
FROM tbl_medien INNER JOIN (tbl_autor INNER JOIN
tbl_zuordnung_autoren_medien ON
tbl
Sanjeev Gupta
Programmer Analyst
Indus Consultancy Services
[EMAIL PROTECTED]
201-261-3100 x 264
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hello P.Peti,
Monday, March 12, 2001, 11:17:16 PM, you wrote:
PP> It just seems to be weird that a subset and its complement
PP> does not equal the whole table. So the thing is:
PP> #"!deleted" doesn't include "#NULL" as the set filtered by
PP> the clause 'WHERE comment!="deleted"' doesn't i
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mysql_install_db hanging with three mysqld processes
>Description:
I sent a mail last week with a problem with mysql_install_db hanging. I have
followed all of the advice from previous posts with no luck. I have noticed that my
si
Jordan,
Ok, I'm out of ideas. The additional index should have sped things up, not
slowed them down. I've got some tables with 26,000 rows in it and I do 4
joins (using a WHERE clause) with smaller tables without a hitch.
Sorry I can't help.
Cal
http://www.calevans.com
-Original Message
>Description:
The code that checks for cc may pick the "first" cc it finds in its path,
which may not be the same cc used for compling, eg it may choose /usr/bin/gcc over
/usr/local/bin/gcc
>How-To-Repeat:
Look in the code for mysqlbug
>Fix:
Ah this depends on finding the
What is your swap size? What is your drive space? It sounds like you
need to upgrade to their latest. Did you load all the updates on your 6.2
box?
Charles Hagen
On Mon, 12 Mar 2001, Weber, Jeff wrote:
> Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2
> (Zoot)
> Kern
Dear All
The following C and CXX flags will work (/usr/local/bin/gcc is actually
pgcc).
Reading specs from
/usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs
gcc version pgcc-2.95.2.1 20001224 (release).
CC='/usr/local/bin/gcc' CFLAGS='-O6 -mpentiumpro -mstack-align-double'
CXX='/u
Platform: SunOS 5.8
MySQL Version: 3.23.33 Source distribution not binaries.
gcc version: 2.95.2
Problem: Getting some fatal compiler errors when I run configure. Not sure what to do
about it.
Any and all help is appreciated. I've tried using this lists archived email for an
answer, but all a
Lutz,
what compiler are you using? GCC? HP:s own commercial compiler, I assume.
>I am currently trying to compile 3.23.34a coming with BDB support.
>I have zlib installed in the /usr/local (not normally searched for
>libraries), so that until now I have
> [CFLAGS etc ] LDFLAGS=-L/usr/local/lib .
I hope you can also use MySQL dump, in which case, you don't have to shut
down, right?
j- k-
> >2) Can you perform backups as with other tables?
>
> You have to shut down the database, make sure that it shuts down without
> errors, and then copy the Innobase data files to a safe place (
The answer you seek is clearly explained in the manual.
- Original Message -
From: "Gupta, Sanjeev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 3:34 PM
Subject: how to create stroed procedure in mysql
>
>
> Sanjeev Gupta
> Programmer Analyst
> Indus Consulta
You can't.
Cal
http://www.calevans.com
-Original Message-
From: Gupta, Sanjeev [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 3:34 PM
To: '[EMAIL PROTECTED]'
Subject: how to create stroed procedure in mysql
Sanjeev Gupta
Programmer Analyst
Indus Consultancy Services
[EMAIL
I wish to:
GRANT SELECT ON mediabankmaster.clients TO [EMAIL PROTECTED]
GRANT SELECT,INSERT ON mediabankmaster.publicdocs TO [EMAIL PROTECTED]
however, this does not work.
'cemail' can SELECT from clients.
'cemail' can INSERT into publicdocs.
'cemail' CAN NOT SELECT from publiccocs.
I don't know
so does the mysql have to be installed under
/usr/local/mysql ?
I made a symbolic link named mysql that points to the
/usr/local/mysql-3.23.32-pc-linux-gnu-i686 directory
is that ok ?
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at g
1 - 100 of 121 matches
Mail list logo
