Jeremy Cole wrote:
> ===
> Server version: 4.0.0-alpha-log
> Threads: 408 Questions: 183163443 Slow queries: 4009 Opens: 43522
Flush
> tables: 1 Open tables: 239 Queries per second avg: 222.828
> ===
Some free configuration advice:
* You
On Mon, 26 Nov 2001, Marjolein Katsma wrote:
> Paul,
>
> At 16:56 2001-11-25 -0600, Paul DuBois wrote:
> >database,sql,query,table
> >
> >At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote:
> >>At 12:19 2001-11-25 -0600, Paul DuBois wrote:
> select * from users where dbname= "Brain" returns
At 20:24 26/11/2001 -0800, gx-inc wrote:
Hi!
>I'd appreciate "note-by-note" directions. The "my.cnf" file wasn't to be
>found on my system (odd), though I did find the "my.ini" file (in the main
>Windows directory).
In short: you can use either c:\my.cnf or \windir\my.ini file, not both.
For
download a windows 3.23 version and install it. as you finished, under
mysql\docs\ you will find manual in HTML fmt.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi all,
I am a new member of this list. now I have a question. on my site, I add a
new lonely database to store some data, and in this db, there is a table
contained four columns, in which I put more than 17 million records in each
column. after do that, I found out that my site became very slow.
Me , too, have the same problem.
it seems that every opened page establishes a connection but
those connections can't be closed, although i explicitly close in my code
I posted a message related with this problem a few days ago,
unfortunately couldn't get a satisfying answer. So, i request from M
I wonder if there's a date issue here. I am getting the same error with
every one of my disconnect methods also!!
Wow!!
I wonder if there are other folk seeing this...
-David
-Original Message-
From: Jaime Teng [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 5:48 PM
To: [E
Ok, I have read through the manual and archives and still I cannot find
this problem I'm having.
" can't connect to local MySql server through socket '
var/lib/mysql/mysql.sock' (2) "
Help!
Thanks in advance.
-
Before posti
I keep getting that error too. But I couldn't figure out the cause. So I
just used Apache::DBI for persistent DB connection ( you can't do that
unless your scripts are running under mod_perl )
--
sherzodR
On Mon, 26 Nov 2001, Chris Mason wrote:
>I have a lot of databased websites running on
Hi Alec,
Instead of adding 6 to current_time_stamp add 600.
Hope the logic is clear.
Anvar.
At 09:40 PM 26/11/2001 -0500, you wrote:
>I've got a table containing dates as follows (number of rows edited for
>length)
>
>mysql> select * from chat_schedule;
>+-+--+-
I recently acquired a new dual-processor (P3 1GHz) workstation, running
FreeBSD 4.4-RELEASE. By reading the list, I know that MySQL won't take
advantage of both processors unless it is compiled with LinuxThreads
support. According to the FreeBSD ports documentation, however,
LinuxThreads suppo
To be more specific, everytime you use $dbh->prepare(...), after you're
done with'em, do $sth->finish(); That should solve the problem.
Good luck
--
sherzodR
On Mon, 26 Nov 2001, Colin Faber wrote:
>You've failed to close your prepare() statements with finish()
>
>See the perldoc on DBI agai
Lotta peoploe do not use and closing tags. It works fine in
IE, as it closes them automaticly whenever it sees the opening and
. But Netscape turns up its nose. So it should do w/ the HTML syntax,
I believe. You could post a link to that page, if you wish, or have HTML
validator to validate it
I'd appreciate "note-by-note" directions. The "my.cnf" file wasn't to be
found on my system (odd), though I did find the "my.ini" file (in the main
Windows directory).
Some other directions stated that I could edit the my.cnf *or* my.ini
file(s) for essentially the same results, though I wo
At 6:20 PM -0500 11/26/01, NDPTAL85 wrote:
>As to the guy's response, I saw nothing in it that was "defenseive"
>or even argumentative. If you cannot tolerate someone asking you to
>clarify your position then you need to get off a mailing list.
Thanks for the follow up. I was really at a loss a
At 4:48 PM -0600 11/26/01, john wrote:
>that's a croc. You invited me and the world as soon as you posted to the
That's "crock", I believe.
>web. I asked you a question, you reposted to the net my question so we could
>start the war on the crappy Mac OS' issue that's been going on for the last
>
I've got a table containing dates as follows (number of rows edited for length)
mysql> select * from chat_schedule;
+-+--+-+
| schedule_id | model_id | timeslot|
+-+--+-+
| 1 |2 | 2001-11
I've got a table containing dates as follows (number of rows edited for length)
mysql> select * from chat_schedule;
+-+--+-+
| schedule_id | model_id | timeslot|
+-+--+-+
| 1 |2 | 2001-11
I've read with interest the posts on Netscape not rendering HTML
correctly. I can add my experience to that thread, but I use Perl not
PHP to generate the HTML. Some very strange things happen with NS 4.77,
but IE5 renders just fine. It isn't tables in my case - I've confirmed
all table,tr,td, and
You've failed to close your prepare() statements with finish()
See the perldoc on DBI again.
Jaime Teng wrote:
>
> Hi,
>
> I have been pulling my hair due to this annoying error. x(
>
>
> DBI::db=HASH(0x1d2998c)->di
Hi,
I have been pulling my hair due to this annoying error. x(
DBI::db=HASH(0x1d2998c)->disconnect invalidates 1 active statement handle
(either destroy statement handles or call finish on them before
disconnecting)
a
>Description:
Attached is a short manpage bugfix.
>How-To-Repeat:
man -k safe_mysqld
>Fix:
--- safe_mysqld.1.orig Tue Nov 27 02:19:05 2001
+++ safe_mysqld.1 Tue Nov 27 02:19:56 2001
@@ -1,8 +1,7 @@
-.TH SAFE_MYSQLD "1" "19 December 2
On Monday 26 November 2001 03:40 pm, Ady Wicaksono wrote:
> gcc 2.96 has bugs that affect MySQL, what bug ?
> RedHat 7.1 and RedHat 7.2 comes with gcc 2.96
If we knew exactly what bug we would have given Red Hat a test case to fix
it. All we know is that strange things happen under load when MyS
Hi,
I am getting "java.sql.SQLException: Cannot disable AUTO_COMMIT" exception
when using mySQL
with Weblogic EJB (through org.gjt.mm.mysql.Driver JDBC driver).
Can anybody help!!
Thank you, Eric
[EMAIL PROTECTED]
-
Befo
Hi all,
I wanna try the following query,
=
select concat(
"update product set price=",
p2.price,
" where id=",
p1.id,
";"
)
from product p1 left join product p2
on p1.name=p2.name
where p1.
I keep getting this error randomly when trying to connect to the MySQL
server:
Can't create UNIX socket (55)
It happens when trying to connect either through PHP or via the shell (mysql
command). I haven't had this problem before - any thoughts? It only happens
temporarily, and then resumes workin
On Tuesday 27 Nov 2001 04:11, Ady Wicaksono wrote:
> gcc 2.96 has bugs that affect MySQL, what bug ?
A number of bugs, and they don't just affect MySQL - there is a number of
packages that break when compiled using GCC-2.96. Some examples that I
presonally ran into at some point are:
mPlayer
I
There's probably something wrong with your PHP code. It should look something
like...
$result = mysql_query("select count(*) as cnt from table") or die
(mysql_error());
$row = mysql_fetch_array($result);
$count = $row[cnt];
print $count;
Sounds like you're doing something more like:
$result =
I have a lot of databased websites running on my server (1 Ghz P3/256
MB/20GB/RH7.1) and I am continually getting connection problems. None of the
sites are high volume, so I am surprised by this and I suspect that
connections are not being reused quickly enough.
Here's my config, can anyone help
On Mon, 26 Nov 2001, Christian Sage wrote:
> Neil,
>
> I'm not going to argue against your view, because for a discussion on
> Oracle this is clearly the wrong place. However, I would like to correct
> your facts in one respect: while SQL plus has a standard line size of 80
> characters and a st
Ady Wicaksono <[EMAIL PROTECTED]> writes:
> On Tuesday 27 November 2001 02:38 am, you wrote:
> > On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote:
> > > I have an app that uses about 6-7 databases. But the MySQL server is now
> > > restarting a lot. I was having a problem with this be
John,
Mac OS X isn't the same Mac OS that you've been going on "for the last
10 years." Its a radical departure. Mac OS 1 thru 9 were basically the
same technology. They had no protected memory and no pre-emptive
multitasking. Mac OS X is based on NextSTEP. Its a Unix. A real Unix. So
just abo
At 2:53 PM -0800 11/26/01, Michael Collins wrote:
>I get a permission error when trying to backup my database files
>using the BACKUP TABLE function, here is an example use and its
>result:
>
>BACKUP TABLE ai2.topics TO "/Users/mcollins/BACKUPS/BACKUP_1126_1407/ai2/";
>+++---
On a final note, real Oracle users don't use SQLPlus, they use TOAD, Tool for
Oracle Application Developers. :)
On Monday 26 November 2001 01:32 pm, Christian Sage wrote:
> Neil,
>
> I'm not going to argue against your view, because for a discussion on
> Oracle this is clearly the wrong place. H
I get a permission error when trying to backup my database files
using the BACKUP TABLE function, here is an example use and its
result:
BACKUP TABLE ai2.topics TO "/Users/mcollins/BACKUPS/BACKUP_1126_1407/ai2/";
+++--+--+
| Table
that's a croc. You invited me and the world as soon as you posted to the
web. I asked you a question, you reposted to the net my question so we could
start the war on the crappy Mac OS' issue that's been going on for the last
ten years to this newsgroup. You're one of those guys that always overlo
On Tuesday 27 November 2001 02:38 am, you wrote:
> On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote:
> > I have an app that uses about 6-7 databases. But the MySQL server is now
> > restarting a lot. I was having a problem with this before - I had about
> > 267 restarts in a matter of
>I'm using PHP with mySQL and I got very weird results when I ran a
count. I used "SELECT COUNT(*) FROM $TableName", with $TableName being my
table's name, for the Query. >When I printed the result I got "Resource
id #2", what does that even mean. And what did I do wrong?
You tried t
On Monday 26 Nov 2001 20:00, Neil Zanella wrote:
> Now there is one thing that we must be aware of. There are things that
> mysql does not support (yet). These include foreign keys, views,
> subselects, triggers, and procedural SQL, and I can't remember
> if mySQL supports transaction processing e
I'm using PHP with mySQL and I got very weird results when I ran a count. I
used "SELECT COUNT(*) FROM $TableName", with $TableName being my table's
name, for the Query. When I printed the result I got "Resource id #2", what
does that even mean. And what did I do wrong?
--
At 2:35 PM -0600 11/26/01, john wrote:
>Excuse me, but I never intended on adding the world to that question,
And I never invited your private flame.
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http:/
Some defense for the Mac,
I have been learning MySQL from my tiny little G3 PowerBook. And doing
development on it seems to be a logically sound idea, as I'll be
migrating the data to a HP/UX server when the project is ready to go
"public".
I like Mac OS X because I finally have a fully-supp
Hey group,
The answer to my question was yes, thanks Paul.
For the groups knowledge, the scenario was that I was trying to subtract
two datetime values and sum up the differences.
mySQL stores the datetimes in a text like integer format. For example
2001-01-02 is stored as an integer 20010102.
At 2:35 PM -0600 11/26/01, john wrote:
>Excuse me, but I never intended on adding the world to that question, and
>your defensive response tells me you have to fight for trash you are using.
>I have utilized the Mac OS X long enough to run far far far away.
That's a general enough criticism as to
At 4:44 PM -0500 11/26/01, [EMAIL PROTECTED] wrote:
>Hi all,
>
>This question should be, and probably is in, the FAQ -- but either the
>FAQ or my fonts are hosed and I couldn't read the FAQ very well at all.
>Apologies up front if it's in there.
>
>I'm trying to figure out a graceful way to allow
>>I would tend to think that granting access to user@'%' would also allow
connections from localhost
It depends...if you connect from the local machine specifying 'localhost',
or without specifying a hostname, then mysql looks for the localhost
permission. If you connect through the localhost, b
Replacing Data in the Database is not working. Please check and review the
below syntax:
A) Type the following from the Command Prompt-
mysqlimport -r(replace)l(lock variables) (dbname) (fname)
B) To Replace while in a Database-
1)Type the following- load data
check the ownership of the mysql directory and the files within. They should be the
same owner/group as your mysql server.
Yuriy Salimovskyy wrote:
> Dear sirs,
>
> I'm running MySQL server on local machine (AMD Duron 650, 128 RAM, Linux
> RedHat 7.1, MySQL 3.23.36) and have following problem:
>
Hi all,
This question should be, and probably is in, the FAQ -- but either the
FAQ or my fonts are hosed and I couldn't read the FAQ very well at all.
Apologies up front if it's in there.
I'm trying to figure out a graceful way to allow a user account access
to a DB from both 'localhost' as wel
I'd like to understand this better.
Lets say I have a table with 4 fields
itemKey INT(10) unsigned auto_increment primary key
status enum("forsale", "sold")
description TEXT
price DECIMAL(10,2)
And I do a
SELECT * FROM table
WHERE MATCH (description) AGAINST ("A really nice toy")
AND status="f
David Lidström writes:
> Hi!
>
> Is it not possible to move a mysql column to after another existing
> Column by using the CHANGE statement in ALTER TABLE?
>
>ALTER TABLE enum_test CHANGE ostron ostron int(4) NULL DEFAULT '0'
> AFTER newCol_2
Moving oysters around, eh? :-)
As far as I
Dear sirs,
I'm running MySQL server on local machine (AMD Duron 650, 128 RAM, Linux
RedHat 7.1, MySQL 3.23.36) and have following problem:
after running SAFE_MYSQLD daemon starts, but ends almost immediately
log is as follows:
011126 16:44:08 mysqld started
011126 16:44:14 /us
Hi Johnathon,
If you are running on FreeBSD 4.2 or earlier you will have random
problems, espcially 4.1, it had compiler and thread bugs. FreeBSD 4.3
and 4.4 work very nicely and have all known thread problems fixed.
Best of Luck
Ken
- Original Message -
From: "Jonathan Hilgeman" <[EMA
Hi,
Could anyone help me with where I could find more information about how to
use SSL and let Java connect to MySQL using SSL??
Thanks,
Sebastian
(http://bast-i.dyndns.org)
-
Before posting, please check:
http://www.my
Hi!
Is it not possible to move a mysql column to after another existing
Column by using the CHANGE statement in ALTER TABLE?
I have the following columns:
id
ostron
newCol_2
And I'd like to move the "ostron"-column to after the newCol_2 column.
Is this not the syntax?
ALTER TABLE enu
Hi!
On Nov 26, Mike Wexler wrote:
> Sergei Golubchik wrote:
> > Hi!
> >
> > I didn't test it yet.
> >
> > The one thing I can say just now that unlike natural language search
> > code (as exists in MySQL in 3.23) it need not to build the complete list
> > of matched documents in memory in advan
On Mon, 26 Nov 2001, john wrote:
> my mistake, I copied the line and forgot to remove the first lefeber.
Mmm no, what I was referring to was that Ben might be confusing
"installation directory" with "mysql binary location". I think we all mean
the latter in this case. Which would then be '/apache
my mistake, I copied the line and forgot to remove the first lefeber.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 2:36 PM
To: john
Cc: Ben Ocean; [EMAIL PROTECTED]
Subject: RE: HELP! Hosed Database!
On Mon, 26 Nov 2001, john wrot
Excuse me, but I never intended on adding the world to that question, and
your defensive response tells me you have to fight for trash you are using.
I have utilized the Mac OS X long enough to run far far far away.
Until you can get a grip on criticsm, ease off buddy. Your gonna give
yourself an
On Mon, 26 Nov 2001, john wrote:
> use:
> cat lefeber lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber
I have this strange feeling that the line should read
cat lefeber.txt | /apache/mysql/bin/mysql -u -p lefeber
But let's see who of us are right =)
Sincerely,
Jan
--
Mr. Jan-Aa
From: Jonathan Hilgeman <[EMAIL PROTECTED]>
> On a related note, any Perl gurus know how to force a Perl cron job to stay
> below a certain CPU utilization?
Not a Perl thing. Do a man on 'nice'.
---
Rodney Broom
Programmer: Desert.Net
Spam filter: sql database
-
Beno,
I cannot believe I am a beginner and the "pro" developer Mr. Sinisa
Milivojevic <[EMAIL PROTECTED]> could not answer your question. I believe you
are reading/issuing the command incorrectly. The "pro" developer Mr. Sinisa
Milivojevic <[EMAIL PROTECTED]> did not read your email properly.
At 1:49 PM -0600 11/26/01, john wrote:
>this is not meant to be demeaning, but your not seriousely running a server
>with a Mac are you?
And why not? Are you at all familiar with Mac OS X and/or Darwin? It
is Unix BSD. Seems a fine choice for MySQL.
--
Michael
__
||| Michael Collins |||
Hello,
I know this is offtopic, but the new PostgreSQL book from OReilly is in
production. You can read it online at http://www.postgresql.info/ .
No we are not trying to start a flame war, but there is some really good
info on SQL queries in the book. It may be useful to some MySQL folk.
J
-
I am trying to understand how MySQL uses memory when executing a query on a
large table.
The server is running on RedHat 6.0 with pentium III 750 Mhz processor and 2
Gig of RAM.
I have my key_buffer_size set to 1600MB. My table cache is set at 512.
When I run top, I get the following out put:
On Mon, 26 Nov 2001, Ken Kinder wrote:
> Oracle is certainly more full-featured, but if you know very little about
> databases, Oracle is not the right choice.
I agree. First of all the system requirements are high. For instance the
Oracle Universal Installer took something like three hours on
On Monday, November 26, 2001, at 02:38 PM, Ben Ocean wrote:
> But I have a backup, if I just knew how to restore it! The instructions
> read:
> #mysqldump --opt database_name > database_name_File.txt
> To restore database:
> #cat database_name_File.txt | /path/to/mysql -u username -p
> databa
No - it's a FreeBSD binary, I believe. However, I noticed that there were
two perl scripts running that got stuck in infinite loops and were taking up
99% of the CPU. After killing them, it seems to be stable...
On a related note, any Perl gurus know how to force a Perl cron job to stay
below a c
> then I should be able to issue this command:
> cat lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber
> Why does it tell me that /apache/mysql is a directory (duh) and break the
pipe?
It really means to pipe that file to the mysql command line client, not the
mysql directory. Try
hi.
/path/to/mysql means the path to the mysql _executable_...
type 'which mysql' to see for sure, but it might be /apache/mysql/bin/mysql.
good luck.
-ravi.
-Original Message-
From: Ben Ocean [mailto:[EMAIL PROTECTED]]
Sent: November 26, 2001 2:38 PM
To: [EMAIL PROTECTED]
Subject: HEL
Michael Collins writes:
> Now that the shutdown command has been repaired, are there other
> outstanding issues specific to Mac OS X that the MySQL AB team has
> under development for MySQL 3.x?
>
> --
> Michael
> __
> ||| Michael Collins |||
> ||| Kuwago Web Services ||| mailto:[
I have a rhetorical question.
I'm learning as much as I can about MySQL. There is one little detail
that I don't *have* to know the answer to, but I'm curious about. Don't
waste your time replying if you're busy.
It appears that the display width is an option for certain types of
numeric co
On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote:
> I have an app that uses about 6-7 databases. But the MySQL server is now
> restarting a lot. I was having a problem with this before - I had about 267
> restarts in a matter of a month or two. I shut down the server, ran
> myisamchk o
But I have a backup, if I just knew how to restore it! The instructions read:
#mysqldump --opt database_name > database_name_File.txt
To restore database:
#cat database_name_File.txt | /path/to/mysql -u username -p database_name
So, if my installation is at /apache/mysql
and the database is /apac
Now that the shutdown command has been repaired, are there other
outstanding issues specific to Mac OS X that the MySQL AB team has
under development for MySQL 3.x?
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA
help,
I have a problem. I cannot access the mysqladmin fully. I know the only
existing users and the passwd's (without root). I can use mysqladmin while
modifying a table with one of their access'. I know the root to the
(Linux)server, but mysql must have a different one. How can I find out
wh
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Lun 26 Nov 2001 00:42, escribiste:
> Hola a todos.
>
> Bueno,ya sabemos todos o casi todos que MySQL no tiene integridad
> referencial ni transacciones.Para mantener la integridad
> referencial es necesario hacerlo a mano. Por ahora todo correcto.
Dear Sir, Madam
I have a problem whit a tabel on a Mysql datbase V3.23 running on a Cobalt
Raq4I.
Some body whas create a tabel named kortbon . Now we have a SQL error on
line1. I cant drop the tabel from a telnet session or mysqlfront or phpadmin.
Question: can i rename the files in /usr
Greetings!
Introducing JudoScript, a full-fledged scripting
language that supports genuine JDBC scripting. Free
form SQL statements can be specified and executed
either individually or in a group or batch.
Expressions can be embedded in the SQL statements.
SQL statements can be prepared and run w
Well, to do date calculations, use DATE_SUB() and DATE_ADD() functions.
To convert to some other functions, use DATE_FORMAT() function. For
templates that DATE_FORMAT() needs, please refer to documentation.
There're bunch of'em
--
sherzodR
On Mon, 26 Nov 2001, Thomas Spahni wrote:
>On Mon,
Hi Kevin,
> -Original Message-
> From: Kevin Smith [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 9:25 AM
> To: [EMAIL PROTECTED]
> Subject: MyODBC: DSN Creation
>
>
> Hi All,
>
> I need to setup MyODBC DSN's for MySQL access.
>
> Does anyone know how to build a simple insta
This is my second time posting this question to the mailing list. I
received no responses the first time I posted this.
In the MySQL documentation, it states that the binary log will be replacing
the update log, and it should be used in its place as it can do anything
the update log can. I'm n
Where can I find a copy of the latest MySQL 3.23 manual? All I've been able
to find is the newer 4.x.
A. Clausen [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
M. A. Alves writes:
> On Sat, 24 Nov 2001, Sinisa Milivojevic wrote:
> Not quite:
>
> "For a successful connection, the return value is the same as the value
> of the first parameter, unless you pass NULL for that parameter." (Manual)
>
>
> Cheers,
>
> --
>,
> M A R I O data miner, LIA
Displaying timestamp columns are a PIK (pain in keester) if you ask me.
A Select statement will display the TmeStamp as 2005095105. Now I ask
you, how many users will understand this format?
Why not display TimeStamp in the same format as DateTime? At least then the
TimeStamp is in a meanin
On Mon, 26 Nov 2001, Julio Faerman wrote:
> Is there anything like a "to_hours()" function ?
> I need my query to to calculate how much time there is between two time
> values
Julio,
have a look at the UNIX_TIMESTAMP(date) and FROM_UNIXTIME(unix_timestamp)
functions. These allow to conver
Okay, unregard my question. I figured out what I was doing wrong.
It's too embarrassing to tell you guys.
Thanks,
--Walt
-Original Message-
From: Weaver, Walt
Sent: Monday, November 26, 2001 9:52 AM
To: [EMAIL PROTECTED]
Subject: Using Berkeley tables -- how to set up?
I'm a relative
Tony Bailey writes:
> I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out
>how to get the query I
> need against the version without the union
>
[skip]
> 2)
> select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection,
>docs.docsubdir, docs.docm
Sergei Golubchik wrote:
> Hi!
>>
>
> I didn't test it yet.
>
> The one thing I can say just now that unlike natural language search
> code (as exists in MySQL in 3.23) it need not to build the complete list
> of matched documents in memory in advance. It means that with LIMIT it
> should be
Hi All,
I need to setup MyODBC DSN's for MySQL access.
Does anyone know how to build a simple installer that will create
User/System DSN's from a file? ie. like the odbc.inf file included with the
MyODBC installer?
Can odbcconf.exe be used to install a DSN? If so, what are the parameters
used
From: Jonathan Hilgeman <[EMAIL PROTECTED]>
> ...MySQL server is now restarting a lot.
> mysqld got signal 11;
> ...any ideas?
I had something similar, very frustrating. I was advised by an acquaintance at MySQL
to upgrade to 3.23.42. I did and I haven't had the restarting problem since. I don'
I have an app that uses about 6-7 databases. But the MySQL server is now
restarting a lot. I was having a problem with this before - I had about 267
restarts in a matter of a month or two. I shut down the server, ran
myisamchk on the databases and it found a lot of open connections, and I
guess cl
Hallo,
I' am a newbee about replication and i can not find any information about
two-ways replication. Can you help me???
An application shall a two-ways replication substitute. I have found in the
MySQL Reference Manual a documentation about one-way replication and a
question in the FAQ Block (
On Monday, November 26, 2001, at 11:34 AM, Michael Collins wrote:
>
> No, it is not found on "Downloads for the 3.23 version" at:
>
> http://www.mysql.com/downloads/mysql-3.23.html
>
> Look for:
>
> MacOS X downloads
> Binary packages (tar.gz)
> MySQL 3.23.45 MacOS X Server 1.x (PowerPC) (4.7M)
I'm a relative newbie to MySQL (most of my experience is with Oracle) and am
currently trying to set things up to use the Berkeley tables with
transaction processing.
I downloaded the mysql-3.23.44.tar.gz source and installed it on Linux Red
Hat 6.2. I configured it with the --with-berkeley-db op
Thanks! I'll change the name from "download.php" to
"mysql-3.23.45.tar.gz" in my source directory, and I'll remember the
valuclick mirror. I'm assuming that's in N. America somewhere.
Erik
On Monday, November 26, 2001, at 11:29 AM, Mike(mickalo)Blezien wrote:
> Try here:
> ftp://mysql.val
At 6:22 AM -0800 11/26/01, Erik Price wrote:
> > 1) Will there be a binary for MySQL 3.23.45 for MacOS X 10.0.x
>> (Darwin 1.3.x)?
>
>Isn't there one there? On the "Downloads" section of the site? I just
>wish my local mirror was updated to include it
No, it is not found on "Downloads for
This kind of voting is reductive as i for instance would answer both. They
both have its uses, and wise is the one that can recognize when to use one
or the other...
Cheers,
Luis Ferro
WebDev
-Original Message-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 26 de Novemb
Try here:
ftp://mysql.valueclick.com/pub/mysql/Downloads/MySQL-3.23/mysql-3.23.45.tar.gz
I always find this FTP site with the most up-to-date files and is very reliable!
:)
>>On Mon, 26 Nov 2001 10:17:22 -0500, Erik Price <[EMAIL PROTECTED]> wrote:
>>
>>Can anyone tell me the "official" nam
On Mon, 26 Nov 2001, Sinisa Milivojevic wrote:
> Quentin Bennett writes:
> > So, if you pass NULL in as the first parameter to mysql_real_connect, a
> > possibility opened up by the manual . . .
>
> There is no indication in our documentation that NULL should be passed
> as a first parameter in my
1 - 100 of 151 matches
Mail list logo
