s: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
**
*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
so I don't really trust myself.
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
naming would replicate.
can i 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://li
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 to
lication only if you use row-based
> replication (or mixed), that means that you must use mysql 5.1.
>
> Greetings,
>
> Mattia.
>
>
> 2010/4/28 Tom Worster :
>> 16.3.1.9. Replication and LIMIT
>> Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELE
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.
http://dev.mysql.com/d
On 4/26/10 7:36 PM, "Gary" 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" .
> "FROM *images A
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" 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 INFILE), i remove t
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" 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 administrators
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
> per 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.
>>
>>
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" wrote:
> Hi:
>
> I want to upgrade a master and slave server from mysql 4.1 to mysql 5.1.
>
> I w
On 1/7/10 3:10 PM, "Matt Neimeyer" 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 auto_increment,
> `Na
On 12/30/09 1:13 AM, "Jeetendra Ranjan"
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
>
> mysqladmin flush-ho
On 12/18/09 12:41 PM, "Douglas Nelson" 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 ask.
> I think 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 arc
lmost ten years but I am not scared 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 12/13/09 11:23 AM, "Neil Aggarwal" 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 think an easi
On 12/14/09 1:49 AM, "Claudio Nanni" 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 unsubscribe:http://lists.my
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" 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 found in an enum of
On 12/4/09 3:14 PM, "Gavin Towey" 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 that
i've e
On 12/4/09 11:59 AM, "Robinson, Eric" 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 sounds like
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" wrote:
>
> Let's face it, sometimes the master and slave get out of sync, even when
>
On 12/2/09 11:13 AM, "David Shere" 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'
On 12/1/09 2:21 PM, "David Shere" 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. Transactions has
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
d 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
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 Kleinpeter wrote:
> Hello,
>
> I've written a fulltext plugin for Mysql 5.1. The
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 lis
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 this
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: http://lis
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 th
t(" ")[0]) % 2
In general, you have to split the string, and test the numerical value
(modulo).
..Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
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
AM
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.
>
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
> 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 I
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 conv
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: mysql@lis
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 N
en do 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:
>
>> [[...]]
>>
>&
not
showing the leading zeroes as part of the column 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:
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 machin
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 machi
Much
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
___
__
I have to do something similar for legacy php 4.2.3 again linked with
mysql 3.23.32.
We do not have the resources to migrate the code to mysql 5 and php 5
so building a mysql3/4 environment on RHEL 5.1 is essential.
Any help gr
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 forget
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
'./devnagios01-
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
'./devnagios01-re
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
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 tha
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 t
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 the
--- [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
> >
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 =
'P
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,
projects.`compl
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 `Search_Code_Sampl
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 sample_type
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 thre
opposed 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.co
67296 byte / 300 byte/day = 1431 days
No issues for about 3 years. 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: http://lists.m
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 t
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 -pxx
hould find 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
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
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 activ
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
When
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 W
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
1146 (42S02):
Table 'test.tablename' doesn't exist.
Does anyone know why my code generated an error? Is this a bug?
Thanks,
Tom
1146 (42S02):
Table 'test.tablename' doesn't exist.
Does anyone know why my code generated an error? Is this a bug?
Thanks,
Tom
d final
part of the commnad, contained the WHERE, to be read.
Thanks very much to all Sherlocks and Watsons who helped me solve it =)
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d final
part of the commnad, contained the WHERE, to be read.
Thanks very much to all Sherlocks and Watsons who helped me solve it =)
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]>
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
ha.com.br/spalha.
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
>
to pay the list =) Beyond mysql I learn English
too?
Well, thank you by the hint, I'll stay alive about this.
Thank you
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
5'
The php and db structure and data are attacheds. Two infos: 1) Im not a
expert 2) 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]
'5'
The php and db structure and data are attacheds. Two infos: 1) Im not a
expert 2) 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]
web host too, with versions
little different (Linux: PHP 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]
fine (only the
right record is updated).
Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
converting the single 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
--
the data before 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]
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://lis
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]
aybe you need 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]
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]
Writing echo
"-".mysql_error()."--".mysql_info()."-";
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 mysql_error()."".
ntes SET tipo='r', 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 clien
x27;. PHP Version: 4.4.2, Mysql client API version: 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]
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 t
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 ser
I have disabled selinux but no luck
how?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 518 matches
Mail list logo
