On Fri, Jul 27, 2001 at 09:01:09PM -0400, Nick Seidenman wrote:
I'm seeing two problems with temporary tables:
1) I keep getting table is full errors. I set sql_big_tables to one, as
the docu directs, but this doesn't seem to have had any effect.
Do you have sufficient disk space?
On Fri, Jul 27, 2001 at 09:29:20PM -0700, Michael Collins wrote:
I have a table that shows MUL in the key field column, what does
that indicate?
That means it's a non-unique key.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408)
Hi guys..
I've been thinking on something for a little while and I need some advice.
I am inserting several fields into a table, however there's an 'id' (id integer not
null auto_increment) column that I use as the primary key.
the problem lies in the fact that I want to get the 'id' that was
I am inserting several fields into a table, however there's an 'id' (id integer not
null auto_increment) column that I use as the primary key.
the problem lies in the fact that I want to get the 'id' that was generated from
this insertion. However the data I insert has no unique value apart
Hi!
On Jul 27, Peter Szekszardi wrote:
Hi,
I have recompiled mysql using the hungarian character set, reindexed all
the tables,...
I have strange problem now:
Ok, could you create a test case for that ?
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_
If you had read the installation instructions, you would have seen
statements that looked like this...
cd /usr/local/mysql
./bin/mysql_install_db
Make sure that the var directory that is created grants access to the
'user' that MySQL is running as... (otherwise I'm sure we'll be
I have a stock of Box sets, which contain a MySQL manual together with a
distribution CD that includes the following:
1. Binary for: Linux, Solaris, SGI Irix, AIX 4,x DEC Unix 4,x Tru64 Unix,
SunOS 4,x SCO, Hpux,PPC Win32, FreeBSD+BSDI+NetBSD
2. Contribution programs
3. Documentation
4. Examples
tj marlin wrote:
This virus is becoming wide spread. It appears to use a machine's address
book and mail itself to the members of the address book. i've received mail
with the virus from a number of people, in addition to receiving it from
this list.
And, I have a bunch of stranger's
I am going to violate a principle and burn up some bandwith here
to say samething that most people probably feel about this post.
BRAVO VAN, for summarizing this situation cogently, and fairly.
With this kind of measured observation, the statement that Microsoft
software sucks does not embody a
Bruce Ferrell writes:
I'm replying to the list because I got so many of these back:
Ya know gang... some days it just doesn't pay to get outta bed.
Yes, indeed, this is the exact reason my wife doesn't let me do arithmatic :)
Sorry and to the guy who replied with no spam please?
David Ayliffe writes:
pc-xx-xx-190-118-du:~/mysql++-1.7.9/examples # g++ -I../sqlplusint/
-I/usr/local/include/mysql -c simple1.cc -L../lib
../lib/libmysqlclient.a -lsqlplus
g++: ../lib/libmysqlclient.a: linker input file unused since linking not
done
g++: -lsqlplus: linker input file
Brad Morris writes:
I'm perplexed.
My company develops a browser-based application that uses the mySQL 'C' API
to talk to the MySQL backend.
I'm currently trying to find a solution to a problem my company is having
with migrating from MySQL v.3.22 to v.3.23. Here are the details:
1.
GoFind.RO writes:
When a try to fix a .MYI file , myisamchk dumps core. You can download the
file from http://gofind.ro/dbs.MYI
I fixed a lot of other files and it worked perfect, but this one
I have MySQL-3.23.40-1 installed from original RPM , running on Linux
Mandrake 8.0 on a P3
I have received 30+ of those emails. It seems 90% of my contact list is dumb
enough to open strange attachments. Go figure
- Original Message -
From: Duncan Hill [EMAIL PROTECTED]
To: Steve Brazill [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 5:04 PM
Subject: Re:
[EMAIL PROTECTED] writes:
Description:
I'm compiling with GNU make and tar, and SunPro C++ V6 r2
This compiler is now called Forte C++, but it is SunPro.
I did miss the Solaris section in the docs. I believe I followed
them to the letter this time. I did the following
Van wrote:
[== snip, snip ==]
Anyone else see the irony? Small wonder Open Source hasn't been lucrative.
We're solving all the problems of the money makers at our own expense. Time we
should look at how open we want our own model to be to clients who choose models
of lesser openness. I'd
Thanks for reading this - I have searched all the MySQL info I can find as
well as the web at large, but nobody seems to have offered a real answer to
the following problem, which many have had, though possibly only with Win32
client machines accessing UNIX servers:
The problem arises when
Dave Fogle writes:
Thanks for reading this - I have searched all the MySQL info I can find as
well as the web at large, but nobody seems to have offered a real answer to
the following problem, which many have had, though possibly only with Win32
client machines accessing UNIX servers:
The
Thanks for responding, but the full path is not the answer.
I have tried every conceivable full path (see original message) and it does
not help. In fact, the only thing that has ever worked was using no path
info and putting the file in the root of the C: drive on my local machine.
But for
I have a table called stats with:
user varchar(40) not null primary key,
count mediumint not null.
I want to do something like this:
UPDATE stats SET count=count+1 WHERE user='$user';
But if there is no row in the stats table having user='$user', that
statement will not create the row.
The
At 11:08 PM -0700 7/27/01, Jeremy Zawodny wrote:
I have a table that shows MUL in the key field column, what does
that indicate?
That means it's a non-unique key.
Thank you, but what does MUL stand for? Multiple keys?
I suppose it is a key since I created an index on that field.
--
I need to Telnet into my domain in order to run some MySQL utility like
mysqldump (for backup). I am not experienced with Telnet. Any pointers? Any
way around it (use mysqldump from PHP?)
Thanks, Marco
|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
|
Hi,
I am currently running PHP3 and would like to upgrade
to PHP4 and lastest version of MySql.
I am kinda new at this was wondering if somone could
guide me in the right direction.
Do I need to do a complete install of both?
Kris
__
Do You
On 28-Jul-2001 Philip Mak wrote:
I have a table called stats with:
user varchar(40) not null primary key,
count mediumint not null.
I want to do something like this:
UPDATE stats SET count=count+1 WHERE user='$user';
But if there is no row in the stats table having user='$user', that
Hi!
I'm not subscribed to the list, so please CC: [EMAIL PROTECTED]
Question:
-
Can mysqld --skip-grant-tables --bootstrap ... be run on a *live* system
(with a regular mysqld server running) or can this cause data corruption.
Info:
-
We are working on a Linux server project aimed
On Wed, Jul 25, 2001 at 12:03:59PM +0400, Artem V. Ryabov wrote:
Hello All,
When I use order by .. DESC in query, time always more then in
order by .. ASC case.
Explain say Using filesort,in DESC case query.
Why???
Because in 3.23.xx, MySQL doesn't know how to walk the index nodes
At 18:06 28-7-01 +0200, Marco Bleeker wrote:
I need to Telnet into my domain in order to run some MySQL utility like
mysqldump (for backup). I am not experienced with Telnet. Any pointers?
Any way around it (use mysqldump from PHP?)
Good reason to learn it :-)
You could try phpadmin (or was
My MySQLGUI running on a Windows system is invariably much slower(typically
30 seconds) than a MSAccess database with tables linked with MyODBC to the
same Linux-hosted Mysql-database (typically less than 1 second) when
executing the same query over a telephone internet connection.
Why is
On Saturday 28 July 2001 12:23 pm, B. van Ouwerkerk wrote:
You should try to avoid using telnet to be honest, its not secure. Start
using ssh and do a google for ssh usage.
PHPmyAdmin is a great program to use for working with a mySQL DB.
http://www.phpwizard.net/projects/phpMyAdmin/
But
I do not know if this will help or not...
Why not use gnupg to create a public key, encrypt the root password using
the your keys, save or email the encrypted root password that you store in
your mysql maintence database. You can then query your database and take
that information and decrypted
There are secure telnet packages. one for windows is SecureCRT. see
www.vandyke.com
for tips and pointers: basic telnet gives you a link to your server thru
your own pc. it is as if you were directly connected to your server.
At 01:24 PM 7/28/01 -0600, you wrote:
On Saturday 28 July 2001
Has anyone done a db for a multi-level compensation structure? I'm talking
about a company that is MLM or a multi-level marketing network. Where
distributors sign up under other distributors and the downline can go down
many levels(but limited levels!). The important issue is how long would it
You need to provide some more details about your task. What programming
language you want to use, and probably a sample from the file that matches a
repetitive subunit within the text. This information is needed since there
is a high chance that you need to exploit regular expression matching for
I am new to the list, and have only asked two questions. However, when I post I seem
to get a message back from [EMAIL PROTECTED] about not wanting me to spam. Am I doing
something wrong here? Does anyone else get this message as well?
Thanks,
SJS
On Saturday 28 July 2001 02:44 pm, tj marlin wrote:
Telnet is NOT secure. The user name and password are passed to the server
through plaintext. Therefor anyone on or with access to your network
(meaninghyour ISP) can sniff and acquire this information with ease.
SecureCRT (which i proudly
At 13:44 28-7-01 -0700, tj marlin wrote:
There are secure telnet packages. one for windows is SecureCRT. see
www.vandyke.com
Rather use PuTTY.. it's free!! and a very good SSH client I wonder how
many sysadmins still allow telnet..
Use your favorite searchengine to find PuTTY.. or find
I am new to this list. I posted a perfectly honest question, but all I get
back is an email from [EMAIL PROTECTED] saying NO SPAM PLEASE. I checked
appua.com. The site is in Russian. I don't understand why I'm getting this.
Perhaps someone can explain. In the meantime, here's my question --
Hello all!
I have a question for all of you... I would very much appreciate your
input.
I'm building a database for a radio station. The database must allow
the DJ to enter what they play and when, and allow the program director
to create weekly reports for the record labels.
I'm wrestling
Robert Roberts wrote:
I am new to this list. I posted a perfectly honest question, but all I get
back is an email from [EMAIL PROTECTED] saying NO SPAM PLEASE. I checked
appua.com. The site is in Russian. I don't understand why I'm getting this.
Perhaps someone can explain. In the meantime,
I'm building a database for a radio station. The database must allow
the DJ to enter what they play and when, and allow the program director
to create weekly reports for the record labels.
[snip]
First, to maintain a single table with every bit of track data there is
(ie, title, artist,
My assumption:
mysql GRANT SELECT, INSERT, UPDATE ON client_db.*
TO db_user@localhost IDENTIFIED BY 'password';
Now this is where I get a bit confused. It's not clear to me where the
client is connecting from. I assume they are connecting from localhost
because everything is
So you're saying like this...?
Albums
--
ID,Artist,Title,Label
Tracks
--
Title,Length,TrackNumber,AlbumID
Where there is one album table and one track table, and each track
references back to the album that it is a member of? I'm liking that...
It doesn't make it easy to dig through
The rule of normaliztation is (usually) if you have data repeated in a table,
you need another table. So here's how *I* would do it.
A table for each: DJ's, Albums, Artists, Genres (a category table of sorts),
and Tracks. You might even want a table for record companies, so that's not
Can any please help with is?
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql' (111)
root 682 1 0 15:35 ?00:00:00 /bin/sh /usr/bin/safe_mysqld --d
mysql 730 682 0 15:35 ?00:00:00 /usr/libexec/mysqld --defaults-f
mysql 752
Ben Bleything wrote:
Hello all!
I have a question for all of you... I would very much appreciate your
input.
I'm building a database for a radio station. The database must allow
the DJ to enter what they play and when, and allow the program director
to create weekly reports for the
On 28-Jul-2001 Ben Bleything wrote:
Hello all!
I have a question for all of you... I would very much appreciate your
input.
I'm building a database for a radio station. The database must allow
the DJ to enter what they play and when, and allow the program director
to create weekly
When you are designing a database and you are thinking about creating a
comma delimted list, this is a good sign that you need to rethink your
design. Bitfields are a good option, however if you ever need to add
elements to the bitfield (ie bitfield A can signify the presence of 4
elements, but
I'm posting to this general list because there doesn't seem to be any
list to report a spontaneous crash to.
Have tested MySQL 3.23.39-nt for some days by implementing a small
project. It has been running fine up to now when I after having dropped
a column from a table using MySQL GUI, tried to
I am creating a database server with mysql.
I have an adaptec 2100s card which is not supported by debian 2.2 (my first
choice in Linux OSs)
The card seems to say that it is only supported by Red hat and SuSe Linuxes.
Any ideas on what would be the best OS to run a database server
My config
On Sat, Jul 28, 2001 at 08:12:34PM -0600, Michael Blood wrote:
I am creating a database server with mysql. I have an adaptec 2100s
card which is not supported by debian 2.2 (my first choice in Linux
OSs)
The card seems to say that it is only supported by Red hat and SuSe Linuxes.
Any
So you're saying like this...?
Albums
--
ID,Artist,Title,Label
Tracks
--
Title,Length,TrackNumber,AlbumID
Where there is one album table and one track table, and each
track references back to the album that it is a member of?
I'm liking that... It doesn't make it easy
On Wed, Jul 25, 2001 at 10:32:38PM -0600, Chris Bolt wrote:
I am currently trying to examine the benefits of continuing to
use MySQL over Oracle. I need to know what MySQL's features are
vs. those of Oracle.
http://www.mysql.com/information/crash-me.php
Also I am looking for
On Fri, Jul 27, 2001 at 05:55:28PM -0300, Gatica, Mario Alberto wrote:
Is there any performance difference between running a query on a
compressed MyIsam Table rather than a normal MyIsam Table ?
Of course, but it's probably not significant on modern hardware. Try
a quick test and see.
So sprach »James McLaughlin« am 2001-07-28 um 13:24:21 -0600 :
PHPmyAdmin is a great program to use for working with a mySQL DB.
http://www.phpwizard.net/projects/phpMyAdmin/
Or, for a more recent version of phpMyAdmin:
http://phpMyAdmin.sourceforge.net
PS: sql
Alexander Skwar
--
How to
So sprach »tj marlin« am 2001-07-28 um 13:44:03 -0700 :
There are secure telnet packages. one for windows is SecureCRT. see
www.vandyke.com
That's a contradiction in itself. Telnet never can be secure, as it
transmits all the data in clear text. It's very easy to sniff sensitive
data from a
So sprach »Jeremy Zawodny« am 2001-07-28 um 19:28:04 -0700 :
Have you looked at Debian unstable? It uses the newer 2.4 kernels
and, despite its name, it rather good.
You're kidding, aren't you? You cannot honestly suggest Unstable for a
prodction server! Well, Testing is fine, but Unstable?
Hi!
I'm very new to MYSQL.
I'm trying to make a databases of my friend's personal data.
I divide the data into 2 related tables (relational database).
When I tried to get the data out from (both) tables - I don't find any major
problem. However, when I tried to insert data into both table.. I
On Sun, Jul 29, 2001 at 06:05:37AM +0200, Alexander Skwar wrote:
So sprach »Jeremy Zawodny« am 2001-07-28 um 19:28:04 -0700 :
Have you looked at Debian unstable? It uses the newer 2.4 kernels
and, despite its name, it rather good.
You're kidding, aren't you? You cannot honestly suggest
I would think that most current 2.4 distros, stable of course, should work just fine.
BTW- Congratulations (belated) , Jeremy on the Webby.
Denis Hammond
Systems Administrator
VolunteerMatch
Jeremy Zawodny wrote:
On Sun, Jul 29, 2001 at 06:05:37AM +0200, Alexander Skwar wrote:
So sprach
59 matches
Mail list logo