--
**
*Tom Sztur*
*LUSIGHT RESEARCH*
t. +1.416.934.7232
tom.sz...@lusight.com
Please visit us at www.lusight.com
This message is confidential and may be privileged. If you are not the
intended recipient, we kindly ask you to inform the sender. Any
un-authorized dissemination or copying
.
Thanks,
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
do it like this:
in the application, kick users of d1 out
create database d2
foreach t in d1:
RENAME TABLE d1.t TO d2.t
tell user to use d2
?
tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
16.3.1.9. Replication and LIMIT
Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
statements is not guaranteed, since the order of the rows affected is not
defined. Such statements can be replicated correctly only if they also
contain an ORDER BY clause.
that you must use mysql 5.1.
Greetings,
Mattia.
2010/4/28 Tom Worster f...@thefsb.org:
16.3.1.9. Replication and LIMIT
Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
statements is not guaranteed, since the order of the rows affected is not
defined. Such statements
Say tables a and b each have their own id column (primary key) and sundry
other columns. Table j has columns aid and bid to join a and b many-to-many.
Now, I want to select the joined a/b rows where the b rows are joined to (a
different set of) rows in a that meet condition x (which refers only
On 4/26/10 7:36 PM, Gary gp...@paulgdesigns.com wrote:
I cant seem to get this working.
$query=SELECT im.image_id, im.caption, im.where_taken, im.description,
im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american,
kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter .
I'd go with the 4G 4-core server. If you're running apache and a sensible
OS, the extra cores can be helpful. So, unless you know you have a need for
very large key buffers, 4G should leave the OS plenty for FS cache.
Not that I actually have a clue. I really just wanted to be the first to
answer
On 2/7/10 7:28 AM, Anthony Urso antho...@cs.ucla.edu wrote:
Does the order of tuples in a bulk insert impact later query
performance? E.g. will sorting the rows before a bulk insert cause
queries to perform better for indexed or non-indexed fields?
when i load a large body of data (using
employee set reference = ROWNUM where fkcompanyid = X
I think in Oracle ROWNUM would help me do this.
I.e. generate a reference based on the position in the result set.
any Ideas ?
--
Tom Goring
On 1/29/10 5:03 PM, mos mo...@fastmail.fm wrote:
I noticed the article didn't say how much money you'll save by not paying
through the nose for Oracle per server licensing, the cost of upgrading
your hardware to get some speed out of Oracle, or the cost of having to
hire one or more Oracle
it's not an innodb thing:
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
Note
There can be only one AUTO_INCREMENT column per table, it must be indexed, and
it cannot have a DEFAULT value. An AUTO_INCREMENT column works properly only if
it contains only positive values. Inserting a
How about:
1 shut down the slave, upgrade it, restart it, let it catch up.
2 shut down the master, upgrade it, restart it, let the slave catch up.
?
On 1/12/10 12:34 PM, Lawrence Sorrillo sorri...@jlab.org wrote:
Hi:
I want to upgrade a master and slave server from mysql 4.1 to mysql
machine) . I can do what I am proposing in parallel.
Do you see it as problematic?
~Lawrence
Tom Worster wrote:
How about:
1 shut down the slave, upgrade it, restart it, let it catch up.
2 shut down the master, upgrade it, restart it, let the slave catch up.
?
On 1
On 1/7/10 3:10 PM, Matt Neimeyer m...@neimeyer.org wrote:
I'm trying to select names at random from a table that contains the
name and the frequency at which it is actually used in society. The
table is defined as follows:
CREATE TABLE `MaleNames` (
`Name_ID` int(11) NOT NULL
On 12/30/09 1:13 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com
wrote:
Hi,
My MySQL server Aborted_connects status is showing 8692 and is rapidly
increasing.
What are reasons and how do i decrease the same?
We are using connect() method in PHP code and have tried below command
On 12/18/09 12:41 PM, Douglas Nelson douglas.nel...@sun.com wrote:
You guys are incredibly naive, Oracle has promised to support MySQL for
the next 5 years.
thanks. you too.
Who better to have stewardship of a database product
then the leading database supplier.
almost anyone, since you
i have a large myisam table (about 3gb) that is updated once a day in the
middle of the night.
when it is not being updated, is there any reason not to copy it out with
rsync without shutting down the server or flush tables with read lock or
whatever?
--
MySQL General Mailing List
For list
On 12/14/09 1:49 AM, Claudio Nanni claudio.na...@gmail.com wrote:
If he really cared about MySQL he would have not sold it or prevent from
selling it to Sun.
i don't see the logic in this sentence.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 12/13/09 11:23 AM, Neil Aggarwal n...@jammconsulting.com wrote:
Doug:
I do not
see anyone willing to put up anything to support mysql... you
don't like
it... put up a billion dollars an take control or shut the heck up!
Assuming MySQL as it stands today is 100% open source,
I
of switching to Postgres,
to a fork, start a new project, or quit dba for other real open source
spirit journey.
The community and open spirit is important not the product.
Thats my view.
Thanks Monty, always, for your gift.
Claudio
On 14 dec 2009 19:36, Tom Worster f...@thefsb.org wrote:
On 12
i run mysqlhotcopy on each database once every three hours.
i happened to be running my cache warmer this afternoon, which logs timing
for a bunch of standard randomized queries, that when the backup script ran,
the query times increased by a factor of about 20 from a nice quick pace
back down to
On 12/7/09 5:26 AM, Victor Subervi victorsube...@gmail.com wrote:
Hi;
I posted this Saturday. Perhaps it's too challenging for those who read it
to answer. I hope someone can.
I need to write a select statement that enables me to select column 'ID'
from a table where a certain value is
i have two questions. (1) innodb? (2) why delete slave logs when you can
restart the slave with --skip-slave and then use CHANGE MASTER TO?
tom
On 12/4/09 6:34 AM, Robinson, Eric eric.robin...@psmnv.com wrote:
Let's face it, sometimes the master and slave get out of sync, even when
'show
On 12/4/09 11:59 AM, Robinson, Eric eric.robin...@psmnv.com wrote:
(2) why delete slave logs when you can
restart the slave with --skip-slave and
then use CHANGE MASTER TO?
Well... I guess mainly because I didn't know about that option! I
thought I needed to fake out mysql on this, but it
On 12/4/09 3:14 PM, Gavin Towey gto...@ffn.com wrote:
I would say that it's very important to know why data is getting out of sync
between your master and slave. Fixing those root causes would eliminate the
need for this.
i very much agree. the only instances of slaves getting out of whack
On 12/2/09 11:13 AM, David Shere dsh...@steelerubber.com wrote:
Tom Worster wrote:
how about using LEFT JOIN:
SELECT ...
FROM listings a
LEFT JOIN Transactions b ON b.PartNumber = a.PartNumber
This gives me a result set of 456,567 lines. I'm looking for a result
set of 60-70 lines
On 12/1/09 2:21 PM, David Shere dsh...@steelerubber.com wrote:
select distinct a.PartNumber as 'Part Number', (
select count(1)
from Transactions b
where b.PartNumber = a.PartNumber) as 'No. Sold'
from listings a
order by a.PartNumber
It currently takes 30 seconds to run.
Thank you for the answer. This makes sense.
As such, the questions of preloading the key buffer in a replication system
are probably resolved. I think I can safely put CACHE INDEX and LOAD INDEX
INTO CACHE statements in the --init-file of both masters and slaves.
tom
On 11/29/09 8:39 AM, Johan
the slave execute CACHE INDEX and LOAD
INDEX INTO CACHE statements the master reads from its --init-file and writes
to the big-log?
tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
. But, that didn't log anything to the permanent log. The
only trick about using my_printf_error was getting the header includes
correct -- I needed mysql/my_global.h first.
On Wed, Jul 15, 2009 at 7:09 PM, Tom Kleinpetertomkleinpe...@gmail.com wrote:
Hello,
I've written a fulltext plugin for Mysql 5.1
Hello,
I've written a fulltext plugin for Mysql 5.1. The plugin works great
and I'm happy with it, but I would like to log an error when I
encounter some unexpected data. Do plugins have access to the Mysql
error log? If so, how do I write to it?
Thanks!
--
MySQL General Mailing List
For
Hi Abdul-
you may want to check this thread out regarding the same issue...
http://www.webmasterworld.com/php/3565843.htm
On Apr 19, 2009, at 3:23 PM, abdulazeez alugo wrote:
Hi guys,
I'm having a really terrible problem with my mysql coding and I'ld
appreciate any help I can get on
Hi,
I have a table like so
id autoinc
userid int
action enum ('login', 'logout' )
timestamp
--
Is it possible to perform a mysql query that gets the total logged in
time for any one user on any one particular day/week/month? And how?
--
MySQL General Mailing List
For list archives:
It mentions that root in MySQL has nothing to do with the root of Mac
OSX, but I need to know if MySQL being unprotected in this way has
opened a door for hackers.
it means that they can do whatever they want to the mysql db's without
being prompted for a password. This does not mean
Main
1234 Main
Any ideas? Thanks for looking! :)
If this is in excel, perhaps you'd want to pre-process this before it
gets to MySQL? e.g., in python:
isodd = int(address.split( )[0]) % 2
In general, you have to split the string, and test the numerical value
(modulo).
..Tom
--
MySQL
The function is working correctly. Check your coordinates. The point doesn't
fall within the polygon you defined.
..Tom
-Original Message-
From: Chris Kantarjiev [mailto:[EMAIL PROTECTED]
Sent: Wed 19-Nov-08 19:38
To: mysql@lists.mysql.com
Subject: MBRWithin bug?
I'm trying
According to the doc for this parameter, Possible removals happen at
startup and at binary log rotation. This implies that removal is not
automatic - you have to either flush logs or bounce the server. We use
Purge Master periodically.
i do this from cron
mysql -e PURGE MASTER LOGS
Hello Josh,
why you moved your table to InnoDB? Your description doesn't sound like the
tables rows
are accessed concurrently and need to be locked? Are you sure you need
InnoDB for this table?
If you need InnoDB you probably need to redesign your queries and table
structure to get them
more
The rows in this table are accessed concurrently as any activity on the
site is recorded/added/updated to this table. We have several others
which serve similar purposes, (sessions, totaltraffic, etc...).
Is the performance lag occurring with read-only queries and updates/inserts
to the
between 16-32MB if you have many transactions.
TomH
-Original Message-
From: Tom Horstmann [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 04, 2008 11:15 PM
To: 'Josh Miller'
Cc: mysql@lists.mysql.com
Subject: RE: innodb/myisam performance issues
The rows in this table are accessed
To: Tom Horstmann
Cc: mysql@lists.mysql.com
Subject: Re: innodb/myisam performance issues
Tom Horstmann wrote:
Addendum..
Please also try increasing your innodb_log_file_size to a much higher
value
if you
have lots of writes/transactions. Maybe 250MB is a good first try.
You need to delete/move
Right... and perhaps try MySQL Enterprise Monitor. A trial is available from
mysql.com. It may give you hints on your mysql.cnf.
Kind regards,
TomH
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2008 11:35 PM
To: Jim Leavitt
Cc:
an insert into the child table. The PK's
and FK's should be good.
Thanks and have a great day!
Tom
On Mon, Aug 25, 2008 at 2:37 AM, Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi Steffan, all !
Steffan A. Cline wrote:
[[...]]
I am hoping that by using FK based relationships I can just do one
I forgot to mention that the only benefit of a stored procedure would be
minimizing code in your application. you'd have a single call to the stored
procedure... though some people may prefer having the back-to-back insert
statements in their code.
On Mon, Aug 25, 2008 at 11:28 AM, Tom Nugent
formatting defaults).
Of course, you could write a post-processing script that adds the leading zeros
to records not long enough.
..Tom
-Original Message-
From: Keith Spiller [mailto:[EMAIL PROTECTED]
Sent: Thu 21-Aug-08 22:11
To: mysql@lists.mysql.com
Subject: Zip Codes with Leading
I run 4.1.20 in master/master for nagios clustering. Everything was
working fine until both machines went down due to power failure in the
IDC. On powering back up one of the machines has come back fine but on
the 'secondary' bearing in mind this is master/master but actually the
01
Hi
I run 4.1.20 in master/master for nagios clustering. Everything was
working fine until both machines went down due to power failure in the
IDC. On powering back up one of the machines has come back fine but on
the 'secondary' bearing in mind this is master/master but actually the
01
work still to be done. Congrats to the Open Source Community for
producing such portable software.
Regards Tom
-Original Message-
From: Joerg Bruehe [mailto:[EMAIL PROTECTED]
Sent: Fri 20-Jun-08 6:57 PM
To: Swigg, Tom C
Cc: mysql@lists.mysql.com
Subject: Re: Migration of mysql 3.23.32 from
a mysql3/4 environment on RHEL 5.1 is essential.
Any help gratefully received.
Tom Swigg
LSBU
--
Email has been scanned for spam and viruses by Altman Technologies' email
management service
Copyright in this email and in any attachments belongs to London South Bank
University. This email
I don't think you need to flush your bin logs.
CHANGE MASTER TO MASTER HOST = 'hostname';
Look at this for more info at
http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
There is a lot more you can add to the statement.
thanks but this gave me a very similar error - I
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0 213274351
080522 11:53:40 [ERROR] Failed to open the relay log
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0 213274351
080522 11:53:40 [ERROR] Failed to open the relay log
Hi
I am running 4.1.20 as this is the stock version in RHEL4 u5 and i have
setup a master/slave combination. Updates at first appeared to work as
creating and inserting into the master created the db's on the slave
etc. I have noticed however that data in the master is not making its
way to
The error 1062 you could skipped in the slave modifying your my.cnf ( slave
side) using :
slave-skip-errors=1062
This error on duplicated records, normally is problem in binarylogs transfer
data. But, anyway, please confer that the data exist in the slave.
Yes thanks - i have done
Yes thanks - i have done that and restarted the slave and _some_
tables now appear to update but others dont
eg
master:
mysql select count(*) from tbl_checkcommand;
+--+
| count(*) |
+--+
| 30 |
+--+
1 row in set (0.00 sec)
slave:
mysql select count(*) from
I'm curious if anyone has any thoughts on how I can handle a data
retention issue I've been facing with a larger dataset.
My process, roughtly is run mysqldump against the DB and gzip the
output. Then I transfer it off to a different machine for archival
onto optical media (yes I know
Hi,
I have the following sql request:
SELECT projects.`id` AS t0_r0, projects.`name` AS
t0_r1, projects.`abbreviated_name` AS t0_r2,
projects.`producer` AS t0_r3, projects.`tel_1` AS
t0_r4, projects.`tel_2` AS t0_r5, projects.`recital`
AS t0_r6, projects.`completed_flag` AS t0_r7,
Hi,
First, sorry, I kind of messed of with copy and
pasting (it's been a long day) and forgot to strip all
the useless part (for the sake of explaining my
problem) between select and from...
SELECT * FROM projects LEFT OUTER JOIN forums ON
forums.work_id = projects.id AND forums.work_type =
--- [EMAIL PROTECTED] a écrit :
tom wang wrote:
Hi,
First, sorry, I kind of messed of with copy and
pasting (it's been a long day) and forgot to strip
all
the useless part (for the sake of explaining my
problem) between select and from...
SELECT * FROM projects LEFT
I built a laptop this weekend with mysql server version 5.0.37-log. The
laptop is running Fedora 7. Last night I was able to create a database
directory -- sym linking from /var/lib/mysql to a larger disk,
/usr/local/data. I was able to create tables and loaded 10 million rows of
data into
Below is a new stored procedure that I am trying to make for building a SQL
with the supplied parameters.
1:DELIMITER $$
2:CREATE PROCEDURE `Search_Code_Samples`(
3:IN search_words VARCHAR(300)
4: , IN multi_word_condition VARCHAR(3)
5: , IN language_id INT
6: , IN
Thanks. That fixed the problem. I put all of my DECLARE statements at the
beginning of the procedure. I finally got the thing to compile and it looks
like this:
DELIMITER $$
DROP PROCEDURE IF EXISTS `code_library`.`Search_Code_Samples` $$
CREATE [EMAIL PROTECTED] PROCEDURE
to an EPSG
code.
Is there a way to force mysqlgisimport to force setting an srid? Also,
is there a way to set the srid in the table after the data has been
uploaded?
Any advice is much appreciated.
Thanks
..Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
. And after that time you could simply create a
new table.
hth,
Tom Horstmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I upgraded a server from 4.0 to 4.1 and then to 5.0 but I've been
running into a problem. When I was running 4.0 the passwords with the
password('password') command where being created like this:
2a287c002f9773dc now after I upgraded to 4.1 when I add a new user the
passwords end up being like
Is there a hardware/software loadbalancer for multiple mysql servers
servicing read transactions?
linux lvs project
http://www.linuxvirtualserver.org/
as mysql network connections are tcp then this would work fine for reads
--
MySQL General Mailing List
For list archives:
I'm running into a problem with a ratings script I'm writing. The
overview is that a user can rate an item from 1-10. What I want it to do
is display the highest rated item, with 10 being the highest rating. In
case there are multiple items sharing the same score, the item that has
been rated
Hi
I have what i think is a strange issue -
All my users are NIS users and they can access this box fine. I have a
MySQL server running on this box that is running fine. The OS 'root'
user can authenticate and use MySQL fine as this is not a NIS user e.g.
[EMAIL PROTECTED] mysql -u bugs
and edit
table where it sotres index/counter data..
Tom Ray [Lists] wrote:
Hey, I have a really simple question (I hope)..I have a database
that has a field in it that autoindexes the number. I screwed up and
imported a bunch of wrong data. Up to row 200 it's right, beyond
that it was wrong so
Hey, I have a really simple question (I hope)..I have a database that
has a field in it that autoindexes the number. I screwed up and imported
a bunch of wrong data. Up to row 200 it's right, beyond that it was
wrong so I had delete it all. The problem now is the autoindexing is set
to 1105, I
Hey there, I inherited a couple of servers that are in production but I
noticed that there's not active logging for mysql on any of them. I
looked and they don't have an active my.cnf file any where on the
machines. One machine is running mysql 4.1.5 and the other is running
mysql 5.0.18
How would I do that? I'm still a novice when it comes to many aspects of
mysql.
[EMAIL PROTECTED] wrote:
Hi,
Try to enable query log.
Thanks Regards
Dilipkumar
[EMAIL PROTECTED]:
Hey there, I inherited a couple of servers that are in production but I
noticed that there\'s not
I have a few large databases each has over 1,000 tables. If I use the SHOW
tables; statement, then mysql returns all the names of the tables in any
one of my large databases in about 0.07 seconds. Very fast. But if I use the
standard statement: SELECT table_name FROM INFORMATION_SCHEMA.TABLES
(42S02):
Table 'test.tablename' doesn't exist.
Does anyone know why my code generated an error? Is this a bug?
Thanks,
Tom
(42S02):
Table 'test.tablename' doesn't exist.
Does anyone know why my code generated an error? Is this a bug?
Thanks,
Tom
never mind. I found the answer:
http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html
On 5/10/06, tom soyer [EMAIL PROTECTED] wrote:
Hi,
I tried to pass the name of a table into a procedure and use that in a
select statement. Somehow it doesn't work. Here is the code:
create
The code of insert_client.html which wasn't attached last mail:
http://www.spalha.com.br/spalha/form_client.html
Tom
From: Tom Lobato [EMAIL PROTECTED]
From: Peter Brawley [EMAIL PROTECTED]
Tom,
UPDATE command is not working for only the record that I want, but
for
all in the table
From: Jay Blanchard [EMAIL PROTECTED]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will open an attachment on a mailing
list.
Oh Yes, sorry. In really, I indeed uploaded the files to the server
www.spalha.com.br/spalha.
Tom
From: Jay Blanchard [EMAIL PROTECTED]
Post the line of PHP where this query exists.
Well, I think that show
$result = mysql_query($command);
won't help us, because the $command indeed begins to be constructed 120
lines before this. Only looking the code =(
Tom
--
MySQL
solve it =)
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
solve it =)
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Version 4.4.1, mysql client api version 4.0.25,
Mysql server 4.0.25) and got same results: WHERE _apparentily_ is ignored.
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) The code is in the beggining of the development, so are too many
uglyness yet =)
Thank you
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) The code is in the beggining of the development, so are too many
uglyness yet =)
Thank you
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Peter Brawley [EMAIL PROTECTED]
Tom,
UPDATE command is not working for only the record that I want, but for
all in the table. I sees WHERE is not interpretated by Mysql server. At
least the result is identic to it. For example, If my php execute
UPDATE clientes SET tipo='r
Writing echo
p-.mysql_error().-P-.mysql_info().-p;
below
$result = mysql_query($command);
gives the output:
--
-Rows matched: 2 Changed: 0 Warnings: 0-
So, it seems mysql doesnt get error. It simply ignores the WHERE.
From: George Law [EMAIL PROTECTED]
echo
From: Barry [EMAIL PROTECTED]
Tried: WHERE id = 5 ?
Yes, same trouble 8-(
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to remove the
quotes around '5'
I tried, but didnt work
Or maybe specify where id BINARY = 5;
I tried now, but didnt work
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Maybe it a bug of the php's mysql API?
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Jay Blanchard [EMAIL PROTECTED]
Nope, I do this all of the time.
me too =)
Head on over to the PHP list and post
your code and see what they say.
ok, I'll post there.
Thank you
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
and after the UPDATE
is
the same.
--
-Rows matched: 2 Changed: 0 Warnings: 0-
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
quotes or do you have
magic quotes set to on?
What do you mean with converting the single quotes?
I dont know what is magic quotes, but, from phinfo.php:
magic quotes gpcon on
magic quotes runtime off off
magic quotes sybase off off
Tom
--
MySQL General Mailing List
For list
is updated).
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: 3.23.49.
For windows servers or Linux.
Some Hint?
Thank you
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
', nome_fantasia='cc',estado='24' WHERE id = '5'
Then, I copyied this from browser and executed in the mysql client, And all
worked well. Only in the client, not php. And executed in other clients too,
all working well. Only the php mysql client api behave wrong.
Tom
--
MySQL General Mailing List
Hi
Trying to dump a complete db where 1 of the tables contains about 88
million rows - When the dump runs on the command line the following
error is thrown
mysqldump: Out of memory (Needed 3543176 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when
retrieving data from
Are you using the --quick option?
--quick, -q
This option is useful for dumping large tables. It forces mysqldump to
retrieve rows for a table from the server a row at a time rather than
retrieving the entire row set and buffering it in memory before writing
it out.
thanks both - that did
Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for
pid=20857 comm=mysqld scontext=root:system_r:mysqld_t
tcontext=root:system_r:mysqld_t tclass=process
you have enabled selinux
disable it or learn how to use it correctly
--
MySQL General Mailing List
1 - 100 of 503 matches
Mail list logo
