Hi,
I've just upgraded my MySQL from version 3.22.32 to 3.23.42 from source
(which was an extremely easy exercise might I add). Now I'm not sure
whether or not I should also recompile the php and Apache code...I've
read another posting which suggested this is a good idea to keep the
system st
Hi,
> Order By clause without Limit returns:-
> A
> B
> C
> C
> C
> C
> C
> C
> M
> N
> T
> W
>
> Order By clause with Limit returns:-
>
> C
> C
> C
> C
> C
> C
> M
> N
> T
> W
>
> Is there any way to fix this, so that the results with the limit comes
> out starting with the A and then moves on t
Please solve the problems
#
# groupadd mysql
# useradd -g mysql mysql
# cd /export/home0
# gunzip < mysql-3.23.33.tar.gz | tar xvf -
# cd mysql-3.23.33
# ./configure --prefix=/usr/local/mysql
# make
make all-recursive
I have compiled 3.22.32, ...3.23.40.. 3.23.42
All on Linux w/ kernel 2.2.10
Hello, All
I built a spammer cgi some time ago that sends opt-in email to a list
of recipients stored in a member account db. It has ran fine in the
past. However, recently it is generating 2013 errors (Lost connection to
Mysql server during query) .
The script works by accepting news letter qu
On Fri, Sep 28, 2001 at 09:31:26AM -0600, Adam Douglas wrote:
>
> 1. Number of Database Administrators/Developers to support MySQL and overall
> number of employees in the company.
Hmm.
We have no full-time MySQL DBAs. You don't need one! We have several
developers who spend a small amount of
On Fri, Sep 21, 2001 at 01:43:32AM -0400, Will French wrote:
>
> Actually yes (if I read the documentation correctly - I have not
> tried this).
But if his ISP won't allow it, he can't do it.
Maybe I misunderstood.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Financ
check the command line option -d (or --no-data)
> -Original Message-
> From: Barry McClure [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 03, 2001 1:45 AM
> To: [EMAIL PROTECTED]
> Subject: --How to dump only table structure with MySQLDump?
>
>
> I would like to extract the DDL f
Try something like that in your SQL query:
"SELECT * FROM table_name ORDER BY FIELD_NAME"
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 22:14
To: Hakan Wolf
Cc: 'MySQL Mailinglist'
Subject: Re: sort mysql data
On Tue, Oct 02, 2001 at
I would like to extract the DDL for the database so I can re-run it elsewhere.
MySQLDump can do that, but it also exports the data. Is there a way for it
to just export the Create Table statements?
TIA
Barry
-
Before posting,
Hi DBAs:
I want to copy TableA in DatabaseA to TableB in DatabaseB
with changes in the attributes of the tables, what options do I have?
I tried these:
a) insert into TableB (id) select (id) from DatabaseA.TableA;
this works
b) insert into TableB (id,data) select (id,data) from DatabaseA.Table
mysql - version 3.23.40-log (build from src)
i have created a database that records ahrs worked and have
2 fields (amongst others) ahrs_start & ahrs_end both are set as type time
(hh:mm:ss)
as we get paid for a minmum of 1hr for being called out i would like to be
able to
craft a query that su
Hi,
I would like to copy a database column ( row[index] ) into a string
variable to get it onto a form. the example mysql provides are directing
the column to cout, but how do I copy the column to a string variable
???
please help.
many thanks
Johann
---
Please solve the problems
#
# groupadd mysql
# useradd -g mysql mysql
# cd /export/home0
# gunzip < mysql-3.23.33.tar.gz | tar xvf -
# cd mysql-3.23.33
# ./configure --prefix=/usr/local/mysql
# make
make all-recursive
Making all in include
Making all in Docs
Making all in readline
Making all in
> It may not intuitive at first, but it is really what one
> wants for default. For example, how would you else know, whether
>
> test
> asdf
>
> was originally one row ("test\nasdf") or two rows ("test"+"asdf")?
I would know because I'm the one who thought up and wrote -- for good
reasons -- the
Hi!
On Oct 02, Thomas Deliduka wrote:
> For MySQL Full-text Searches and indexes. Do these indexes take up a lot of
> disk space?
>
> Any information on this out there as to how much on average?
In default configuration (that is without changing myisam/ftdefs.h)
index can be as big as original
It will be available just in a few days for what I have been told.
Not yet there.
Daniel
>
> by what i have seen there is a 4.0 version of MySQL. Where can I find
> more information about and even download a version of it ?!?!? Thanks.
>
by what i have seen there is a 4.0 version of MySQL. Where can I find
more information about and even download a version of it ?!?!? Thanks.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
For MySQL Full-text Searches and indexes. Do these indexes take up a lot of
disk space?
Any information on this out there as to how much on average?
--
Thomas Deliduka
IT Manager
-
New Eve Media
The Solution To Your Internet Angst
http://www.neweve.com/
Are you sure you have space on
/var/mysql/mysql
and that mysql user have access to it.
That's where it is by default on OpenBSD.
Daniel
> -Original Message-
> From: David Reid [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 17:15
> To: [EMAIL PROTECTED]
> Subject: OpenBS
OpenBSD 2.9 on macppc (G4 Cube). Built mysql-3.23.42 fine straight "out of
the box". Then, when I try to install the database it stops being such a
perfect easy install. This is what I see, so if anyone can explain why I'd
be very interested to know. Searching on deja and the mailing list arch
Have you checked that /tmp isn't full? If /tmp is its own filesystem, and
its full, then no matter what the permissions you won't be able to write to it.
At 10:24 PM 10/2/01 +0200, you wrote:
>When execcuting some queries in MySQL (3.23.42) on Redhat 7.1 i'v got
>error:
>ERROR 1: Can't create/w
[EMAIL PROTECTED] writes:
> I've been trying to figure out a way to combine all these queries into one query
> , if it's at all possible or if it's practical to combine them into one large
> query. The single query I tried doesn't produce the proper results.
[SNIP]
I'm not surprised, seeing how
Thank you
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 02 October 2001 21:38
To: David Ayliffe
Cc: [EMAIL PROTECTED]
Subject: Re: HOW: Getting a list of connected users?
On Tue, Oct 02, 2001 at 09:21:03PM +0100, David Ayliffe wrote:
>
> Is it possible to get
On Tue, Oct 02, 2001 at 09:21:03PM +0100, David Ayliffe wrote:
>
> Is it possible to get a list of all users currently connected to a
> mysql server? Preferably the login name they use? Any ideas? I
> would like any commands which work on both windows and linux MySQL
SHOW PROCESSLIST
Jeremy
-
David Ayliffe writes:
> Is it possible to get a list of all users currently connected to a mysql
> server? Preferably the login name they use? Any ideas?
http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http
When execcuting some queries in MySQL (3.23.42) on Redhat 7.1 i'v got
error:
ERROR 1: Can't create/write to file
'/tmp/root-tmp.03a811f23b28d045/files/#sql61ba_d_0.MYI' (Errcode: 2)
/tmp dir permission is 777 so there shouldn't be problem. When i create dir
which mysql wants to write to everyth
Is it possible to get a list of all users currently connected to a mysql
server? Preferably the login name they use? Any ideas? I would like
any commands which work on both windows and linux MySQL
Thanks lots
David Ayliffe
ICQ# 125646758
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, Oct 02, 2001 at 09:
Hello All,
I have several queries that generate various financial reports, by date ranges.
I've been trying to figure out a way to combine all these queries into one query
, if it's at all possible or if it's practical to combine them into one large
query. The single query I tried doesn't produce
Hi!
I am forwarding the following message from
the newsgroup mailing.database.mysql
richarde explained that from the rpm you
have to install both MySQL-... and MySQL-Max-...
(As a sidenote people recently asked if there
is a newsgroup on MySQL. It is the above mentioned
newsgroup, but it is not
Hi!
The log sequence number is only 300 000 bytes :).
You have data and log files which are almost completely
full of zeros, and consequently if you compress them
with gzip, you are able to send them to me as attachments.
Some notes on possible Linux bugs:
I notice that you are running the Lin
Hi,
I am looking into using optimization of the GCC 2.95.3 for I686 as
-O3 -mpentiumpro
to compile an optimize version of MySQL.
But as I look around, I see that some user warned about using this as they
said there is bug in GCC for I686 optimization.
Any information you can pass to me on tha
Oops,
Yea, that's pretty obvious now that you pointed it out!
Thanks
Eric
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 1:11 PM
To: George Eric R Contr AFSPC/CVYZ; mysql
Subject: Re: How to Dump only Data
Yes, the mysql process is writi
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin
> Hi.
>
> On Mon, Oct 01, 2001 at 07:54:37PM -0700, [EMAIL PROTECTED] wrote:
> >
> > Hi there,
> >
> > I have a many-to-many relationship:
> >
> > ind table
> > -
> > id = 4, name = Joe
Yes, the mysql process is writing the file so mysql must have
permissions to write there. Try writing /tmp/myfile.txt or create a
directory with write permissions for the group or user that mysql is
running as.
Best of Luck
Ken
- Original Message -
From: "George Eric R Contr AFSPC/CVYZ"
The error message you get is not related to PHP, but to the access right
preset into MySQL.
Basically, MySQL tell you that you can't connect to it with the user name
testing.
Check your right access in MySQL.
Daniel
> -Original Message-
> From: Harpreet [mailto:[EMAIL PROTECTED]]
> Se
Dear list members,
This is the first time i am trying to connect to my database on mysql using
php.
The code is :
Error message:
Warning: MySQL Connection Failed: Access denied for user:
'testing@localhost' (Using password: YES) in /var/www/html/contact.php on
line 8
Please help.
Regards,
Har
I just tried this, but I get the result:
mysql> SELECT * FROM ga_perf INTO OUTFILE "/home/georgee/ga_perf.out";
ERROR 1: Can't create/write to file '/home/georgee/ga_perf.out' (Errcode:
13)
my username (georgee) is fully priveledged, and /home/georgee is my home
directory, so I certainly have pe
Heikki,
Update on this. Managed to get this to happen with the file updates you
sent, on an internal box(same config as original problem rpt), log info
follows:
//Log file starts
011002 13:28:19 mysqld started
InnoDB: Database was not shut down normally.
Colin Faber wrote:
> it sounds like you've run out of file descriptors, I suggest
> rebuilding your kernel to handle more.
>
> In a bsd kernel you can do this simply by upping the maximum number of
> users allowed to access the machine at any given time.
Or in Linux (in my rc.local):
echo "Set
>Here's what I did:
>
>mysql> create database testnull;
>Query OK, 1 row affected (0.05 sec)
>
>mysql> use testnull;
>Database changed
>
>mysql> create table info (birth date);
>Query OK, 0 rows affected (0.03 sec)
>
>mysql> show tables;
>++
>| Tables_in_testnull |
>+--
it sounds like you've run out of file descriptors, I suggest
rebuilding your kernel to handle more.
In a bsd kernel you can do this simply by upping the maximum number of
users allowed to access the machine at any given time.
Robin Keech wrote:
>
> Hi,
>
> Any help would be greatly appreciat
An enum should work fine as you've described, but remember that the ENUM
type is a MySQL proprietary type and if you ever want to convert to
another database (Oracle, PostgreSQL, MSSQL, Etc.), you may have to find
an appropiate solution (i.e. convert to integer and use 0 and 1)...
On Tue, 2 Oct
On Mon, Oct 01, 2001 at 04:41:58PM -0600, Spinlock wrote:
> I was using gcc not g++
The guts of MySQL are written in C++, and hence the Gnu C++ compiler
will be used:
>From the manpage gcc(1):
DESCRIPTION
The C and C++ compilers are integrated. Both process
input files t
Here's what I did:
mysql> create database testnull;
Query OK, 1 row affected (0.05 sec)
mysql> use testnull;
Database changed
mysql> create table info (birth date);
Query OK, 0 rows affected (0.03 sec)
mysql> show tables;
++
| Tables_in_testnull |
++
| i
>From page 620 in MySQL...
* -t or --no-create-info
Does not write CREATE TABLE statements
Since DROPs are off by default, this should give you just the insert
statements.
The other option (as already suggested) is SELECT INTO OUTFILE.
Jay Fesco
> -Original Message-
> From: fi-claudem
Here directly from Paul Dubois's book page 619-620
mysqldump --opt db_name > backup_file
So, it would be here:
mysqldump --no-create-info db_name > backup_file
Or if you want the create statement as well, just do
mysqldump db_name > backup_file
His book is a very good one and have all you c
Didn't work... still there are informations and the INSERT INTO clause
into the dumped file
Thanks anyway!
Claudemir F. Martins
Robert Cope wrote:
>On Tue, Oct 02, 2001 at 01:55:13PM -0300, fi-claudemir wrote:
>
>>How to Dump only the data from a Table.
>>I took a look at the mysqldump option
Hi Claudemir,
Perhaps you are really looking for SELECT INTO OUTFILE syntax?
http://www.mysql.com/doc/S/E/SELECT.html
Ken
- Original Message -
From: "fi-claudemir" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 12:55 PM
Subject: How to Dump only Data
Hi
How to Dump only the data from a Table.
I took a look at the mysqldump options, but I didn't find something that
works fine !
Regards
Claudemir F. Martins
-
Before posting, please check:
http://www.mysql.com/manual.php
As far as I know. There is no 3.24.xx coming out, but instead 4.0 in a few
days or weeks according to various posting on this list.
But I know be wrong!
Hope this help
Daniel
> -Original Message-
> From: John Seers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 11:44
> T
> If I read a file into a database with a \N in an empty date field
> the field
> is populated with -00-00. If I insert a row into the same
> database with
> NULL in the date field it is populated with NULL.
>
> Programmatically is there a difference between the two?
>
The field is proab
>Description:
Hi,
I have 28 linux boxes configured identically, 27 as slaves, one as
master. On all 27 slaves, everything works fine, but only on one I have strange
errors in the logs:
011002 17:49:49 Slave: received 0 length packet from server, apparent master
shutdown: (0)
011002 1
At 9:11 AM -0500 10/2/01, [EMAIL PROTECTED] wrote:
>How dependent is MySQL on proper NFS locking between threads of
>the same server?
Running MySQL over NFS is a bad idea.
--
Paul DuBois, [EMAIL PROTECTED]
-
Before posting, pl
At 5:22 PM +0200 10/2/01, Malko Malko wrote:
>>Description:
>When multiplying a date field with a number( any type ) field
>for some values in any of these 2 fields mysql did nt answer to
>queries.
>>How-To-Repeat:
>#
># Table structure for table 'testdate'
>#
>
>CREATE TABLE testdate (
At 11:48 AM -0300 10/2/01, Ashwin Kutty wrote:
>Hi,
>
>I have been using the ORDER By clause in one of my sql queries and
>it works fine; however when I combine it with a LIMIT it still
>order's the results by it doesn't do it the way its supposed to, for
>example:-
Your examples don't show th
At 9:04 PM +1000 10/2/01, Bruce Collins wrote:
>Hello,
>Thank's for your interest Paul. I did a poor job
>of explaining my problem. Here is another go:
>For an athlete's first entry in the database I need a column
>value of 1. The second performance entry of the same athlete
>would have a value of
At 9:06 AM -0400 10/2/01, Frank J. Schmuck wrote:
>If I read a file into a database with a \N in an empty date field the field
>is populated with -00-00. If I insert a row into the same database with
>NULL in the date field it is populated with NULL.
>
>Programmatically is there a difference
(Apologies in advance if this is the wrong place to ask, but this is my
first foray into this list.)
I would like to use Subselects with mySQL but they are not supported
until 3.24.
Can anyone tell me if there is an estimated date for the release of
3.24?
Secondly is it likely that the 3.23be
Malko Malko writes:
> mysql> select date,coef,sec_to_time(time_to_sec(date*coef)) from testdate;
Why do you multiply the date with a number and then convert
it to a number? Shouldn't it be the other way around? :-O
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTE
Hi,
i have a simple question:
how many databases is mysql able to handle.
i have a mysql server on a dual xenon with 2GB ram
with 300 Databases (for each customer one)
but in the meantime a simple query takes ages to complete >10s
select * from table tablename
(11K rows)
(no other links are acti
>Description:
When multiplying a date field with a number( any type ) field for
some values in any of these 2 fields mysql did nt answer to queries.
>How-To-Repeat:
#
# Table structure for table 'testdate'
#
CREATE TABLE testdate (
ID int(11) NOT NULL auto_increment,
DATE time DEFA
In the last episode (Oct 02), denis mercier said:
> I am presently going over the mysql documentation to get familiar
> with it, It runs great on my development server (linux RH7.1
> kernel=2.4.2-2 resin application server), I am in the process of
> optimizing and testing , I am using blob datatyp
Hi,
I have been using the ORDER By clause in one of my sql queries and it works
fine; however when I combine it with a LIMIT it still order's the
results by it doesn't do it the way its supposed to, for example:-
Order By clause without Limit returns:-
A
B
C
C
C
C
C
C
M
N
T
W
Order By clause
hi
I am presently going over the mysql documentation to get familiar with
it,
It runs great on my development server (linux RH7.1 kernel=2.4.2-2
resin application server),
I am in the process of optimizing and testing , I am using blob datatype
in my main table,
I understand why a fixed-size form
A piece of cake for MySQL.
Our news/photo database is growing by nearly 10,000 records per month, with
no noticeable performance impact. As long as you design your database
structure and queries right ...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Paul Murphy [mailto:[EMA
I've decided on enum. Should work fine. I've used it before and it works fine
with PHP.
Thanks for everyone help,
Jord
On Tuesday 02 October 2001 12:13, you wrote:
> >If I wanted to define a table to have a cloumn which is either yes or no
> > for example. Would it be better to use a single ch
How dependent is MySQL on proper NFS locking between threads of
the same server?
Some background: I have a small application with lots of data that
stores recent RADIUS records for lookup by techs to help diagnose
dialup problems. The application runs with MySQL 3.23.10 (yes, I
know, I ought to
try
echo "select \"test \n test\"" | mysql -N -B stud > out.txt
Uriel Wittenberg wrote:
> I have a batch file called mysql.txt containing the single line,
>
> select "test \n test";
>
> My command for running this file is:
>
> mysql -N -B stud < mysql.txt > out.txt
>
> After running the com
That is a permissions error. Mysql does not own the database directory.
chown -R mysql /var/lib/mysql
Mailing List Receiver wrote:
> With basedir and datadir=/var/lib/mysql the error is:
> 011001 16:16:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
>
> With basedir=/
Hi,
I would suggest you upgrade to FreeBSD 4.3 or better 4.4 (Which just
came out a coupel of weeks ago). 4.2 has threads and compiler bugs.
You can do an in place upgrade, but after upgrading don't forget to
recompile MySQL (unless you are using the binary provided by mysql
group). See www.f
> Is there any way to insert more than one row at a time??? The data that
I
> have will change with each row, but is there a way to insert 900 rows
(with
> different values for each) all at once?
INSERT INTI VALUES (row1), (row 2), (row3) .
where rowN is a list of values for the row in
Did you find the solution ?
-Message d'origine-
De : Bruce Stewart [mailto:[EMAIL PROTECTED]]
Envoyé : 20 août, 2001 11:41
À : 'Roy, Steeve'; [EMAIL PROTECTED]
Objet : RE: MySQL OLEDB
Steeve,
I have had the same problem for months, with no solutions.
If you find a solution, please let
Hi,
We are planning to create an web database(6 - 7 tables with the average of 6
columns), where members search for the right person by entering the proper
search criteria. We expect that this database will grow in the rate of 1000
to 2000 records in a month.
Could you please let us know whether
If I read a file into a database with a \N in an empty date field the field
is populated with -00-00. If I insert a row into the same database with
NULL in the date field it is populated with NULL.
Programmatically is there a difference between the two?
Thanks
Frank
--
Is there any way to insert more than one row at a time??? The data that I
have will change with each row, but is there a way to insert 900 rows (with
different values for each) all at once?
database,sql,query,table
PS The listserv is starting to piss me off... Must have one of the keywords,
no
Bruce,
Why not just determine this number when you do a query? Why do you need to
have it be stored in the database?
It's easy to create a Perl (or probably PHP, but I really don't know PHP)
script to fill in such a column, too, but you would need to manually
maintain that. And right now I don
Heikki,
The only ones I found were in /usr/share/mysql. Did a "find" starting in root.
Robert
Heikki Tuuri <[EMAIL PROTECTED]> wrote:
> Robert,
the installation program obviously failed to put
the new errmsg files to the right place. Look for
the new errmsg files somewhere, usually the directo
Hello,
Thank's for your interest Paul. I did a poor job
of explaining my problem. Here is another go:
For an athlete's first entry in the database I need a column
value of 1. The second performance entry of the same athlete
would have a value of 2. And so on.
I need to apply this retrospectively t
Robert,
the installation program obviously failed to put
the new errmsg files to the right place. Look for
the new errmsg files somewhere, usually the directory
is something like .../share/english, and copy them
to /usr/share/mysql/english
Regards,
Heikki
http://www.innodb.com/ibman.html
>Just
>Hi there. I have problems with mySQL
>What I would like to do is:
>I have a statement
>SELECT a.id AS ID, IDmark, IDrecipe, ocenjevalec, ocena,
>ROUND(AVG(ocena),1) as povprecje, COUNT(*) as all, IF (ID=ocenjevalec,
>'yes', 'no') as zeocenil
>FROM ocenerecepti, obiskovalci
>WHERE IDrecept = 13
Just installed MySQL Max 3.23.43 on a LInux box from the rpm. When starting get the
following message:
/usr/sbin/mysqld-max: Fatal error: Error message file
'/usr/share/mysql/english/errmsg.sys' had only 205 error messages, but it should have
at least 213 error messages.
Check that the above f
Hi,
so far I know is MySQL able to handle Enums in a very efficient way.
So I'd advise you to use Enums.
Best regrads
Bernhard
- Original Message -
From: "Jordan Elver" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>; "PHP DB Mailing List"
<[EMAIL PROTECTED]>
Sent: T
Jordan Elver writes:
> Hi,
> If I wanted to define a table to have a cloumn which is either yes or no for
> example. Would it be better to use a single char (0 or 1), or can I use an
> enum (I find them more friendly ;)).
If you use an enum you might end up with the value '' if
you enter some
Hi,
Any help would be greatly appreciated as I have a production server that is
struggling.
(I only get the digest list, so could you copy me on any replies -
thankyou).
My error log show this...
011002 9:16:11 Error in accept: Too many open files
011002 9:36:43 /usr/local/mysql/libexec/mys
hello,
sorry for my english,
I have a compaq bi PII 400 Mhz with 512 Mo of ram.
Linux mandrake 8 kernel 2.4.6
MySQL 3.23.36, apache 1.3.19 with php 4.0.4pl1
disk free space /usr/ : 2Go /var/ : 2,4 Go
I want to create a benchmark with linux + apache + php + mysql vs linux +
apache + php + postgr
86 matches
Mail list logo
