e problem you're having, in addition to bringing the grammer
in line with the manual.
*HOWEVER*, the "FOREIGN KEY" line appears to still be broken; that
opt_constraint bit is screwing things up, and I didn't succeed in
figuring out how.
--
Pete Harlan
[EMAIL PROTECTED]
---
rhaps someday MySQL will work that way, but until they
say it does you can't count on any specific behavior.
I suppose that means:
begin transaction
update tbl set tmp=col1, col2=col1
update tbl set col1=tmp
commit
--Pete
--
MySQL General Mailing List
eval2;
If datetimeval is cast to a date in the where clause, the row is
returned in both versions.
--Pete
--
Pete Harlan
ArtSelect, Inc.
[EMAIL PROTECTED]
http://www.artselect.com
ArtSelect is a subsidiary of a21, Inc.
--
MySQL General Mailing List
For list ar
s the, e.g.,
sort, is finished, then I only have to figure out how many threads are
likely to need a sort_buffer at any given time.
I looked through the manual, various online documentation, and the
source, but haven't been able to determine an answer.
Thanks,
--
Pete Harlan
[EMAIL PRO
he memory as
soon as they're done with it or hold onto it for (probable) future
use. If I had to guess from reading that page, I'd say they probably
free it, but if I had to guess from the memory use of our db server,
I'd say they don't.
--Pete
> Pete Harlan <[EMAIL PROTE
> > select ( select max(c.idrow)+1 from provasql c ) , 'This is only a test';
Does changing "max(c.idrow)+1" to "coalesce(max(c.idrow),0)+1" solve
your problem?
--Pete
On Fri, Nov 04, 2005 at 04:56:26PM +0100, AESYS S.p.A. [Enzo Arlati] wrote:
>
>
&
wanted to send a message
on the list in case someone is having trouble with 4.1.16 and doesn't
know why, or is thinking of upgrading and might want to wait, or knows
a solution to this problem besides downgrading.
[Linux, MySQL-compiled x86_64 binary, InnoDB or MyISAM tables.]
--Pete
--
My
Agreed. OTOH, I would recommend 4.1.15 until they solve the problem
with updates in 4.1.16 apparently not using index prefixes.
--Pete
On Sun, Jan 15, 2006 at 05:07:08PM +, Jocelyn Fournier wrote:
> Hi,
>
> Excepted if he found a bug in an older version of MySQL, it's of c
et
is small and static enough, this can be a good solution too in the
right situation, and one that avoids the mathematical hackery of
nested sets.
--Pete
> Jochen Kaechelin wrote:
> > I have the following table:
> >
> >
> It is rather strange for me; they normally should have disappeared after
> 28800s of inactivity.
>
> Could you give me a clue?
>
> Marc.
Perhaps it's this:
http://bugs.mysql.com/bug.php?id=16995
That's when using NPTL ("Native Posix Thread Library&quo
manually install the later glibc's (2.3.5 or 2.3.6)
from testing/sid, or just update the whole kit and kaboodle.
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
all to mysql_query(select ...) must always in
these circumstances return success.
Thanks!
-- Pete Wilson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
to usrs(usr,email) values(\"pete\", \"p...@pwilson.net\");" );
I can imagine this happening when the connector is running in real life. So:
What is the correct and reasonable way for a running connector to deal with
this error intelligently?
Thanks!
-- Pete Wilson
h
http://www.kionic.com
I've been a very active and heavy customer for years and very satisfied.
-- Pete Wilson
http://www.pwilson.net/
--- On Sun, 4/19/09, Cameron Rogers wrote:
> From: Cameron Rogers
> Subject: A good US Hosting Site?
> To: mysql@lists.mysql.com
be interested in the answer, though, from someone with experience.
-- Pete Wilson
http://www.pwilson.net/
--- On Thu, 5/14/09, Jim Lyons wrote:
> From: Jim Lyons
> Subject: Re: MAC address as primary key - BIGINT or CHAR(12)
> To: "Ilia KATZ"
> Cc: mysql@lists.mysql.
r indexing) and also
the readable representation (just for debugging/problem-solving)? (Well, of
course I know what the cost is: it's 12 bytes, plus overhead, per row.)
It all depends, but in general, would you call that too costly, given the
benefit?
-- Pete Wilson
http://www.pwilso
2. I understand there are problems in storing photos in the db. Can one
overcome these problems somehow?
Thanks!
-- Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
an OK
approach?
I have to manipulate these INTs in my CGI code.
Thanks!
-- Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
> Pete wrote:
> > Hi folks --
> >
> > What would be the right approach in MySql 5.0?
> >
> > My table, USERS, has columns NAME and IP. Associated
> with each user is also a collection of from 0 to 50 INTs.
> What's a reasonable way to put these 50 I
few days, say.
Do I have the correct understanding of the situation? And how do people usually
deal with this error?
Thanks so much! I apologize for the newb-level question and really appreciate
your help.
-- Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Perhaps the "expire_logs_days" variable does what you're looking for.
--Pete
On Thu, Apr 26, 2007 at 09:01:58PM -0400, Tim Lucia wrote:
> # cat /etc/cron.mysql/20-purgemasterlogs
> #!/bin/sh
> /usr/bin/mysql --defaults-file=/root/.my.cnf -e 'show master logs; purge
you have set up their permissions correctly.
E.g., a user says, "I tried to do X but it wouldn't let me," and you
go in as them, repeat the problem behavior, fix it, test your fix, and
let them know it is fixed.
(Or, similarly, verify for yourself that their user is unable to do
#x27;d use a function besides fprintf altogether.
Otherwise, if your r["content"] happens to return a string that
contains "%s" or some other thing that causes fprintf to look for more
data on the stack, you'll get output you weren't expecting.
--Pete
On Thu, Aug 02
join t2 on ...
left join t3 on ...
where ...
> MySQL's optimizer cannot reorder the joins because it has the potential
> to change the result of the query.
Do have an example in mind?
Thanks,
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A monitoring solution which can monitor mysql as well as pretty much any
service on nix and win platforms is zabbix (http://www.zabbix.com), its very
easy to setup and personally I think its excellent. It may be overkill if
you just want to check a db is up though
-Original Message-
F
If I needed a brute force DB on an x86 platform would
using Version 3 vs 4 buy me any performance today ?
90% inserts, 5% simple selects, 5% other.
Sorry if a lame question
-pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
You need to do a join on the tables,
Simplest way is
Select * from gardens a, state b where a.state_id = b.id
Assuming id in the state table is actually what your planning on joining on.
Try to do it on the mysql command line before doing in code to make sure you
actually have the data you need
To me what is more important is where this is leading,
http://www.distlab.dk/badger/Publications/exec_summary.pdf
a true parallel database cluster, with the end goal of this
work being a parallel MySQL.
My cluster waits ..
-pete
On Mon, 2005-02-28 at 14:04, Greg Whalin wrote:
> Just fo
Hi All,
Is there a simpler way of doing a select for a given date, for instance if I
have a datetime field called date
And so its populated with a load of values such as
2005-01-07 09:00
2005-01-07 10:00
2005-01-07 11:00
2005-01-07 12:00
If I wanted all records which fall on 200
The table is indexed on the date field, doing a 'like' results in a table
scan, is there another way similar principal but would allow the indexes to
be used ?
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 March 2005 11:24 A
Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 March 2005 11:43 AM
To: Pete Moran
Cc: mysql@lists.mysql.com
Subject: RE: DateTime Select optimised
I would investigate a partial index perhaps on the date only? You could
index on just the date eg.
ALTER TABLE ADD INDEX (date(10));
I don't ha
Thanks Michael,
This way works fine anyway was just interested if there was a better way of
doing it.
Pete
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 March 2005 4:07 PM
To: Pete Moran
Cc: mysql@lists.mysql.com
Subject: Re: DateTime Select
ine 1
for a while and it failed quickly, with a simple insert hanging up and
"kill " being unable to kill it. (The thread's state was
"Killed", but it didn't go away and continued to block other threads
from accessing the (MyISAM) table.)
Any help would be appre
On Mon, May 23, 2005 at 11:52:50PM -0700, Kevin Burton wrote:
> Pete Harlan wrote:
>
> >In addition to failing the tests, I deployed the server on Machine 1
> >for a while and it failed quickly, with a simple insert hanging up and
> >"kill " being unable to
I've been surfing the list / google but can't find what to do
I have a tab sep file, where there are empty fields i.e.
the fields are associated with a mysql table integer type.
how do I get the empty fields to become NULL instead of
0 (zero) with a warning ?
Thanks,
-pete
UPDATE
for the column location that will do something like:
update fooloc set location = geomfromtext('point(lat lon)');
Is there a way to do this with a single update ?
tia
-pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
r occurs and the script stops. The mysql server remains
responsive to queries before and after the operation. No errors are
reported in the .err file.)
Thanks again in advance!
_M
Pete McNeil (Madscientist)
President, MicroNeil Research Corporation
Chief SortMonster, www.SortMonster.com
VOX: 70
Kind MySQL List,
I need your help.
I have an installation of replicated MySQL servers.
I am migrating to new servers and upgraded MySQL software.
My previous servers were RH8, MySQL 4.0.14. (A, B)
My new servers are Fedora, MySQL 4.0.17. (C, D)
Most of my critical data is built using INNODB tables.
In this case it might be easier for you to just modify the MySQL
source to disable looking for the socket, and treat localhost as
127.0.0.1.
--Pete
On Fri, Jan 30, 2004 at 06:33:22AM -0800, [EMAIL PROTECTED] wrote:
> --- [EMAIL PROTECTED] wrote ---
> > i've never set up tunnels
I'm doing some tests on a small Sun server, a 280R to demo
MySQL vs. Oracle. For the demo I using a subset of a test table.
The destination server will be a Sun 880 with 8 1.2 GHz CPU's,
16 GB RAM, Sun T3+ RAID Array.
Any suggestions on settings or other changes would be helpful.
Also what woul
by mysqld has
so far not gone above 1 GB (both resident, and requested).
-pete
-Original Message-
From: walt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 10:47 AM
To: Lancashire, Pete
Cc: [EMAIL PROTECTED]
Subject: Re: what can i change in my.cnf/mysqld to get better perf
Hello,
Personally, I think it's a matter of choosing the best tool for the job.
For myself and my team, Java is the work horse particularly - suited for
rapid application development and when there is a strong cross platform
requirement. This means that Java tends to dominate our utilities and
to another packaged version, but
clearly the problems aren't at the database end of things. Good work.
Thanks again,
--
Pete Harlan
harlan @artselect.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote:
...
> 4.0.13 has better diagnostics. Please upgrade to it if you are not using
> MySQL replication.
Is there something wrong with 4.0.13's replication, or does it not
replicate properly with 4.0.12?
--Pete
--
MySQL Gene
I couldn't believe it so I looked.
When I load the manual page I _do not_ see any such thing.
Something else must be going on.
_M
At 11:43 PM 7/10/2003 -0400, C. Reeve wrote:
Hi,
I have noticed recently that every time I go to the MySQL manual page I
get prompted to install Gator spyware. If MySQL
t you started.
Hope this helps,
_M
Pete McNeil (Madscientist)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 03:30 PM 8/20/2003 -0700, Scott Haneda wrote:
What would be a good way to deal with the following...
I have a form that has 5 checkboxes on it, lets say the checkboxes are for
categories, and more than one can be selected.
For example:
please tell is what brochure you want
[] car
[] boat
[] tru
export CC=gcc-3.4
./configure --prefix=/usr/local/mysql \
--exec-prefix=/usr/local/mysql \
--with-mysqld-ldflags=-all-static \
--disable-shared --enable-thread-safe-client \
--with-extra-charsets=all
====
` is NULL.
FWIW, IFNULL() does the same thing, with a clearer (to me) name, e.g.,
IFNULL(sum(qty), 0).
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I recently had a similar problem, however you may find that its more of a
case of correctly indexing your tables.
Yyou should look for the tables which need indexing, I enabled the
slow-query-log as well as enabling of logging of queries which didn’t use
indexes and found some which did some very
group by route
order by rating
As others have pointed out, your ratings aren't something MySQL will
know how to order. That's a separate problem (and more difficult to
solve), but the between syntax is also one.
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thursday, July 15, 2004, 9:10:43 AM, matt wrote:
mr> Justin Swanhart wrote:
>>Indexes can generate vast amounts of random i/o.
>>Because of rotational latency, random i/o can really
>>slow you down, especially if you are using IDE or SATA
>>disks because they can't do tagged queueing like SCS
It might help if you say what version of MySQL you're using, give the
table schema, etc. I couldn't reproduce the behavior you describe
here.
--Pete
On Mon, Jul 19, 2004 at 12:13:47PM -0500, Deepak Vishwanathan wrote:
> Hi,
>
>
>
> I have a table with a colum
3.2 (on Debian Testing).
We're moving to 64-bit soon, primarily to be able to run MySQL with
more RAM.
Thanks,
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;s the answer I got when I asked a similar question a few
weeks ago.
HTH,
--Pete
Egor Egorov <[EMAIL PROTECTED]> writes:
> The section of your manual describing what some of the glibc
> problems are is helpful; do you know if the linuxthreads-2.2.2 patch
> made it into glibc
y
"... as number, tableName.* from ...".
HTH,
--Pete
On Tue, Sep 23, 2003 at 04:54:03PM +0300, Director General: NEFACOMP wrote:
> Can you run this query and tell me if it works on your machine?
> SELECT (@var := @var + 1) AS Number, * FROM any_table_with_
limit -u 500" before launching mysqld?
--Pete
On Sun, Oct 12, 2003 at 01:44:39PM +0200, Stefano - 3000 Staff wrote:
> Hi all,
>
>
> I'm running a debian woody with mysql 4.0.12 . Sometimes i get error 11 '
> can't create new thead etc '
>
> I
happily write much larger files.
The 2GB filesize limit was due to glibc and the linux kernel, not the
ext2 filesystem. Any linux distro from the past year or so should be
able to handle >2GB files on any filesystem.
Hardware raid is invisible to Linux, so won't affect the maximum
usable fi
an.
Cheers,
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cking the pages in a type of
cache. (Hopefully OSs are smart enough not to further cache ramdisk
pages.)
I haven't used a ramdisk in a db server yet; I don't have any one
table that simply MUST be read out of memory every time, and the OS
does a pretty good job of managing things. YMMV.
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
should tell you
which machines they are coming from and which users, and that should
help you track down who's holding connections open.
--Pete
On Wed, Nov 12, 2003 at 01:15:54AM +0100, Henrik Skotth wrote:
> Hello!
>
> I have tested this now, and that isn't the cas
me.
4.0.1 isn't the latest, so I assume you're using something later.
Regardless, I wouldn't expect the performance on the two machines to
be so different unless the one has so much ram that everything is
running from memory while the other has to thrash the disk.
--Pete
On Su
My two cents: Just upgrade. We hammer on it pretty hard and the
transition has not only been smooth, it's been a delight. The query
cache, on our load, handles 60% of the queries, which I never imagined
would happen.
4.0.18 feels as boringly stable as most released MySQLs :)
--Pete
O
8 hours to
reindex
-pete
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: Monday, March 29, 2004 10:12 AM
To: [EMAIL PROTECTED]
Subject: Re: Creating index on very large table
Hello Jeffrey,
Monday, March 29, 2004, 7:05:27 PM, you wrote:
JH> I've got a problem
ield name, for example.)
So I doubt it will happen, but not because it couldn't be done.
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The 2GB (not 2 Mb) file size limitation on Linux went away years ago.
Unless your distribution is very old you won't have a problem.
--Pete
On Tue, Apr 06, 2004 at 05:05:59PM -0300, Ronan Lucio wrote:
> Hi All,
>
> I always worked with MySQL on FreeBSD systems.
>
> Now
Hello folks,
I'm usinng MySQL 4.0.17.
I have a table something like:
RuleID int,
GMTBase datetime,
Credited bigint,
...
I have an index built on GMTBase.
I have rougly 8 million rows.
GMTBase stores a datetime for the top of the hour on a given date.
I want to build a summary of the last 2 days
At 01:30 PM 5/5/2004, Daniel Clark wrote:
I wonder if mysql isn't trying to process
where GMTBase > DATE_SUB(CURRENT_DATE, INTERVAL 2 DAY)
What about doing this date subtracting in PHP and adding the result to the
SQL statement.
Nice try - but it's not the problem. Replacing the equation with a c
On Thursday, June 3, 2004, 8:14:00 AM, Victor wrote:
VP> If you choose to copy the files I would ensure that you are getting the
VP> innodb binary logs as well if they do not exists in the mysql data
VP> directory. The innodb backup tool or even mysqldump may provide a more
VP> consistent snapshot
On Thursday, June 10, 2004, 1:20:03 PM, Mark wrote:
MvB> Hi,
MvB> For a project I'm creating a search function, the deal is this, a select
MvB> query must be submitted and in this query a check must be done to confirm a
MvB> previously found and accepted item is not shown anymore, a short version
On Friday, June 11, 2004, 7:00:39 AM, Csongor wrote:
FC> Hi,
FC> I have a table that has a few short text fields [text(4000), text(1000)]
FC> I would like to index. Do you think it is a good idea to index them
FC> "simply", or is it better if I create auxilary fields which hold the MD5
FC> for th
in my experience you shouldn't be
*that* worried about compiling it yourself. (Of course, if you have
problems and expect any help with it, paying for support sounds like a
good idea.)
--Pete
> So if you need rock stability on Linux and still need to have a
> custom built binary
the RAID arrays were built at RAID-0
90% of the time the db's will be doing only selects, the
db's will be updated nightly.
-pete
Well I opened my big mouth and now have to do a demo
of MySQL on an old server that was destined for the
dumpster.
It has 4 Pentium III, 512 MB of m
What I'm looking for are some suggestions on ./configure
options and potentially GCC options.
Thanks in advance,
-pete
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Hi,
In regard to my previous message - I would also be interested if anyone is
aware of a general source for MySQL rpm's built for 6.1/6.2. I would prefer
to build my own but if I do not succeed I would also be interested in anyone
else's. I assume that there are no MySQL supplied rpm's for 6.1
Hi,
I hope this message is not out of place, but I have not been able to solve
this problem. I need to rebuild the latest MySQL rpm's for use
on some RedHat 6.1/6.2 machines and have been having quite a few problems.
I've made sure I have :
autoconf-2.52
automake-1.5
libtool-1.4.3
which I beli
n that 'case' it was a standard sql reserved word iirc.)
I don't have any fields named "force", but surely someone does.
Just a thought. Thanks for the great "sql, database" :)
--Pete
-
Befo
has to put the results in an array of some kind
I believe those numbers are unknown when generating the row values.
--
Pete Harlan, who doesn't speak for the MySQL developers of course.
[EMAIL PROTECTED]
-
Before posting, pl
Hello,
Can anyone recommend a script to analyze a mysql server general query log.
My goal is to determine which users are putting the most load on the server.
Any other methods to achieve this same goal would be appreciated as well.
Thank you.
__
#x27;t help you there but I'm
sure someone can).
--Pete
On Tue, Mar 04, 2003 at 09:04:20PM -0500, Gary Huntress wrote:
> Greetings,
>
> I've been running a public MySQL server for a couple of years that now
> supports several thousand users. I used to run this on a lowly
anyway; I didn't try it
elsewhere).
That's potentially dangerous and not completely obvious side-effect of
tunneling SSH ports.
SSH doesn't allow tunneling sockets unfortunately.
--Pete
-
Before posting, please che
ich is what
bit us. You specify a port in the DBI->connect() routine as something
like ';host=localhost;port=2000' and it's silently ignored there too.
I'm very glad that ssh no longer (as of three years ago!) forwards
externally-connected-to ports by default.
--Pete
--
27;s
slow, create it non-unique and it's fast. The EXPLAINs look the same
for both.
Is this to be expected under some circumstances, or do I get to
isolate this messy situation (it's an ugly query) for a bug report?
MySQL-3.23.55, Linux, MyISAM.
Thanks,
--Pete
--
MySQL General
ed by
ANALYZE TABLE is done (and stored) when creating a non-unique index,
but not when creating a unique one.
Tested in 4.0.12 and 3.23.56.
I have a simple test case if needed. (There's way too much data in
the test case to present it here.)
--Pete
On Thu, Mar 27, 2003 at 08:39:41PM -06
g more elegant than
> >> SELECT FROM ... WHERE 0=1; ?
> >>
> >> I need this because PHP throws an error when an empty statement
> >> (or just a ';') is passed to MySQL.
> >
> >SELECT 1;
> >
> >?
> >--
>
> That returns a row,
If I have amast/salve pair where the slave is replicating from
the master then do the table types have to be the same ?
Specifically can I have a myisam table on the master and replicate to
a bdb table on the slave ?
The reasoning behind this is to try and find a *fast* was to convert
a MYISAM t
> CREATE TABLE new_table ()
> TYPE=BDB;
> INSERT INTO new_table SELECT * FROM old_table;
> CREATE INDEX ... ON new_table;...
> ALTER TABLE new_table ADD PRIMARY KEY (...);...
> RENAME old_table TO old_table_bak;
> RENAME new_table TO old_table;
>
> That should cause a downtime of less than a seco
> Yeah, just go with InnoDB. :-)
any good ? I took a look at the documentation, but it all seemed somewhat
heavyweight for my liking...
I have an application that runs very nicely at the moment - we have one minor
problem which is that we have one insert into two tables which may not hapen
prope
> mysql> show databases;
> +-+
> | Database|
> +-+
> | CarbonUFSVolumeInfo |
> | mnta|
> | mntb|
> | vi.recover |
> +-+
> 4 rows in set (0.04 sec)
Umm, those look very much like files
> We are discussing the 'mysql' client which is often used to write
> scripts that run under the
> UNIX shell.
...
> If you write a script that has two semi-colons in a row, the second one
> is ignored and no error message is given.
Err, not true (in amysql script anyway)
I think you are tryi
> am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
> characters of language such as hebrew/arabic?
My best suggestion would be to store all your test in Unicode UTF-8 format
and use the type BLOB in the table in order to store it. We do this
and can quite happily mix
> You need to create a new user and group for mysql.
> Open your OSX manuals and start reading.
Additional hint - nidump and niload will do the trick (assuming
it works like alll other NeXT systems, which it seems to).
-pcf.
-
rename table foobar to foo;
rollback;
the rename is done anyway, and seen by other clients immediately after
the rename command. Is this normal?
Thanks for any help,
--Pete
-
Before posting, please check:
http://w
> Is it possible to use MySQL with a chinese charset (utf8) ?
You need to use BLOB or TEXT types and do a little bit of work yourself
to manage them, but basically it does work fine. mySQL just treats it
as binary data.
-pcf.
-
> >p.s. PLEASE can you put a [mysql] tag on the list???
> Please not, it wastes space on the screen.
not a lot of space - and does have the great advantage that we
can then filter out the mysql stuff into a separate mailbox whihc
(on standard UNIX mail) isnt possible without it.
-pcf.
---
a separate disk?
Alternately, is there a way to trigger this action at night, so we can
avoid it happening during the day? It shut us down for about five
minutes today.
Details follow. Many thanks,
--Pete Harlan
[EMAIL PROTECTED]
Possibly relevant details:
1. Binary mysql-max-3.23.51-pc-linux-gnu
f a small measure of recoverability in the unlikely event
of a crash.)
[Is there a way to set that variable with 3.23.51 without shutting
down the server? I couldn't find a way.]
Thanks,
--Pete
sql,query
-
Before
was just finished being written to. (Because its
modification time was the previous minute, while the next (zeroth) log
file was now the active one.)
I know without a repeatable test case, there's not much you can do.
If I get more information I'll let you know. It helps to hear that
t
If you're using InnoDB tables, replication stops the slaves from
running. Heikki said he'd try to get this fixed for 3.23.52.
--Pete
On Mon, Aug 12, 2002 at 04:05:11PM +0200, Lutz Maibach wrote:
> Hi,
>
> today I noticed a strange behaviour in MySQL 3.23.49a-Replication I
I want to prevent duplicate entries into my mysql database which holds
invertory of all network eqpt at my site. Engineers access it thru
netscape and the query insert is done via pdp [below].
I will place the script into php, any pointers on this would be
appreciated.
THX!
Pete
1 - 100 of 160 matches
Mail list logo
