Michael Satterwhite <[EMAIL PROTECTED]> wrote:
>
> Is there a tool for displaying / printing the tables and table definitions for
> a given database? I know about info / show, I'm looking for something that
> can take a database name and produce the entire definition report.
Whar about mysqldum
Hi Jean;
enter into /etc/my.cnf or ~/.my.cnf
datadir=/mnt/data/mysql
login to mysql and do
SHOW VARIABLES LIKE '%data%'
That should do it.
Best regards
Nils Valentin
Tokyo/Japan
On Fri, 30 May 2003 15:06:35 +0200, Jean Christophe <[EMAIL PROTECTED]>
wrote:
Hi,
I have mysql running on a red
Hi Edward,
I expected this question to come up once more, so I think that this would
have happened anyway, so let's just forget it shall we ? ;-)
Probably it's only you and me reading it ;-)
Best regards
Nils Valentin
Tokyo/Japan
On Fri, 30 May 2003 09:07:17 -0400, Becoming Digital
<[EMAIL PR
Try something like SELECT formatted_date FROM mytable WHERE
formatted_date BETWEEN '04-08-2003' and '07-08-2003';
Or something along those lines, I would get more specific but I do not
have specific information to go from.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: P
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Victoria Reznichenko wrote:
> "George Pitcher" <[EMAIL PROTECTED]> wrote:
>
>>I think I've tried that.
>>
>>This is how I start MySQL
>>
>>mysqld --enable-local-infile
>>
>>No joy I'm afraid. I've got round a minor problem in moving a MSAccess db
>>us
Please don't hijack other threads. It's not that hard to start your own.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "phieu huynh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 29 May, 2003 21:00
Subject: can't unzip the mysql V4.1.0
Hi,
I have mysql running on a redhat-9. (rpm files)
I tried to change the datadir from /etc/my.conf without succes.
What do I have to do to change the directory of my databases from
/var/lib/mysql (default) to /mnt/data/mysql ?
is the fact that /mnt/data a vfat partition a problem (if it is, I can
Le reponse de Harald est entirement correct. En plus il existe un
liste en français:
Liens utils :
Poster un message: [EMAIL PROTECTED]
S'abonner: [EMAIL PROTECTED]
Se désabonner : [EMAIL PROTECTED]
Ecrire au proprio : [EMAIL PROTECTED]
URL sur Yahoo :
http://fr.groups.yahoo.com/gro
"George Pitcher" <[EMAIL PROTECTED]> wrote:
>
> I think I've tried that.
>
> This is how I start MySQL
>
> mysqld --enable-local-infile
>
> No joy I'm afraid. I've got round a minor problem in moving a MSAccess db
> using SQLyog but that won't help me with Filemaker.
>
>
Client should be ena
harsh <[EMAIL PROTECTED]> wrote:
>
> Is there an ARRAY data type in mysql ???
> I cdn't find it in documentation,but my java
> book shows SQL has support for Arrays ..:(
>
Nope, MySQL doesn't support ARRAY.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This em
Hi Edward,
Thank you for the reply. I am only interested in any technical details, not if
it was good or bad what a certain company did. Please be so kind and leave
the legal matters out of this.
Thank you for understanding.
Best regards
Nils Valentin
Tokyo/Japan
2003年 5月 30日 金曜日 20:50、Bec
SELECT SUBSTRING_INDEX(field, ' ', 25) FROM tablename
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Adam Clauss" <[EMAIL PROTECTED]>
To: "'Steve Marquez'" <[EMAIL PROTECTED]>; "'MySQL List'"
<[EMAIL PROTECTED]>
Sent: Wednesday, 28 May, 2003 22:07
Subj
> was on questionable legal ground. In fact, *I'm* convinced it was
> illegal.
Care to elaborate on this?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Nils Valentin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTE
> that is, that if the values for the field 'table1.people_id' rows is
> "1" - "50", then the field values for 'table2.location_id' (or any
> other table) cannot also be "1" - "50".
I think you're mis-interpreting the use of "values." While the actual value can
be the same between the fields (1,
Hi Ted,
Any single primary key cannot contain duplicate entries and any single table
can have only one primary key. With your example, 'table1.people_id' can
have values "1" - "50" and 'table2.location_id' have "1" - "50 at the same
time so your final statment is wrong. I assume what the book act
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there a tool for displaying / printing the tables and table definitions for
a given database? I know about info / show, I'm looking for something that
can take a database name and produce the entire definition report.
-BEGIN PGP SIGNATURE-
Bonjour, je viens d'installer mysql-4.0.3 , or je m'apercois que pour chaque
nouvelle connection, un nouveau processus aparait dans ma liste ps, est-il
possible de configurer mysql pour qu'il utilise des threads plutot que des
fork ?
Cordialement
Yannick GUENET
--
MySQL General Mailing List
Fo
- Original Message -
From: Prashant Akerkar
To: [EMAIL PROTECTED] ; Karam Chand ; [EMAIL PROTECTED] ; Donald Longan ; miguel
solorzano ; [EMAIL PROTECTED]
Sent: Friday, May 30, 2003 3:56 PM
Subject: Date Query
- Original Message -
From: Prashant Akerkar <[EMAIL PROTECTED]>
T
- Original Message -
From: Prashant Akerkar <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 30, 2003 3:23 PM
Subject: Date Query
Dear Friends
I have a Query regarding Displaying Dates
I have two field in my mysql Table for Date_from and Date_To
Retrived record was ' 04-
- Original Message -
From: Alexander Keremidarski <[EMAIL PROTECTED]>
To: Prashant Akerkar <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 30, 2003 3:32 PM
Subject: Re: Date Query
> Hello,
>
> Prashant Akerkar wrote:
> > Dear Friends
>
> Please ask such kind of questions at
- Original Message -
From: Alexander Keremidarski <[EMAIL PROTECTED]>
To: Prashant Akerkar <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 30, 2003 3:32 PM
Subject: Re: Date Query
> Hello,
>
> Prashant Akerkar wrote:
> > Dear Friends
>
> Please ask such kind of questions at
> I think I found another answer to my own question. FYI a good way to return
> results in a random order SELECT user FROM table ORDER BY RAND()
Unfortunately, you cannot use this query to "wrap around," as you put it.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Mess
Hello people,
I am trying to run this query:
UPDATE table1, table2 SET table1.periode = table.periode WHERE table1.id
= 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = table2.name
But i keep getting the same error message
You have an error in your SQL syntax near '
table2 SET table1.periode =
* [EMAIL PROTECTED]
> On Friday, May 30, 2003, at 03:23 AM, Jon Haugsand wrote:
>
>> ps aux | grep -E 'USER|mysql'
>
> Do you mind telling me what these mean, I'd appreciate it greatly:
> I know what PID and CPU and MEM are...
>
> ps aux | grep -E 'USER|mysql'
> USERPID %CPU %MEM VSZRS
> My question is: must I manually enter the value from the "people_id"
> (primary key of "people table") into the machine_id field of the
> "machines table"? My only question here (unless you see others ;) is
> must I manually enter these "corresponding" numbers?
If I understand your question cor
Sorry hit the wrong reply button ;-)
> Hi Rajendra,
>
> In case you are new to mysql the easiest way would be to do it on the
> command line base :
>
> 1) shutdown the server
> 2) go to your data directory f.e /var/lib/mysql/dbname1
> 3) copy the table files to the folder of dbname2
>
> f.e c
I created a little table chart showing the features of the different table
types. Its not complete and might even contain wrong info. The information is
taken from the the mysql manual and several books.
http://knowd.co.jp/staff/nils/mysql-ttf.html
As I dont have (yet) had the time to try all
Hello Sir,
thanks for the reply. i have one more doubt.
i want to import 2 tables from one database to
another database like the tables structure and as well
as its records.
have a nice day,
Naren.
--- Egor Egorov <[EMAIL PROTECTED]> wrote: >
Rajendra Kumar <[EMAIL PROTECTED]> wrote:
> >
Hi ???,
O.K let's translate this.
[admin admin]$ ps -u mysql
> PID TTY TIME CMD
> 11096 pts/000:00:00 mysqld
> 11098 pts/000:00:00 mysqld
> 11099 pts/000:00:00 mysqld
> [admin admin]$
This shows you the proceses for the Linux user account "mysql".
You can see this accou
Hello to all,
I've noticed several problems regading behaviour of indexes in MySQL 4.1
MySQL seems to ignore encoding settings for the database.
When I request sorted dataset, it is returned incorrectly when indexes are used.
My data is stored in cp1251 encoding.
consider this:
SELECT * FROM tabl
Yeah...I don't think you need to make any changes..
On Fri, 30 May 2003, 2Hosts.com wrote:
> Thanks Kamara,
>
> So does that mean I don't need to change anything?
>
> >
> > > [admin admin]$ ps auxw | grep mysqld
> > > root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh
> > > /usr/b
Thanks Kamara,
So does that mean I don't need to change anything?
>
> > [admin admin]$ ps auxw | grep mysqld
> > root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh
> > /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/
>
> > Presumably the "root" on line one shows i
> [admin admin]$ ps auxw | grep mysqld
> root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh
> /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/
> Presumably the "root" on line one shows it's running as root? this
> paragraph in the book is extremely sketchy.
What
Hi Nils,
I tried what you said, here's what I got. Apologies in advance if I'm being
a "slowbee" as well as a "newbie"/
[admin admin]$ ps -u
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
admin 9449 0.0 0.1 1700 936 pts/0S00:48 0:00 -bash
admin13234
Hi Nils,
Thanks for your help. I am trying to get my head round it. I'm on a unix
Cobalt RaQ 4 which is using Cobalt OS V6 and Cobalt MySQL 3.23.37-1
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "2Hosts.com" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday,
> Hi guys,
>
> On page 54 of the Sams "teach yourself MySQL in 24 hrs" it says the owner
> should not be root, and to change it. I can't seem to find out how to do
> this - could anyone guide me in the right direction please?
>
> I searched the list archives to no avail.
> Many thanks. :o)
>
Sor
Hi ???,
I don't know which OS you are talking about, but I guess for a Linux OS.
Try this:
ps -u
see on the left the Linux account it uses.
ps -u
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1266 0.0 0.0 1360 468 tty1 SMay28 0:00 /sbin/mingetty
* [EMAIL PROTECTED]
> Thanks, I get:
>
> [localhost:~] ted% ps ax |grep mysql
>180 ?? S 0:00.04 sh /usr/bin/safe_mysqld
>197 ?? S 0:00.21 /usr/libexec/mysqld
> 2054 std R+ 0:00.00 grep mysql
>
> does this look good? safe?
Try: ps aux | grep -E 'USER|mysql'
--
Jon H
Hi guys,
On page 54 of the Sams "teach yourself MySQL in 24 hrs" it says the owner
should not be root, and to change it. I can't seem to find out how to do
this - could anyone guide me in the right direction please?
I searched the list archives to no avail.
Many thanks. :o)
--
MySQL General
I'm working with the Greek unicode range on mysql 4.1, redhat 8.0. The problem is
that querying with a LIKE expression is treated case and accent sensitive. The sort
order and comparing with "=" do work correctly (case and accent insensitive). I
noticed in the source code that the utf8 cs use
> WHERE TAB2_ID 2
> is the problem.
> Do you want = or <> or what?
Except that if you check the original post you'll see:
SELECT * FROM TAB1 WHERE TAB1_ID IN
(SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID > 2)
The ">" was at a line break and got swallowed up in the
replies with the >>s at the beginni
Someone here (Mike) has been quite kind and responded elaborately to me
off-list, thanks Mike!
I wanted to go ahead and put this "final" question here:
In my database that I'm working on I already have data --a 'one to
many' people to machines db.
I had made each table with a primary key field
> I have searched the archives but have not found an answer to this.
My searches seem to come up dry the first time around lately, too.
> Our company is moving from Oracle and is in a determination phase as to its
> replacement.
> (Platforms are Windows and Solaris, and better be Linux soon, too
The problem is my netscape browser, somehow the file had been corrupted.
I just re-download the file by using another computer and I can unpack
the file.
Daniel Kasak wrote:
phieu huynh wrote:
Hi,
I got the following error message when I unzip the files.
$> gunzip mysql-max-4.1.0-alpha-p
phieu huynh wrote:
Hi,
I got the following error message when I unzip the files.
$> gunzip mysql-max-4.1.0-alpha-pc-linux-i686.tar.gz
Heheheheheheh.
Thanks man. I've been pissed off all morning and that gave me my first
laugh.
Use:
tar -zxvf mysql-max-4.1.0-alpha-pc-linux-i686.tar.gz
--
D
Hi,
I got the following error message when I unzip the files.
$> gunzip mysql-max-4.1.0-alpha-pc-linux-i686.tar.gz
gunzip: mysql-max-4.1.0-alpha-pc-linux-i686.tar.gz: invalid compressed
data--crc error
gunzip: mysql-max-4.1.0-alpha-pc-linux-i686.tar.gz: invalid compressed
data--length error
Remember that (as of stable 4.0) this is a command line option (not
mentioned in the docs).
safe_mysqld -O ft_min_word_len=2
You then have to rebuild the indexes
REPAIR TABLE tbl_name QUICK;
--Joe
On Thursday, May 29, 2003, at 08:47 PM, Daniel Rossi wrote:
It's not a bug, by deafult variab
It's not a bug, by deafult variable ft_min_word_len=4, but you search word 'DB' has
length 2.
If you want to search both exact matches use + operator in BOOLEAN MODE or phrase
search:
http://www.mysql.com/doc/en/Fulltext_Search.html
ok well i'm soughting that out but how about the
Hi Barry,
I believe you miss an important point. You have to check the privileges you
gave the user or host that doesnt work.
login to mysql from a working account.
do this:
USE mysql
SHOW GRANTS FOR bdancies;
loook exactly what it says.
If you are used to mysqlcc than connect from there lo
hi sorry to got this , ok
say i search for this "something1 something2" + "something3 something4" that doesnt
work either is the syntax correct ?
>>> Egor Egorov <[EMAIL PROTECTED]> 05/29/03 08:15pm >>>
Daniel Rossi <[EMAIL PROTECTED]> wrote:
> i have also noticed that the boolean default is OR
Hi Kevin,
Error 2013 means lost connection during query
So, as you said the workload of the server is not so high - and I take your
word for it -I would like to go once more to the timeout variables.
You said that you changed wait timeout, but I believe you missed the important
one ( just a gu
Sorry, I missed the last part of your email.
Try:
SELECT * FROM products p, uses u, prod_uses pu WHERE p.pid=pu.pid AND
u.uid=pu.uid AND uses='use 1';
:-)
- Original Message -
From: "Marcel Forget" <[EMAIL PROTECTED]>
To: "Mikey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday,
Hi,
It would work something like this:
SELECT * FROM products p, uses u, prod_uses pu WHERE p.pid=pu.pid AND
u.uid=pu.uid AND productname='product 1';
Where
products
pid int(11) PRI (NULL) auto_increment
productname varchar(25) YES (NULL)
uses
uid int(11) PRI (NULL) auto_increment
uses varchar(
Which server is going to perform the application logic (the one on the LAN
I'd hope) ?
Can you just replicate to the local one from the internet ?
I've done a lot of things like that in PHP , depends on the data sizes and
error checking etc etc.
Jerry
- Original Message -
From: "Nikos
On Thu, May 29, 2003 at 02:19:11PM -0700, Daevid Vincent wrote:
> Whoa. Easy there killer. First, it's kinda uncool to accuse me of
> spamming when I sent it one time to three separate lists all relevant:
> SVLUG, RedHat and mySQL. Just because YOU are on multiple lists, doesn't
> mean that others
Hi All
A slight correction in the compile line that I used:
aCC -DDBUG_OFF -DHPUX11 -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -D_INCLUDE_LONGLONG
-DNO_FCNTL_NONBLOCK -DDO_NOT_REMOVE_THREAD_WRAPPERS
-DHAVE_BROKEN_PTHREAD_COND_TIMEDWAIT +O2 -o mysql mysql.o readline.o sql_string.o
completion_hash.o
Nevermind, found it
libtermcap-devel
-Original Message-
From: Cassily, Ryan
Sent: Thursday, May 29, 2003 5:14 PM
To: MySQL (E-mail)
Subject: configure question
After running:
./configure --prefix=/usr/local/mysql
I get the error:
checking for termcap functions library... configure:
Whoa. Easy there killer. First, it's kinda uncool to accuse me of
spamming when I sent it one time to three separate lists all relevant:
SVLUG, RedHat and mySQL. Just because YOU are on multiple lists, doesn't
mean that others are. This is hardly 'spamming'. Then on top of that,
you sent your *opin
Hi All
I'm trying to install MySQL 4.0 on HP-UX 11.00 32 bit. I went through the following
steps:
1. setenv CC "cc"
2. setenv CXX "aCC"
3. ./configure --prefix=/usr/local/MySQL/HPPA.11.00 --with-embedded-server
--localstatedir=/usr/local/MySQL/HPPA.11.00/data --with-client-ldflags=-all-static
After running:
./configure --prefix=/usr/local/mysql
I get the error:
checking for termcap functions library... configure: error: No curses/termcap library
found
What specific library am I missing? Thanks in advance for your help!
--
MySQL General Mailing List
For list archives: http://lists
Hi,
I got an error when I tried to access MySQL on HPUX
system. Does anyone have ideas what's wrong here?
Thanks!
Zengfa
sendsig: useracc failed. 0x20007ee8ba00
0x005000
Pid 21045 was killed due to failure in writing the
signal context - possible stack overflow.
/opt/iexpress/mysq
Mark,
- Original Message -
From: "Mark Morley" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, May 29, 2003 10:48 PM
Subject: RE: Recovering table structures from .frm files?
> > I have a couple of .frm files with no corresponding data or index
> > files. Is it p
On Thu, May 29, 2003 at 12:59:35PM -0700, 2Hosts.com wrote:
> sorry for being a thikky, but how do i open a .ezm file?
This is answered in the FAQ for the mailing lists at
http://lists.mysql.com/faq.php#digest-oe
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://list
Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pierre wrote:
Hi,
I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system
with gcc-3.2,
but for the make I got this :
# ant
Buildfile: build.xml
Overriding previous definition of reference to non.test.sources
cle
sorry for being a thikky, but how do i open a .ezm file?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have searched the archives but have not found an answer to this.
Our company is moving from Oracle and is in a determination phase as to its
replacement.
(Platforms are Windows and Solaris, and better be Linux soon, too.)
1. The primary question/issue here is that with the "complexity" of our
> I have a couple of .frm files with no corresponding data or index
> files. Is it possible to recover the table structure (field names,
> types, sizes) from these files?
More info: these appear to have been created under MySQL 4.0.x and they were
originally InnoDB files. I can see a list of fi
Hello!
Does anyone know anything about importing *hash flat file* into mysql? Well,
we got this binary(hash flat file) file that contains user id, user name and
more user info. We need to put those data into our new database(probably
into a new table and the join two tables together). Any idea?? Th
Mysqldump on both databases
Do a diff on both files
Redirect the output to a file
Mysql database < parse_file_to_sync
Easiest way, there are some other methods which basically do the same
thing.
-->-Original Message-
-->From: Nikos Gatsis [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, Ma
Hi,
Im encountering something very funny with embedded server (libmysqld.dll) ver
4.0.12, im connecting to this using Delphi 7 statically on a windows 98 machine. If i
call mysql_real_query('OPTIMIZE TABLE my_db.my_table') in the main thread it works
perfectly fine, but the moment i call exa
Ok, since this is THE place for MySQL and related discussion/questions,
here goes:
I'm trying to understand Keys, I do for the most part, but in reading
the well recommended book 'Database Design for Mere Mortals' I got a
bit confused.
A check for worthy primary key designation is to ask what
GlacierHello list
I have 2 mysql databases.
The first is on the internet (under RH linux 7,2).
The second is on a local network (under RH linux 7,2 also).
The two databases have some common tables and I wish to "compare" them and
"copy" the new record of the Internet tables to the local database.
On 29 May 2003 at 11:38, James wrote:
> What we envision is a query to return something similar to this:
>
> +-+--++
> | Item Number | Item Description | Option Description |
> +-+--++
> | 1
Hi --
I am trying to connect to a remote mysql database on a unix machine
from a MySql control center on a Wintel machine, but I get the following
error:
[ENSEMBL] ERROR 1045: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
When I am logged onto the unix box, I
On a linux red hat system I have installed mysql 4.0.12 from the rpms
and have been using it. But, a serious problem has developed since
another team member installed rekall 1.1.2.
Afteer he installed rekall everthing seemed fine until the next system
reboot. mysql failed to start with the the
Hello All,
I installed Mysql 4.0 on my machine using rpm package in /var/lib/mysql.
Previous mysql was installed using a tar ball in /usr/local/mysql. Now when
the system is rebooted the older version of mysql is started by default. I
don't wan't to use this older version. I want to start mysql us
Can anyone help.
I have created a database using Windows XP Professional OS and granted all
priviliges to a user called rwuser with a specified password. I am
attempting to access the data in a table through MySQL ODBC 3.51 Driver on
Windows XP Professional. I have specified the HostName as l
Thanks for your reply Jeff.
While your query is more efficient than the one we had, it still poses
the fundamental problem we were trying to avoid; that is returning a
"row" for each option.
Our "item" table contains over 280 fields which about 30 of them are
multiple look-ups like the one I desc
Hi all, I've inadvertently ran across a weird issue with the text client. I
have found that if you press [SHIFT][ENTER] the program seg faults. This is
consistent behaviour as far as i know.
Im running redhat 9 and MySQL 4.0.12-max
Does anyone else see this behaviour?
thanks
--
MySQL Genera
I have a couple of .frm files with no corresponding data or index
files. Is it possible to recover the table structure (field names,
types, sizes) from these files?
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Hi,
I tried to run MySQL on HPUX, got this error:
$ /opt/mysql/bin/mysql -hhostname.domain -uroot mysql
sendsig: useracc failed. 0x20007ee99a00
0x005000
Pid 18403 was killed due to failure in writing the
signal context - possible stack overflow.
ERROR 2013: Lost conne
I am reposting this in hopes that somebody out there has at least a
suggestion or hint as where to look. Everything I've tried so far (mainly
small setting changes) seems to prevent numerous 2013 errors.
help me mysql kenobi, you're my only hope.
Kevin
-Original Message-
From: Kevin A. M
Hi NG, this is my first visit here, so please be gentle!!!
I have a table of products (`prods`), and a separate table of product uses
(`uses`) and the products are linked to their uses by a list (`prod_uses`).
What I need to be able to do is allow a search of products by their use and
I am gettin
Great!Didn't know you could do that.
Cheers
Terry
--Original Message-
> I think I found another answer to my own question. FYI a good way to
> return
> results in a random order
> SELECT user FROM table ORDER BY RAND()
>
--
MySQL General Mailing List
For list archives:
Here are a couple of sample tables:
grants.grantidgrants.agency
1 NIH-F
2 NIH-F
3 NIH-F
dates.dateid dates.grantid dates.yearday
1 1 31
2 1 60
3 2
You should probably also take a look at your error log (dbmaster.err)...it'll
tell you in much more detail why mysqld ended rather than continued running as
expected. Often this will be something as simple as your directory permissions
not being set right on your data dir...
Chris
Nick Arnett
I think I found another answer to my own question. FYI a good way to return
results in a random order
SELECT user FROM table ORDER BY RAND()
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 29, 2003 11:08 AM
To: [EMAIL PROTECTED]
Subject: RE: rando
This is on a production server and I would rather not stop and restart it.
Also I don't think HUPing mysqld will make it read my.cnf again.
-Michael
"Well finally! We did everthing but to leave a note pinned to the hem of her dress
that said, Oh by the way, the Prelate and the prophet are still
Thanks for your response (and yours also, Jeremy). Both are spot on in terms of
recognising it as a transaction commit issue. It turns out a developer was
opening a transaction long before the query in question executed and had
neglected to either commit it or roll it back: subsequently, the P
We run Tomcat4. Currently we are using the older mm- drivers. Is there
anyway to move to connector /J one context at a time rather than all at
once?
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http:/
mtoth <[EMAIL PROTECTED]> wrote:
> I am unable to set thread_cache_size via the mysql tool.
> Should I be able to?
> Am I doing something wrong?
>
> Ver: 3.23.51
You could do it only editing my.cnf file or run mysqld with appropriate option.
--
For technical support contracts, goto https://or
Scott
--Original Message-
> What would be the most efficient query to determine the number of rows?
>
Probably something like
SELECT COUNT(*) AS rectotal FROM table ?
Cheers
Terry
PS - better to reply direct to list rather than individual, as you seem to
have done on this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TheMechE wrote:
> Ok all, here's a topic on performance. I'd appreciate your opinions.
>
> Relevant documents would be the mm-mysql-driver interfacecode for
> ResultSet, and Statement.
> I have the following issues... One... when I ask for a quer
Hi Jeremy + Mysql List,
I am german of course I read the German announcements last week and also the
one you mentioned below.
While I am not sure what you would like to know let me start with some wild
guesses from my site.
For me that looks very strategic and easy. SAP AP customer are in the
I am unable to set thread_cache_size via the mysql tool.
Should I be able to?
Am I doing something wrong?
Ver: 3.23.51
mysql> set option thread_cache_size=4M;
ERROR 1064: You have an error in your SQL syntax near
'thread_cache_size=4M' at line 1
mysql> set thread_cache_size=4M;
ERROR 1064: You
Scott
--Original Message-
> I have a database table with say 100 rows. What I would like is to
> preform
> a query starting at a random place within the table, that will wrap
> around
> if I want it to. That is if the query starts returning results at the
> 98th
> row, then
Ok all, here's a topic on performance. I'd appreciate your opinions.
Relevant documents would be the mm-mysql-driver interfacecode for
ResultSet, and Statement.
I have the following issues... One... when I ask for a query where I'm going
to get 1Million rows, what I see is that my JVMachine s
Hi,
I installed MySQL 3.23.54 on HPUX system with NIS.
If I run "/opt/mysql/bin/mysql -hlocalhost -uroot
mysql", everything looks fine.
But if I run
$ /opt/mysql/bin/mysql -hhostname.domain -uroot mysql
ERROR 2013: Lost connection to MySQL server during
query
And I can't connect to MySQL with
James,
What you are describing is a many-to-many relationship and is very
commonly done.
You should be able to get your desired output using your existing
structure with something like:
SELECT i.item_id AS "Item Number",
i.item_desc AS "Item Description",
o.option_desc AS "Optio
> -Original Message-
> From: Peter Rønning [mailto:[EMAIL PROTECTED]
> I'm planning to set up an MySQL database on a server, and
> connect to it
> over the internet (no connection to a website or anything, just a
> private db server). Just wondering what is the recomended way
> to do it,
1 - 100 of 117 matches
Mail list logo
