Dear Stefan,
Stefan Hinz, iConnect (Berlin) wrote:
Dear Lenz,
Removed variable `safe_show_database' as it was not used anymore.
What will ISPs say about this one? They use 'safe_show_database' for their
MySQL setups, so their customers on virtual MySQL hosts cannot see other
customers'
Marek,
please address these general questions to [EMAIL PROTECTED]
- Original Message -
From: Marek Lewczuk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 29, 2002 10:04 AM
Subject: Problems with InnoDB
Hello!!
I have read some post about this problem, but there
* Urmas Buhvestov
I have MySQL database with data like
name points
a20
b20
c19
d18
e18
use test;
create table MyTable (name char(1), points int);
insert into MyTable values ('a',20),('b',20),('c',19),('d',18),('e',18);
is it possible to get with mysql commands ONLY
Ha-nyung,
- Original Message -
From: Chung Ha-nyung [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, November 29, 2002 8:25 AM
Subject: Can a big transaction cause the error in max_allowed_packet?
My table structure is very simple and does not use big column like
Thanks for your rapid reply. :)
I'm using MySQL 4.0.5a binary from MySQL AB.
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz http://www.neowiz.com
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 29,
Hello.
Can somebody tell me how can i enable ssl support in mysql?
Thanks
Giannis Vrentzos
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 29 November 2002 12:23, Giannis Vrentzos wrote:
Can somebody tell me how can i enable ssl support in mysql?
By recompiling with OpenSSL support:
http://www.mysql.com/doc/en/Secure_requirements.html
We plan to offer binaries with SSL
In my network there are 1 master and 3 slaves all with 3.52 on WIN NT. All
slaves are linked correctly to the same bin-log file PISSARRO-BIN.047.
With the command SHOW MASTER LOGS I see 3 files
PISSARRO-BIN.045
PISSARRO-BIN.046
PISSARRO-BIN.047
If I use the command
purge logs file to
Antoine,
Thursday, November 28, 2002, 4:17:48 PM, you wrote:
A Sorry to insist, but nobody has any clues about this ?
A I can supply further info if needed.
A Is the FLUSH TABLES WITH READ LOCK functionality well tested ?
A Having corrupted backups is annoying, and I can't really
A take the
Cem,
Friday, November 29, 2002, 9:31:21 AM, you wrote:
CY I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru
CY win2000 with using any Front End applications
CY (SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am
CY getting the same error message: Error
John,
Thursday, November 28, 2002, 7:02:58 PM, you wrote:
JC Thanks very much.
JC Following on your suggestions, I then went ahead and put the text file
JC into my directory:
JC /usr/local/mysql
JC so that the file was then /usr/local/mysql/absence.txt
JC
Stefan Hinz, iConnect \(Berlin\) writes:
Dear Lenz,
Removed variable `safe_show_database' as it was not used anymore.
What will ISPs say about this one? They use 'safe_show_database' for their
MySQL setups, so their customers on virtual MySQL hosts cannot see other
customers' databases.
Lenz Grimmer wrote:
On Friday 29 November 2002 12:23, Giannis Vrentzos wrote:
Can somebody tell me how can i enable ssl support in mysql?
By recompiling with OpenSSL support:
http://www.mysql.com/doc/en/Secure_requirements.html
Thanks for your answer.
I can only find binary packages.
On Fri, 2002-11-29 at 13:23, Giannis Vrentzos wrote:
Hello.
Can somebody tell me how can i enable ssl support in mysql?
All is in manual. And manual is included with MySQL distribution and
http://www.mysql.com. Always.
In case of security-specific questions not covered in manual, come back
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 29 November 2002 12:45, Giannis Vrentzos wrote:
I can only find binary packages.
Any link for the source code?
Look deeper down on the download pages - the sources are at the bottom of the
page.
Bye,
LenZ
- --
For technical
Hi,
Old story.You have many options.Perhaps the most convenient solutions
are to start MySQL daemon with --skip-name-resolve(documentation - 4.1
Configuring MySQL) or you can add the client IP address and alias in the
/etc/host.
Other options are:
-download MySQL 3.23.53a binary distribution .
Lenz Grimmer wrote:
On Friday 29 November 2002 12:45, Giannis Vrentzos wrote:
I can only find binary packages.
Any link for the source code?
Look deeper down on the download pages - the sources are at the bottom of the
page.
Bye,
LenZ
- --
I was looking for mysql 4.0.x source that 's
Hallo,
I want to sort my array (example: array[Ortslage, Strasse, Weg]) comming
from a query. Following script shows Warning: sort() expects parameter 1 to
be array, resource given in .../formular.php on line 36
var_dump($query) shows: resource(6) of type (mysql result)
How should I do this?
Hello Victoria,
You need to do it with 2 sessions.
According MySQL manual:
If you are using a Veritas filesystem, you can do:
1. From a client (or Perl), execute: FLUSH TABLES WITH READ LOCK.
2. From another shell, execute: mount vxfs snapshot.
3. From the first client,
Hi, I'm beginner in maillist and my english is limited..
I want know about LEGAL MySQL software information.
On www.mysql.com page, in download section I read that:
You need to purchase commercial non-GPL MySQL licenses:
If you distribute MySQL Software with your non open source software,
If
* Wolfgang Gliese
I want to sort my array (example: array[Ortslage, Strasse, Weg]) comming
from a query.
A mysql query returns a 'resultset', not an 'array'. In PHP you can
transform the resultset to an array, and this array can be sorted using a
PHP function. However, this is a mysql list, and
Dear Lenz,
`Show_db_priv` enum('N','Y') NOT NULL default 'N'
i.e. User must be granted explicitly this privilege in order to be
able to use:
SHOW DATABASES;
Suggested way for setting this Ptivilege is ofcourse command:
GRANT SHOW DATABASES;
Sound it bit strange in a GRANT select, show
Dear Alice,
but what i meant is my customer want to have the access on their
database.
and i don't want them to view those databases that not belongs to the
particular customer. customer only access their own database only.
In MySQL 4.0.5a:
Start the server with --safe-show-databases
In
Cant figure out why MySQL wont use index on a big table.
Ok, the data is not evenly distributed which might be the problem.
Look here:
I have a table with 1 million records, with the following fields:
IdUser, int
X, int
Y, int
Z, int
C, char(10)
no, varchars, text, or blobs.
IdUser is a user
Greetings:
I've seen posts in a variety of forums where it states a lot of hosting
companies do not offer support for Innodb SQL type tables.
Is there a reason for this issue? What are the reason(s)?
Thank you!
-
Before
Greetings:
I've seen posts in a variety of forums where it states a lot of hosting
companies do not offer support for Innodb SQL type tables.
Is there a reason for this issue? What are the reason(s)?
Thank you!
-
Before
Claus Reestrup wrote:
Cant figure out why MySQL wont use index on a big table.
Ok, the data is not evenly distributed which might be the problem.
Look here:
I have a table with 1 million records, with the following fields:
IdUser, int
X, int
Y, int
Z, int
C, char(10)
no, varchars,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello Giannis,
Friday, November 29, 2002, 12:36:45 PM, you wrote:
Lenz Grimmer wrote:
On Friday 29 November 2002 12:45, Giannis Vrentzos wrote:
I can only find binary packages.
Any link for the source code?
Look deeper down on the download
* Claus Reestrup
Cant figure out why MySQL wont use index on a big table.
Ok, the data is not evenly distributed which might be the problem.
Look here:
I have a table with 1 million records, with the following fields:
IdUser, int
X, int
Y, int
Z, int
C, char(10)
no, varchars, text, or
Just added more indexes and found a good one.
thanx for the advise ! =)
/C
- Original Message -
From: Claus Reestrup [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 29, 2002 2:28 PM
Subject: Wont use Index when data is not evenly distributed
Cant figure out why MySQL
On Fri, Nov 29, 2002 at 08:59:22AM -0500, Peter M. Perchansky wrote:
I've seen posts in a variety of forums where it states a lot of hosting
companies do not offer support for Innodb SQL type tables.
AFAIK, there is no easy way to do space management on a per-customer
basis with InnoDB
Greetings Michael:
Thank you for your prompt response.
When you state, With InnoDB tables, all the data is stored in monolithic
files does that mean every database, every database table, etc. all reside
within the same file systems?
Thank you.
At 10:17 AM 11/29/2002 -0500, you wrote:
On Fri,
On Fri, Nov 29, 2002 at 10:32:10AM -0500, Peter M. Perchansky wrote:
When you state, With InnoDB tables, all the data is stored in monolithic
files does that mean every database, every database table, etc. all reside
within the same file systems?
Same files, not file systems.
(See MySQL
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in the
reply, your reply will go
Ryan,
Thursday, November 28, 2002, 9:56:00 PM, you wrote:
RM Please pardon my extreme case of the NEWBs on this but I need some help please.
RM Ok I just purchased a book to hopefully clear things up for me, but to no
RM avail. So this is my dilemma: I want to know about MySQL administration,
RM
Giannis,
Friday, November 29, 2002, 2:36:45 PM, you wrote:
GV I was looking for mysql 4.0.x source that 's why i didn 't see any.I
GV found mysql 3.23.53 source.
Check it here:
http://www.mysql.com/downloads/mysql-standard-4.0.html
--
For technical support contracts, goto
Hi.
Why merge table have been done with table that have column char type
not varchar type.
Have anyone succesfully with varchar type merge table and how to do
that.
And how to use union query if merge table not work with varchar or
what SQL to use for convert varchar back to char
Kittiphum
Hi Martin,
Thank you very much. My system is Linux based so your answers are exactly
what I need. One more question though: when you use the --record_log_pos
option in mysqlhotcopy, where is that position recorded? In the logging
output of the program or somewhere else?
Thanks again,
Manuel
I found the problem ! The command is case sensitive also on WINDOWS . I
wrote the command as upcase and all is ok.
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 29, 2002 12:33 PM
Subject: PURGE MASTER LOGS
In my network
On Friday 29 November 2002 00:32, Stefan Hinz, iConnect \(Berlin\) wrote:
Dear Lenz,
Removed variable `safe_show_database' as it was not used anymore.
What will ISPs say about this one? They use 'safe_show_database' for their
MySQL setups, so their customers on virtual MySQL hosts cannot
Hello mysql,
Backpacker lost, heading back down to the foothills of mySQL.
How do I get mysql prompt?
When I try to get the mySQL prompt:
C:\mySQL\bin\mysql -u root -p
Enter Password:
ERROR 2013 Lost connection to mySQL server during query
The above use to work, and I have not
Hi
The pest from Sarnia.
I think I solved the first problem, made them as a csv file, but my DOS
program will only write 64 characters per line (doesn't csv have to be
on one line)??
I have a few records with over 3,000 characters.
Still haven't figure out how to use MySQL.
Would it be better if
Hi,
I need help with a complex query that I can't figure it out myself.
Suppose that I have the following tables
1) stations
-id
-name
2) invitations
-id
-station_id
-invitation_status (confirmed, cancelled, postponed)
I need a query that generate a
On Fri, 2002-11-29 at 14:59, Darney Lampert wrote:
Hi, I'm beginner in maillist and my english is limited..
I want know about LEGAL MySQL software information.
On www.mysql.com page, in download section I read that:
You need to purchase commercial non-GPL MySQL licenses:
If you
If your software utilize the software under GPL license, you can
simply add those GPL licenses as well as make a note that you
are only selling, i.e. the price is only for your own software, your
own software, you should be fine.
Just to pretect your own benefit, you can add a statment saying
It seems strange to me that the tools in the MySQL distribution that
let you run automatic performance tests rely on DBI and perl.
If I want to test the performance of MySQL, why is it a good idea to do
this while relying on another technology, one that is distributed by
someone else, one
Is it possible for mySQL to recognize and compare dates written in this
format: MM/DD/YY?
I know standard date format for mySQL is YYY-MM-DD, but I need to be able to
support this other format if possible. For example, I have a string of
01/30/02 and I just need to compare it to another value
Look at the DATE_FORMAT function.
http://www.mysql.com/doc/en/Date_and_time_functions.html
-Original Message-
From: hotel [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 29, 2002 6:07 PM
To: mySQL
Subject: Date()
Is it possible for mySQL to recognize and compare dates written in this
I'm running mysql 3.23.53 on Red hat linux 7.1.
When i do mysqladmin version, it does not list a port and
when I do mysqladmin -h 'hostname' version, it says that
Host 'hostname' is not allowed to connect to this MySQL server.
Any help would be appreciated
David
---
[This E-mail scanned for
try this:
select a.name, b.invitation_status, count(*) from stations a, invitations b
where a.id = b.station_id group by a.name, b.invitation_status
- Original Message -
From: Ahmed Farouk [EMAIL PROTECTED]
Date: Fri, 29 Nov 2002 22:50:34 +0200
To: [EMAIL PROTECTED]
Subject: Complex Query
Does anyone please know the default MySQL buffer cache size?
I didn't set it while doing a source install and I'm wondering what it is?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello.
I have a following table.
mysql SELECT * FROM group_test ;
+--+--+--+
| a| b| c|
+--+--+--+
|1 |1 |1 |
|1 |1 |1 |
|1 |1 |1 |
|2 |2 |2 |
|2 |2 |2 |
|3 |3 |3 |
+--+--+--+
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pae Choi wrote:
If your software utilize the software under GPL license, you can
simply add those GPL licenses as well as make a note that you
are only selling, i.e. the price is only for your own software, your
own software, you should be fine.
You mean bdb_cache_size, binlog_cache_size, max_binlog_cache_size,
thread_cache_size, or thread_cache_size?
PB
-
- Original Message -
From: Geetika Tewari [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 29, 2002 8:11 PM
Subject: Default MySQL Buffer Cache size
I have mysql running using its standard myisam database.
The server is version 3.23.39-max, client 3.23.36
Operating system Windows 2000 5.00.2195 Service pack 2
I am using the following my.ini
#This File was made using the WinMySQLadmin 1.1 Tool
#11/21/2002 9:16:12 PM
#Uncomment or Add only
55 matches
Mail list logo
