I downloaded this build and was doing a fresh install on a windows system
and when I went to look for the my-large.cnf and etc none of them exist. I
even downloaded the non exe distro and could not locate them. Is this an
omission from this release or should I be finding them elsewhere?
--
MySQL
So I have a question for those who understand developer speak and MySQL
builds and so on...
Apple announced their new OS earlier this week, including this information
on the improvements to 64 Bit version using the G5 processor:
http://www.apple.com/macosx/tiger/64bit.html
One of our biggest pro
you can get that on the mysql-client package
On Wed, 30 Jun 2004 00:35:13 -0500, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a
> dependency libmysqlclient.so.10. My mysql server version is 4.0.20.
>
> Can an
Hi,
I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a
dependency libmysqlclient.so.10. My mysql server version is 4.0.20.
Can anyone tell me where I can get libmysqlclient.so.10.
Thanks,
-Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
I apologise for not lurking for longer before posting, but this is
becoming increasingly important. This is a FreeBSD system, but it's
standard MySQL (mysql Ver 12.22 Distrib 4.0.20, for portbld-freebsd5.0
(i386)). This morning, a user of my network told me that "the Internet is
down." Quick in
I'm sorry for my overly terse reply.
Perhaps I'm being dense, but I just don't get it. Your REGEXP matches a
string which starts with 1 or 2 letters, followed by 1 or 2 digits, followed
by 0 or 1 letters, which tells me a short postcode would be 'OX14' or
'OX14A', but your example short postcod
Mac OS X is well supported by MySQL. MySQL is even preinstalled in Mac
OS X Server, although we choose to ignore the OS X Server installation
in favor of installing the binary so that development and servers all
have the MySQL files in the same paths. Developers in our company run
MySQL on our
iH
any machine running OS X can run MySQL,
this link http://dev.mysql.com/downloads/mysql/4.0.html has a Mac OS X
version with a package installer
- hcir
On Jun 29, 2004, at 5:14 PM, Jim Carwardine wrote:
I’m new to the list and new to mySQL. I’m a Mac user and would like
to set
up a DB on my M
At 22:14 -0300 6/29/04, Jim Carwardine wrote:
I'm new to the list and new to mySQL. I'm a Mac user and would like to set
up a DB on my Mac. When I look at the MySQL web site, I can't seem to find
any info on what hardware can be used. Can mySQL be run on a Mac? If so,
what do I need to know abo
Jocelyn Fournier wrote:
Hi,
AFAIK 4.1.3 should be beta.
It is a little frustrating,
at Linux Conf Adelaide 2004 (January), the Mysql guy there said that 4.1
would be in beta, in the next few weeks ...
Its now July and its still in Alpha.
It says on the webpage "MySQL 4.1 -- Alpha release (use thi
I¹m new to the list and new to mySQL. I¹m a Mac user and would like to set
up a DB on my Mac. When I look at the MySQL web site, I can¹t seem to find
any info on what hardware can be used. Can mySQL be run on a Mac? If so,
what do I need to know about how to set it up? Can anyone point me to a
On Tue, Jun 29, 2004 at 08:46:35PM -0400, Alejandro Heyworth wrote:
> Eric,
>
> I'm looking for a way to eliminate the construction, transmission, and
> parsing of the long multi-row INSERT queries that we are issuing from our
> client app. Since we are inserting 200k rows a shot, we're looking
Eric,
I'm looking for a way to eliminate the construction, transmission, and
parsing of the long multi-row INSERT queries that we are issuing from our
client app. Since we are inserting 200k rows a shot, we're looking for
every boost that we can find.
* Connecting: (3) [want to use a connect
http://dev.mysql.com/doc/mysql/en/Insert_speed.html
-Eric
On Tue, 29 Jun 2004 09:43:04 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> I am proposing this as a hypothetical situation and I would like the full
> feedback of the group:
>
> Could Alejandro re-use the sections of the MyS
If it starts swapping you have key_buffer set to high.
-Eric
On Tue, 29 Jun 2004 15:41:20 -0500, Victor Pendleton
<[EMAIL PROTECTED]> wrote:
>
> max_memory is roughly equivalent to ==> key_buffer_size + (read_buffer_size
> + sort_buffer_size) * max_connections
>
>
> -Original Message-
Hi everyone. As a newbie I’d just like to say that I’m
enjoying delving into MySQL and it’s a fresh change from ASP and other MS
stuff I’ve been using. You never know, I might even start running Linux.
But hey – one step at a time eh…
As I am currently learning I am digging into books b
Much has changed with Unicode in MySQL 4.1.3. So you should be sure to
look at the newest bitkeeper source. And be sure to look at
strings/ctype-uca.c. This is the new implementation of the Unicode
Collation Algorithm.
best,
Jeremy March
--
MySQL General Mailing List
For list archives: ht
Well, then I'll just go back to my original problem if you have read
through this thread from the beginning. Because copying files did not
work, I turned to try mysqldump. Mysqldump does not work for me either.
So there really isn't a way to create a dump on 5.0.x that's compatible
with 3.23.x?
I have not tried 5.0.x to 3.23.x but give this a try:
Flush the tables with read lock or flush the tables and shutdown the
database
tar.gz the files
Move the files to the the new server
Untar/unzip the files
Start up both databases
-Original Message-
From: Bing Du
To: ''[EMAIL PROTECTED]
There is a section in the MySQL manual titled `Programs Known to Work with
MyODBC' and section called `Access`.
http://dev.mysql.com/doc/mysql/en/MyODBC_clients.html
Look at this section and let us know if you are still having issues.
-Original Message-
From: Daniel Eliav Sharvit
To: [EMA
Yes, migrate from 5.0.x to 3.23.x. No innodb and dbd tables.
Bing
> Are you migrating from 5.0.x to 3.23.x? Do you have any innodb or dbd
> tables?
>
> -Original Message-
> From: Bing Du
> To: '[EMAIL PROTECTED] '
> Sent: 6/29/04 3:59 PM
> Subject: RE: Didn't find any fields in table, wh
Are you migrating from 5.0.x to 3.23.x? Do you have any innodb or dbd
tables?
-Original Message-
From: Bing Du
To: '[EMAIL PROTECTED] '
Sent: 6/29/04 3:59 PM
Subject: RE: Didn't find any fields in table, why?
Yup, that's it. I just checked out the mysql online documents.
mysqldump
shoul
Hi all,
My setup is windows 2000, Access 2000 and Mysql built from source on Debian.
Some tables can be seen but all new entries are marked "#Deleted". If I
close the table in Access and re-open it, its looks fine.
Others have every field marked "#Deleted" and nothing I do makes those
tables reada
Yup, that's it. I just checked out the mysql online documents. mysqldump
should have an option --compatible=name. I tried --compatible=mysql323
with mysqldump on my version 5.0 server, but got "mysqldump: ERROR:
unknown variable 'compatible=mysql323'". 'mysqldump --help' does not show
--compati
max_memory is roughly equivalent to ==> key_buffer_size + (read_buffer_size
+ sort_buffer_size) * max_connections
-Original Message-
From: João Paulo Vasconcellos
To: Mysql-general Mailing List
Sent: 6/29/04 1:09 PM
Subject: Server tuning
Hello everybody,
I am setting up a server to d
ENGINE syntax is availiable in 4.1.x and later versions.
-Original Message-
From: Bing Du
To: [EMAIL PROTECTED]
Sent: 6/29/04 2:30 PM
Subject: Re: Didn't find any fields in table, why?
Yes, both user and group ownership of the mydb directory and all its sub
directories/files are mysql.
I
Then you need to tell us what operation needs to be performed on t1.postcode
before making the comparison. That is, describe what you want, rather than
what didn't work.
Michael
zzapper wrote:
On Tue, 29 Jun 2004 15:13:10 -0400, wrote:
zzapper:
I could be reading it wrong, but it looks like y
On Tue, 29 Jun 2004 15:13:10 -0400, wrote:
>zzapper:
>
>I could be reading it wrong, but it looks like you're looking for the
>result of your REGEXP in a list. REGEXP returns only a 0 or 1, not the
>expression resulting from performing a REGEXP.
>
>Wes
>
>On Jun 29, 2004, at 9:25 AM, zzapper w
Yes, both user and group ownership of the mydb directory and all its sub
directories/files are mysql.
I also tried on server A 'mysqldump mydb > /tmp/mydb.dump'. Then copy
/tmp/mydb.dump to server B. On server B, I did 'mysql mydb <
/tmp/mydb.dump'. Then I got
ERROR 1064 at line 11: You have a
You might also want to read these articles:
http://www.onlamp.com/lpt/a/4397
and
http://dev.mysql.com/tech-resources/articles/wizard/index.html
In addition, there's a Perl module - DBIx::SQLCrosstab - that may help.
It's available from CPAN at
http://search.cpan.org/~gmax/DBIx-SQLCrosstab-1.17.
Bing Du wrote:
I have two mysql servers as shown below:
MySQL server A: version 3.23.58, database: mydb, table: mytable
MySQL server B: version 5.0.0-alpha-standard-log
I want the server B to have the exact same database and table as those on
the server A. So, on server B, I manually created a da
zzapper:
I could be reading it wrong, but it looks like you're looking for the
result of your REGEXP in a list. REGEXP returns only a 0 or 1, not the
expression resulting from performing a REGEXP.
Wes
On Jun 29, 2004, at 9:25 AM, zzapper wrote:
Hi,
select * from ytbl_development as t1
where (t1
You should just become familiar with your data and the queries that are sent
to the database. You could turn on the slow query log and after a few days
or hours or whatever see what queries are logged.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/0
A quick review of the REGEXP portion of the manual helped me to understand
what went wrong:
http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html
REGEXP is a comparitor, not a function. It works like "=" or ">" and the
result is a boolean value.
Were you trying to validate t1.postco
What you are trying to create is called a "pivot table" or a "cross-tab
report". I recently walked someone else through this same process. Read
through this thread and let me know if it helps you or not. You can also
Google the groups for "MySQL pivot table" and find other examples and
methods.
h
I am proposing this as a hypothetical situation and I would like the full
feedback of the group:
Could Alejandro re-use the sections of the MySQL source code that handle
replication and bin-logging to make his data capture application appear as
a "Master" server and have his MySQL database act as
If you require a SQL-only solution, there may be one (I can imagine a 4- or
5-pass process that might get you the numbers you want). However, I agree
with the other respondents to your message, it will not be as fast, as
efficient, or as easy to write as one written in client-side code. IMHO,
the
I have two mysql servers as shown below:
MySQL server A: version 3.23.58, database: mydb, table: mytable
MySQL server B: version 5.0.0-alpha-standard-log
I want the server B to have the exact same database and table as those on
the server A. So, on server B, I manually created a database called
Hello everybody,
I am setting up a server to do POP/SMTP authentication using
vpopmail. I took a look at the variables at global my.cnf and wondered
what would be the best values for things like key_buffer,
read_buffer_size and table_cache. I searched the manual, but it does
not go deep in this
Is there anything I should set in my startup options to accommodate
this?
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 1:54 PM
To: Chip Bell; Victor Pendleton; '[EMAIL PROTECTED] '
Subject: RE: authentication error
The values in the `St
The values in the `State` and `Command` fields of the queries are what you
should be looking at. For example if you have a select statement that is
running over an acceptable threshold you should look into that. If you have
a query that is taking a `long` time to create a temp table , you should
lo
Hi,
select * from ytbl_development as t1
where (t1.txtDevPostCode REGEXP "^[[:alpha:]]{1,2}[[:digit:]]{1,2}[[:alpha:]]{0,1}" in
#QuotedValueList(qryRadius.shortpostcode)#)
The above Where clause doesn't work , it just seems you can't use REGEXP this way
qryRadius.shortpostcode contains a list o
Hi,
select * from ytbl_development as t1
where (t1.txtDevPostCode REGEXP "^[[:alpha:]]{1,2}[[:digit:]]{1,2}[[:alpha:]]{0,1}" in
#QuotedValueList(qryRadius.shortpostcode)#)
The above Where clause doesn't work , it just seems you can't use REGEXP this way
qryRadius.shortpostcode contains a list o
Ok, we might be on to something. Right now, the server is running fine.
I did a "show processlist" and got back 138 rows. There are times
ranging from 0-14556. Granted, it's an email server so people are
staying logged in...
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTE
Do you have an `execessive` numer of processes running? Do you have any
processes that have been running for an `abnormal` length of time?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 12:12 PM
Subject: RE: authentication error
It's all on the s
It's all on the same box. I'm familiar with the "show processlist" but
I don't know what to look for. See what I mean lol? I know most of the
commands, but not quite what I'm looking for.
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004
What is the connection like between the two servers? Once you are logged in
can you do a show processlist and see if anything is bottelnecking the
database?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 12:05 PM
Subject: RE: authentication error
I ran the FLUSH HOSTS and it said "0 rows affected" The authentication
goes against the mysql table, which is where I'm guessing the errors
would show. When I try to log in during the "slow down" of the server,
it just hangs and hangs and finally will let me through.
-Original Message-
>From the mysql monitor it is `FLUSH HOSTS;` . Does the email server not log
failed connection attempts?
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 11:55 AM
Subject: RE: authentication error
Ok, I tried to run "flush-hosts" from both # and in
Ok, I tried to run "flush-hosts" from both # and inside mysql..nada.
How can I do this exactly? Sorry about my lack of knowledge, I'm still
green. I have my books though and am feverishly trying to find the
answer!
Thanks for your help!!
-Original Message-
From: Victor Pendleton [mailto:
Can you view or log the errors that imap and the web authentication are
getting? Try issuing a flush-hosts to see if the max_connect_errors was
reached.
-Original Message-
From: Chip Bell
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 6/29/04 11:47 AM
Subject: RE: authentication error
No
Show warnings is not available until 4.1.x
...
The empty field will be imported as that. Empty and not a null value.
...
Have you tried importing the data yet to see how the date fields look in
MySQL?
-Original Message-
From: Robert L Cochran
To: [EMAIL PROTECTED]
Sent: 6/28/04 9:20 PM
Sub
Nothing actually. I'm guessing I don't have "enough" logging turned on.
The only thing my servername.err files shows is
Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you
do do not.etc
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: T
Hello List
I've recently compiled and installed the latest stable version of MySQL from
source file mysql-4.0.20.tar.gz on Red Hat Linux Advanced Server 3 (without
installing the version of MySQL contained within the Red Hat OS install),
using the standard configure, make and make install. For sec
Keep in my mind that if something does go `wrong` you could possibly have to
wait hours for all of your transactions to roll back.
-Original Message-
From: Michael Lee
To: '[EMAIL PROTECTED] '
Sent: 6/28/04 9:35 PM
Subject: RE: INNODB transaction log size
Victor,
Thanks for your reply.
Hi , Sorry to ask this question,
but I'm in desperate need to acomplish this report, and don't even know
it is possible to be done.
The thing is I have to turn rows from one table into columns
in other table. The first table looks like this
T1
---
id cod
---
1 bb
Why don't you use the export utility in ms access to load the data into
mysql. The export will create the table in the database. All you need is
a dsn connection and the mysql odbc.
Osvaldo Sommer
-Original Message-
From: Robert L Cochran [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28,
I'm assuming your a first time user of mySQL, so I'm going to give you the
basics, if I have miss read your post and all of the following you have done
I apologise:
There is no icon...
So you have already installed mySQL? You need to install it as a service,
follow this guide:
http://www.kitebird
[EMAIL PROTECTED] wrote:
We are currently running with one big ms sql-server.
Is it possible to do federated servers on mysql?
What I want to do is to purchase one more server and split the work load
on the two servers.
Any ideas?
On a quick note: What about MySQL replication?
http://dev.mysql.com
What does the error log say?
-Original Message-
From: Chip Bell
To: [EMAIL PROTECTED]
Sent: 6/29/04 9:03 AM
Subject: authentication error
Hello, I run a toaster email server which is having trouble
authenticating at times. Both methods of authentication, imap AND web
for some reason ju
On Tue, 29 Jun 2004 [EMAIL PROTECTED] wrote:
>
> Hello!
>
> We are currently running with one big ms sql-server.
>
> Is it possible to do federated servers on mysql?
>
> What I want to do is to purchase one more server and split the work load on
> the two servers.
Yes, you can use master/slave re
Hello
I created the icon but nothing happens. What do I need to do?
Andrew
At 03:20 PM 6/19/2004, Andrew McHorney wrote:
Hello
I installed the software. I would like to start up the server but there is
no icon. What is the name of the executable so I can make an icon? I am
running under Windows.
Shawn,
Very Interesting idea. I definitely want to look into this a bit more.
I fear though that the bin-logs might be written first to disk before they
are copied over to the replicas.
Another member of my team mentioned there might be a way to issue direct
MyISAM table INSERTS. She suggested
Hello, I run a toaster email server which is having trouble
authenticating at times. Both methods of authentication, imap AND web
for some reason just hang. I'm pretty new to MySql but I figure if both
methods are trying to authenticate against the same table, the problem
is there. I activated
Hello!
We are currently running with one big ms sql-server.
Is it possible to do federated servers on mysql?
What I want to do is to purchase one more server and split the work load on
the two servers.
Any ideas?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello,
what are the defaults for the following options?
net_read_timeout
net_write_timeout
Regards
Marten Lehmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bob
My versions are Access 2000 and MySQL 4.0.20. Here's what I do.
When exporting my Access table, I choose the file type Text Files.
Then, on the next dialog box, make sure to click the Advanced button to
get to the formatting information. Change the date order to YMD and the
date delimiter to
Hi,
> Someone please clear things up for me a little!
Here is a try :)
> Seems the data exceeded the max_allowed_packet size which is 1M on master and
> slaves so all slaves stopped replicating.
>
> Question is, why did this happen and how could this have been avoided?
> Should max_allowed_pac
Hello,
SQL Maestro Group is happy to introduce a new release of SQL Maestro -
a powerful Win32 GUI solution for MySQL server administration and
database development. A fully functional trial version of SQL Maestro
is available at http://www.sqlmaestro.com/products/download.html.
SQL Maestro su
Hi,
The only thing that could slow you down is that the genAttrib array will take
more and more memory as the result set grows. I would recommend you to create
a function that uses the mysql row directly instead of creating this huge
array.
something like
while ((row = mysql_num_rows(result))
At first, Thanks a lot!
My platform is MIPS CPU. After I got the MySQL source code, I compiled it in a develop
X86 PC. In the develop PC, I compile MySQL by a Cross-Compiler for MIPS. Its name is
"mipsel-linux-gcc". As you know, before I compile the project, I should execute
"./configure" to ge
hi,
How to complie MySQL in MIPS platform?
I have tried, but no success.
jy
hi,
How to complie MySQL in MIPS platform?
I have tried, but no success.
jy
> 1. The average TIME ELAPSED between consecutive REPEATED instances of the
> rowID (GROUP BY rowID, I assume) between one month ago and now.
The easiest solution (if not the only) would be to handle this client side.
If you sort the records by their timestamp you can easily keep track of the
tim
74 matches
Mail list logo
