Hi
I have some problem with my OS system (DEC 0.4) when I ran commad
"# CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/etc/mysql-3.23.39"
error is
"CC=gcc: Command not found."
Ummm I think it maybe not error of mysql but please help me to fix this error.
Thank
---
Hi
I have some problem with my OS system (DEC 0.4) when I ran commad
"# CC=gcc CXX=gcc CXXFLAGS=-O3 ./configure
--prefix=/usr/local/etc/mysql-3.23.39"
error is
"CC=gcc: Command not found."
Ummm I think it maybe not error of mysql but please help me to fix
this error.
Thank
-
This is not a mysql error, Your paths are setup incorrectly or you
don't have GCC installed, set the environment variable `CC' to the
location of your gcc compiler,
CC=something; export CC
KFC wrote:
>
> Hi
>
> I have some problem with my OS system (DEC 0.4) when I ran commad
>
> "# CC=g
I tried to connect to my mysql server but there was
always an error message saying "this host is not
allowed".
Anybody so kind to tell me, "how can I define the
hostname/computer name in my mysql server to be
allowed connect to my database server and use my
kmysqladmin and kmysql software".
Thank
On Mon, Jul 09, 2001 at 01:11:44AM -0700, Prabu Subroto wrote:
>
> I tried to connect to my mysql server but there was always an error
> message saying "this host is not allowed". Anybody so kind to tell
> me, "how can I define the hostname/computer name in my mysql server
> to be allowed connect
We have made up our mind to turn our Access 2000 database into a MySGL one.
Could you please explain us the path to follow and give us information about
it ?
Dominique Vellin
Business developement
Azentis Technology
Your Outsourcing Provider
Tel : 33 1 42 77 21 02
Hi,
is possible to create a mysql without tcp connection ???
i don't need connect via tcp only via unix socket (only from
localhost)
Michal Dvoracek[EMAIL PROTECTED]
-
Before posting, please che
Have you filled out the tables
user, db
in mysql.
And after filling this tables
you must start mysqladmin reload.
Regards Gerlinde
At 01:11 09.07.01 -0700, Prabu Subroto wrote:
>I tried to connect to my mysql server but there was
>always an error message saying "this host is not
>allowed".
>Anyb
>> I use Delphi 5 and MyODBC to access a MySQL database.
>>
>> In my program, I've sometimes a tables locked and I don't understand why
>! I am the only user on this database and I change records correctly (as I
>do it for other programs on other databases).
>>
>> Does somebody have this problem ?
Hi,
I wonder I someone can give me some advice about the following situation. I
have to install MySQL to be used with a website on a virtual server. This
gives the following restraints:
* MySQL must be installed in my user directory
/usr/local/WWW/www.mydomain.com/mysql
* I am only allowed to us
Hi
I have error after use make command like this:# makeNo suffix list.cd include; make link_sourcesNo suffix list./sbin/cp ../config.h my_config.hecho timestamp > linked_include_sourcescd libmysql; make link_sources.
(more output - you can see more details in attach file)
echo timestamp
After you've filled the user and db tables in the mysql database, just give
the command
mysql> flush privileges;
The privileges will be reread. It's easier if you're tuning the whole story.
GRTNX,
Ton Geurts
-Oorspronkelijk bericht-
Van: Gerlinde Fischer [mailto:[EMAIL PROTECTED]]
Ve
On Mon, Jul 09, 2001 at 10:44:24AM +0100, Dvoøáèek Michal wrote:
> Hi,
>
> is possible to create a mysql without tcp connection ??? i don't
> need connect via tcp only via unix socket (only from localhost)
I believe the --skip-networking option does just that.
Jeremy
--
Jeremy D. Zawodny, <[E
You could store the data as XML and use XSL to transform it when you pull it
out of the database
-Original Message-
From: Chris Lott [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 08, 2001 7:39 PM
To: MySQL List (E-mail)
Subject: Storing multi-page texts
What kind of methods have any o
Hi
I have error after make command like
# make
No suffix list.
cd include; make link_sources
No suffix list.
/sbin/cp ../config.h my_config.h
echo timestamp > linked_include_sources
cd libmysql; make link_sources
(more output)
+ /sbin/ln -s ../libmysql/violite.c ./violite.c
echo time
On 09-Jul-01 Asha Ramaiah wrote:
> Hey there!..Don!
> The Problemo returns! :(
> Let me be explicit this time with my query :
>
> mysql> select * from table A;
> +-++
>| mId | tId |
> +-++
>| 1 | 1 |
>| 2 | 1 |
>|
Hi There:
I want to establish several mysql servers which can synchronize
data each other(if data of one server is updated,the others can be
updated too).
I don't know if it's done and how to do this.
Need your helps.
Regards,
Jack
---
I also think that is something with php , because i was checking the code on
my computer on windows with apache, php and mysql installed and it didn't
propmt such errors. I also have another database put on another server, but
the code thats providing data is on the same server where the first dat
Heikki Tuuri writes:
> Hi!
>
> Sun is shining and the weather is excellent in Helsinki :).
> I will be on vacation July 9th to July 16th. I will read email
> a couple of times.
>
> Regards,
>
> Heikki Tuuri
> Innobase Oy
>
>
>
Have a nice vacation !!
--
Regards,
__ ___ ___ _
Have a look
http://www.mysql.com/doc/R/e/Replication_Implementation.htmlat
It is all about what you would like to do.
Simon
-Original Message-
From: chen jun [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 10:52
To: [EMAIL PROTECTED]
Subject: Need your helps!!!
Hi There:
I w
Werner Stuerenburg writes:
> _
> Win98 4.10.98, AMD Duron, 128 MB RAM
> MySQL 3.23.39 running on localhost
>
> _
> Query is
>
> DELETE FROM staticStrings
> WHERE ruri LIKE '
Hi.
I have problems with MyODBC. I would like to use MyODBC with MonitorPRO
software.
During reading data from MySQL I got error: "SQLBindParameter not used for
all parameters...".
I CAN'T change MonitorPRO software code - I need help with configuring
MyODBC or another dirver (for Win NT).
Please,
No. That link is about one way Replication. A main server with backup
servers and if the main server dies, a backup can take over.
What was asked was if any one server is updated, all others are updated.
I'm also interested but I very much doubt it can be done because there is
nothing in the man
> The above behavour can be caused by corrupted table. If however, the
> above DELETE always crashes our latest 3.23.39 binary, you should
> prepare a repeatable test case and send it to [EMAIL PROTECTED]
Sorry, the bug was not about MySQL, but WinMySQLadmin 1.1
>Write in the mail that you
Werner Stuerenburg writes:
> > prepare a repeatable test case and send it to [EMAIL PROTECTED]
>
> Sorry, the bug was not about MySQL, but WinMySQLadmin 1.1
>
> --
> Herzlich
> Werner Stuerenburg
>
> _
> ISIS Verlag, Teut 3, D-32683 B
It can be done but there are a lot of problems with keeping the data in both
or more data bases in line with each other.
But this should be part of the V4 release.
Simon
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 11:34
To: Simon Green; 'chen
> The error : Server has gone away ...
> is not WinMySQLAdmin error, but error on the server side.
True, but WinMySQLAdmin should not crash with a GPF, right? Or is
that an expected behaviour, even a feature?
--
Herzlich
Werner Stuerenburg
_
>No. That link is about one way Replication. A main server with backup
>servers and if the main server dies, a backup can take over.
>
>What was asked was if any one server is updated, all others are updated.
>I'm also interested but I very much doubt it can be done because there is
>nothing in t
What do you send to MySQL? $query is just a string.
Sie schrieben am Montag, 9. Juli 2001, 12:45:48:
> MySQL pops out a error message - "unable to save result set in example.php
> on line xxx"
> but the data gets put inside the database anyway...
Why should php try to save something into a file
Werner Stuerenburg writes:
> > The error : Server has gone away ...
>
> > is not WinMySQLAdmin error, but error on the server side.
>
> True, but WinMySQLAdmin should not crash with a GPF, right? Or is
> that an expected behaviour, even a feature?
>
> --
> Herzlich
> Werner Stuerenburg
> What do you send to MySQL? $query is just a string.
well i send to you only a part of code, here is complete example of it:
[the login stuff]
$zapytanie = "INSERT INTO aktualnosci SET tytul='$tytul', przemd='$przemd',
przeml='$przeml', przemm='$przemm', polska='$polska', swiat='$swiat',
data=
Hello,
we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very
high number of insert-queries (somewhere around 600 queries/minute).
But since yesterday the server kepps on spawing processes which are
reported to belong to "Unauthenticated user" and in state "Login". This
cont
This is more like what we want to see and pointing us to which line causes
the error would help even more. But from this, you're mixing up your INSERT
and UPDATE statements for starters. What you have would be correct if you
replaced INSERT INTO with UPDATE. For INSERT, it is a comma delimited l
The php code looks ok. What do you have in line xxx in example.php?
Usually, this is the key to the error. I never saw such an error
message, so I would like to see what php is supposed to do in
that line.
For spam filter usage: table
--
Herzlich
Werner Stuerenburg
_
Yes, looks like you're right, which means that the Introduction and Overview
chapters of Replication need to be reviewed as it gives the impression that
it can't be done.
- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Rolf Hopkins'" <[EMAIL PROTECTED]>; "Simon Green"
On 09-Jul-01 Mario Witte wrote:
> Hello,
>
> we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very
> high number of insert-queries (somewhere around 600 queries/minute).
>
> But since yesterday the server kepps on spawing processes which are
> reported to belong to "Unauth
How do I build an SQL query which returns rows based on whether or
not strings in a column contain more than one word
eg.
SELECT name
FROM contacts
WHERE WORD COUNT(name)>1
I am aware that such a query is bogus but it seems as if there must
be a straightforward way of doing this.
thanks
Tom
Anoop K Gupta wrote:
> Hi,
>
> I am first time user of MySQL.
> My ISP has just been installed mysql...
>
> I have connected to server through telnet and
> access MySQL by following command.. and connected
> successfully.
>
> mysql -h myhostname -u root -p
> password :-
> mysq>
>
If you ar
Hi everybody
I am still having problem.. please help.
My ISP just had installed MySQL on remote Linux server.
I am able to connect to my remote mysql server
but fail to create, user any database ...
I let you know step by step.. what I have done
1. First I have connected to my remote server t
Where do I find a complete documentation of all options and entries in my.cnf
and the mysqld start options? I searched the mysql.com site, but to no avail.
Neither does the online documentation doesn't seem to have a chapter on it.
s.m.
Qualimedic AG
Sascha Mant
It's not real easy to find but it is in the manual at www.mysql.com.
It would be nice to have a chapter in the manual dedicated to the cnf file
both server and user. detailing each property that can be set there and what
it means.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.
The path to the socket must be radable and searchable by the world.
The socket itself must be world writable.
Roberto Carlos Sánchez Barroso wrote:
> I´ve already installed mysql, but i can only connect via TCP/IP, and
> i can´t do it by socket. I´ve got all the permissions rigth and the
>
How about:
select position(' ' IN name) as fs from contacts having fs>0;
On Mon, 9 Jul 2001, Tommy Beavitt wrote:
> How do I build an SQL query which returns rows based on whether or
> not strings in a column contain more than one word
>
> eg.
>
> SELECT name
> FROM contacts
> WHERE WORD CO
Cordialement,
We have made up our mind to turn our Access 2000 database into a MySGL one.
Could you please explain us the path to follow and give us information about
it ?
Dominique Vellin
Business developement
Azentis Technology
Your Outsourcing Provider
Tel : 33
You are going to have to write something to translate. I recently did a DBF
to MySQL migration. I wrote programs in Visual FoxPro to create .SQL files.
These files created the needed structure in MySQL and then did a butt-load
of insert's to populate the tables.
YMMV but it worked for me.
Cal
Hi, Renaming of the database is on the TODO list. Some comments
follow.
1) Renaming of the directory will work for table types of MyISAM and
BDB (with exceptions). This won't work for InnoDB types.
2) When renaming a directory make sure to shutdown the server and that
you have no pending tran
Hello,
I'm getting the error message above whenever I try to connect from a remote
host to a MySQL server. I issue the following command:
mysql --host=host_name -u user_name -ppass_word
and get the ERROR 2013 back as a response.
We have two servers, both running MySQL. I get the same message
on 7/9/01 8:07 AM, Anoop K Gupta at [EMAIL PROTECTED] wrote:
> 2. mysql -h mydomainname -u root -p
>
> it prompts for password : it is blank so I just pressed enter. and Mysql
> prompt appeared..
if there is no password, you don't need the -p switch
-- mike cullerton
--
Ton Geurts wrote:
> Hi,
>
> I wonder I someone can give me some advice about the following situation. I
> have to install MySQL to be used with a website on a virtual server. This
> gives the following restraints:
>
> * MySQL must be installed in my user directory
> /usr/local/WWW/www.mydomain.
It's so easy, you won't think of it: start mysqld with parameter
-h (=help):
mysqld -h
shows all parameters and current settings
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 4
Try looking for phpMyAdmin:
phpMyAdmin is intended to handle the
adminstration of MySQL over the web. Currently it can:
create and drop databases
create, copy, drop and alter tables
Bonjour Matthieu,
I would also suggest installing MyODBC (from the downloads page).
The you can just use SQL to create and populate new tables by setting
up an database through ODBC.
En autre si tu as l'intérêt il y a une liste de MySQL francophone à :
S'abonner: [EMAIL PROTECTED]
Amicalem
You find a list of converters on page
http://www.mysql.com/downloads/contrib.html#SEC596
for example
dbf2mysql-1.14.tar.gz Convert between `.dbf' files and MySQL
tables
exportsql.txt A script that is similar to access_to_mysql.txt,
except that this one is fully configurable, has better type
con
Hello ,
I meet in share ver. of MySQL different lang. driver but no where
UKRAINIAN.
AND now I ask - I wont translete "errmsg.txt" and "errmsg.sys" for
UKRAINIAN lang?
Waiting for ansver!
--
Best regards,
suh mailto:[EMAIL PROTECTED]
-
Hello,
I have a Question,
1. In which directory i can find the config file to config the log file
2. Where can i find the log file for mysql?
regards,
\\|//
(@ @)
---oOO---(_)---OOo
)(
( Krishna Ma
Hi!
My problem is when I use group by concat(col1,col2) when col1 and col2
is primary keys and col1 is varchar(255):
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2);
-> return only one row - it is bad
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col1,col2);
-> return 48 rows - it
Don't use the RPM in the 7.0 CD.
Roberto Carlos Sánchez Barroso wrote:
> If somebody could help to, this is the message that is shown in the
> /va//lib/mysql/[domain server name].err
>
> 010704 11:07:58 mysqld started
> 010704 11:07:58 /usr/libexec/mysqld: Table 'mysq
Hi,
I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
following but it doesn't work:
CREATE TABLE WI_POSITION (
PICTUREFILE VARCHAR(200) NOT NULL,
PICFILEXT VARCHAR(5),
POSITIONNOVARCHAR(10) NOT NULL,
SEQUENCENOVARCHAR(3),
LEFT
Thats a REALLY old version.
Jon Brookes wrote:
> Hi,
>
> I have been using mysql fine on a win32 box.. but have now also installed it on
>Linux box. The version details are below:
>
> Red Hat Linux release 6.0 (Hedwig)
> Kernel 2.2.5-15smp
>
> I am using this version of mySQL:
>
> mysqlad
Bradley Jenkins wrote:
> i get this error when starting MySQL
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
>
> /var/lib/mysql/mysql.sock exists with srwxrwxrwx and user mysql.
I /var/lib/mysql at least mode 755?
>
> Brad.
>
>
> _
For Unix /etc/my.cnf
you then in the my.cnf say were you would like the logs!
Simon
-Original Message-
From: Krishna M [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 16:27
To: [EMAIL PROTECTED]
Subject: Log files
Hello,
I have a Question,
1. In which directory i can fi
> 1. In which directory i can find the config file to config the log file
> 2. Where can i find the log file for mysql?
The log file will be in the data directory. In my case:
/usr/local/mysql/var
It has ending .err
You can place my.cnf in this dir also and some other places.
C
i read somewhere that in version 4. or whatever one of the next versions
will be, that they are talking about doing the ability for bi-directional
replication. i have been trying to do the same thing
- Original Message -
From: Rolf Hopkins <[EMAIL PROTECTED]>
To: Simon Green <[EMAIL PRO
I had a similar problem recently. Try checking the /etc/hosts file to see if
the hosts/IPs are matching the current config.
Regards,
Milos Rackov
-Original Message-
From: Kurt Hansen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:58 PM
To: [EMAIL PROTECTED]
Subject: ERROR 2013
I experience heavy trouble with a few tables and look for the
cause for some time without finding out anything. I'm not ready
to construct a bug report, though.
Now I migrated these 3 tables from ISAM to MYISAM, so that I can
CHECK TABLE from within the program and do a REPAIR TABLE when
necessar
> I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
>following but it doesn't work:
See http://www.mysql.com/doc/R/e/Reserved_words.html
Hint: use another laguage. In German, it is links and rechts for
left and richt.
--
Herzlich
Werner Stuerenburg
My Cobalt Raq4r was
recently rebooted by my co-lo ISP without contacting me
first.
Since mysql is not in the shutdown/startup
scripts on the server, it was crashed by the process.
Now when I start mysql normally, it does not
recognize any logins, even root and denies access unless
I start i
Ihre Nachricht vom Monday 09 July 2001 17:10:
> It's so easy, you won't think of it: start mysqld with parameter
> -h (=help):
>
> mysqld -h
>
> shows all parameters and current settings
Alas, it does not. It shows a couple of variable settings, but not the syntax
for tha various logging options
Hi Milos,
Thanks for responding!
I had updated the /etc/hosts files already, but went and checked it after
getting your message. Still no luck.
Any other troubleshooting clues?
Thanks!
Kurt Hansen
[EMAIL PROTECTED]
- Original Message -
From: Milos Rackov <[EMAIL PROTECTED]>
To: Kurt H
JJ> I need to create a table that have field names 'LEFT' and
JJ> 'RIGHT'. I have tried the following but it doesn't work:
JJ> [..skip..]
JJ> But nothing works. How should I do?
Rename 'left' and 'right' to something else. They are reserved words.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Hello
On Tue, 19 Jun 2001, Sasha Pachev wrote:
> If you have a spare development system, plug in 4.0 binary and try
> to run your applications on it to see if it will crash.
I just tried it on Debian GNU/Linux for i386 with up-to-date "testing"
distro and up-to-date "bk clone". The compile pr
Hi everyone,
Replication has been working OK for me for the last month or
with mysql 3.23.38, however following a crash I am having a lot of problems.
This is happening constantly: replication will work for a while
and then stop with the following:
mysql> show slave status;
| Master_Host
Hi
Is it possible to import a complete database from a server to another
one?
Thanks
Eugénio
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
Easy as can be: for example
mysqld -O max_allowed_packet=2M
> Alas, it does not. It shows a couple of variable settings, but not the syntax
> for tha various logging options and the like. So the question for a complete
> options syntax of my.cnf remains open.
--
Herzlich
Werner Stuerenburg
For example if I want a copy of products named products1?
Sincerely Victor
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
I have two fields, sex, and age, which are both ENUM types. I'm building
some statistical reports, using stuff like:
DISTINCT(sex) ... GROUP BY sex ...
and
DISTINCT(age) ... GROUP BY age ...
Now I want a report that shows me a breakdown by both categories, sex and
age...so I can see not just how
Hi
Please visit the following link for the work around solution, else you can wait
till the next release version of the MyODBC.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:mss:10849:200106:lglmnlcggpoehpijkfol
Hope this helps you.
Best Regards
Venu Anuganti
Mateusz Rudyk wrote:
> Hi.
> I have
I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have
access to the databases. I think i have lost access as root. Is there a
way to restore the root user password and/or change it to something else
manually? I have many websites with many 'access denied' errors.
Any help woul
For example if I want a copy of products named products1?
Sincerely Victor
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
mysqldump databasename | gzip > databasename.sql.gz
transfer that file to the other server
mysqladmin create databasename
zcat databasename.sql.gz | mysql databasename
> Hi
>
> Is it possible to import a complete database from a server to another
> one?
>
> Thanks
>
> Eugénio
--
At 10:33 AM 7/9/01 +0200, Dominique Vellin wrote:
>We have made up our mind to turn our Access 2000 database into a MySGL one.
>Could you please explain us the path to follow and give us information about
>it ?
>
>Dominique Vellin
>Business developement
I don't know how much this will help, but I
If both are using mySql, just use mysqldump to dump to a file and then
import it from the file.
It might be fun, just for grins and giggles to:
mysqldump mysql newDatabaseName
and see if that works.
Obligatory warning: if you do this and it trashes your server and wrecks
your car, I was just ki
mysqldump products >products.sql
grep s/products/products1/ < products.sql > products1.sql
mysql < products1.sql
Assuming that nothing else in the database is named products. (i.e. you
don't have any fields or tables named products) If you did have fields or
tables, you would most likely have to
We saw a problem simlar to this caused by a browser add-on.
I believe flyswat was behind it, but it was that quickclick
browser add on that one of the tv networks is pushing.
Mike
On Wed, 4 Jul 2001 11:27:24 -0500
"Rob Donat" <[EMAIL PROTECTED]> wrote:
> Thanks for the note, I will determine i
Is there a way to update random records?
I have a database of 5.6 million records and I want to pull out 5000
records and mark a field in the database that I've pulled these so that I
don't pull the same 5000 again.
I know I can select the records by doing:
SELECT * FROM 5600k WHERE picked IS N
copy a table:
mysqldump database table_name > table.sql
or to copy the whole db:
mysqldump database > db.sql
- Original Message -
From: "Victor Spång Arthursson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 12:51 PM
Subject: Easiest way to create a duplicate o
sorry im a mysql newbie...how do you bind mysql to two particular ip
addresses? i have it bound to my loopback but would like to bind it a
private ip but it doesn't seem to like the bind-address directive more than
once.
-
Befo
I recently downloaded the latest MYSQL version 2.23.39a (from page
http://www.mysql.com/downloads/mysql-3.23.39a.zip), and installed it as
directed by the instructions:
* install directory: c:/mysql,
* datadir: c:/mysql/data,
* and created the config file: c:/my.cnf (see below
Cal Evans wrote:
> If both are using mySql, just use mysqldump to dump to a file and then
> import it from the file.
>
> It might be fun, just for grins and giggles to:
> mysqldump mysql newDatabaseName
That should be:
mysqladmin create newDatabaseName
mysqldump --opt databasename | mysql ne
I knew I would mess that up. yes, you are right, that's a much more elegant
solution.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "Eugénio Veiga" <[EMAIL PROT
On 09-Jul-01 Daren Cotter wrote:
> I have two fields, sex, and age, which are both ENUM types. I'm building
> some statistical reports, using stuff like:
>
> DISTINCT(sex) ... GROUP BY sex ...
> and
> DISTINCT(age) ... GROUP BY age ...
>
> Now I want a report that shows me a breakdown by both c
At 6:41 PM +0200 7/9/01, Sascha Mantscheff wrote:
>Alas, it does not. It shows a couple of variable settings, but not the syntax
Something that may be of help are the sample .cnf files that are included in:
/usr/local/share/mysql/
(on my system at least)
Look for my-small.cnf, my-big.cnf, my-h
Title: Blank
I have found a large number of files which
have names like this
www-bin.040 www-bin.041
www-bin.042 www-bin.043
www-bin.044
which are using up huge amounts of disk
space on my server.
It looks to me like they are logs all of the
queries that are run with
At 5:10 PM +0200 7/9/01, Werner Stuerenburg wrote:
>It's so easy, you won't think of it: start mysqld with parameter
>-h (=help):
>
>mysqld -h
>
>shows all parameters and current settings
Isn't that:
mysqladmin variables
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services |||
I don't think this will work as you expect. You will have to mark
those that you picked from those you haven't picked (and marked)
before.
> SELECT * FROM 5600k WHERE picked IS NULL ORDER BY rand() LIMIT 5000;
> But what I really want to do is:
> UPDATE 5600k SET picked=1 WHERE picked IS NULL O
Hi,
I wanted to take a union of two SQL queries for one of the front end
screen. I searched help documents for "UNION" and did not find much. Do
MySQL support "UNION" SQL statement?
Thanks,
Nutan Pandit
Attronica Computers, Inc.
301-212-1355 (Ext 254)
--
We do a few large daily and monthly downloads from an Oracle database
server. Is there a way to exclude these specific queries from the
update/binary log??
-
Before posting, please check:
http://www.mysql.com/manual.php (
On Monday 09 July 2001 10:51, Tibor Simko wrote:
> Hello
>
> On Tue, 19 Jun 2001, Sasha Pachev wrote:
>
> > If you have a spare development system, plug in 4.0 binary and try
> > to run your applications on it to see if it will crash.
>
> I just tried it on Debian GNU/Linux for i386 with up-to
On 08-Jul-01 Jeremy Zawodny wrote:
> mytop - a `top' clone for MySQL
>
> http://public.yahoo.com/~jzawodn/mytop/
>
Thanks Jeremy, been using 0.5 (FreeBSD ports).
I've got a couple of spare hours coming up, mind if i take
a whack at getting [mytop] into the my.cnf(s) files ?
Regards,
--
Don
On Mon, Jul 09, 2001 at 04:03:00PM -0500, Don Read wrote:
>
> On 08-Jul-01 Jeremy Zawodny wrote:
> > mytop - a `top' clone for MySQL
> >
> > http://public.yahoo.com/~jzawodn/mytop/
> >
>
> Thanks Jeremy, been using 0.5 (FreeBSD ports).
Oh, yeah. I forgot that someone made a port for it. Coo
1 - 100 of 143 matches
Mail list logo
