...@yahoo.com wrote:
thx all, the source data is in text file.
- Original Message -
From: h...@tbbs.net h...@tbbs.net
To: mysql list mysql@lists.mysql.com
Cc:
Sent: Saturday, April 6, 2013 8:02 PM
Subject: Re: update a row only if any column has changed, in a very large
table
2013
hello,
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once everyday. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or deleted?
i can use update_or_create
-
From: Rajeev Prasad [mailto:rp.ne...@yahoo.com]
Sent: Saturday, April 06, 2013 3:57 PM
To: mysql list
Subject: update a row only if any column has changed, in a very large table
hello,
I have a table with around 2,000,000 records (15 columns). I have to sync
this from an outside source once
2013/04/06 13:56 -0700, Rajeev Prasad
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once every day. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or deleted
thx all, the source data is in text file.
- Original Message -
From: h...@tbbs.net h...@tbbs.net
To: mysql list mysql@lists.mysql.com
Cc:
Sent: Saturday, April 6, 2013 8:02 PM
Subject: Re: update a row only if any column has changed, in a very large table
2013/04/06 13:56 -0700
- Original Message -
From: Peng Yu pengyu...@gmail.com
Suppose I have two servers (one on mac and one on ubuntu), at any
time I only change one server but not both servers. After I have done
I think that probably it is OK to synchronize these two servers at
the database file level
As Johan describes, replication is the way. If that's not an option due to
connectivity between the hosts you could arrange for a logical dump to be
copied and restored. I would certainly opt for replication in your
situation.
A
On Tue, Oct 18, 2011 at 7:02 AM, Johan De Meersman
Hi,
There are some webpages on synchronizing two mysql server, some of
them are old and some of them are for situations that are not exactly
same as mine. So I ask how to syncrhonize two mysql servers again and
hope to get the best solution to my particular requirement.
Suppose I have two
This is a correct description of behaviour. Did you have a question ? :-)
On Fri, Sep 17, 2010 at 5:52 AM, win.a win@gmail.com wrote:
I fond my mysql db os time was not correct so i sync with ntpdate
,when testing my app which depend on the date was not the current os
time .After
I fond my mysql db os time was not correct so i sync with ntpdate
,when testing my app which depend on the date was not the current os
time .After restarting Mysql ,the app goes well.
All you best
What we are struggling for ?
The life or the life ?
--
MySQL General
Changed limits: max_open_files: 2048 max_connections: 1024 table_cache:
507
I'm getting the below warning in my event viewer:
Changed limits: max_open_files: 2048 max_connections: 1024 table_cache:
507
How can i slove it.
Thanks in advance.
Thanks for all of you. I will test the suggestions and then reply.
CPK
--
Keep your Environment clean and green.
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any other idea
?? ,
field_2 ??,
...
field_n ??
I don't know a way of copying over every field accept long-hand in the
triggers.
Hope this is useful...
Ben
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any
CK,
How can we manage the history of changed rows in the database.
Point-in-time architecture. For a bit of discussion see
http://www.artfulsoftware.com/infotree/tip.php?id=547
PB
-
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea
On Fri, Apr 18, 2008 at 8:13 AM, Peter Brawley [EMAIL PROTECTED]
wrote:
CK,
How can we manage the history of changed rows in the database.
Point-in-time architecture. For a bit of discussion see
http://www.artfulsoftware.com/infotree/tip.php?id=547
PB
I have used this convention
Subject: changed directory name
Hi guys,
Im really new to this (I only have html background) so if im asking stupid
q's please bare with me.
I changed my open reallty file name to extreme, when I try to
load the file
http://localhost/Extreme/admin/index.php in explorer and I keep on getting
Hi guys,
Im really new to this (I only have html background) so if im asking stupid
q's please bare with me.
I changed my open reallty file name to extreme, when I try to load the file
http://localhost/Extreme/admin/index.php in explorer and I keep on getting
these errors, I think I have
I have a number of database administration shell scripts which construct
into a temp file sequences of mysql commands AND comments (in a specific
custom format with @log-xxx@ codes) like these
/* @log-action@ DATE UPDATE of all correlations for table NAME */
select concat(now(),' UPDATING ALL
it to work incrementally. The idea is to run it from
cron every 5 minutes and process the data from the last 5 minutes.
The problem I'm having is identifying which rows have changed. I'm
not concerned about deletes in this application, so I thought it would
be enough to just use automatic
of the data is making that impossible,
and there is a desire for the process to operate in near real-time, so
I'm rewriting it to work incrementally. The idea is to run it from
cron every 5 minutes and process the data from the last 5 minutes.
The problem I'm having is identifying which rows have changed
On 5/30/07, Dan Buettner [EMAIL PROTECTED] wrote:
#1 - it's not a good approach to hope your database keeps up. There are
fairly common situations that can come up where you never know how long
something will take - unusually high traffic, table check and repair, a bulk
load into the same or
Bgs a écrit :
Greetings,
We have regular problems with mysql replication when there is a db
change. This is mostly ALTER TABLE. The sync breaks and we either have
to do the changes manually or either shut down the whole system for a
new sync from zero. Is there a way to sync alter table
Greetings,
We have regular problems with mysql replication when there is a db
change. This is mostly ALTER TABLE. The sync breaks and we either have
to do the changes manually or either shut down the whole system for a
new sync from zero. Is there a way to sync alter table commands on the
one changed row
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql update table1 set field2=3 where field1=1; -- The same update
should return 0 rows
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
The second update
character_set_resultsgbk
character_set_server gbk
after a long while, like one night, I found the client character set have
been changed to latin,
character_set_client latin1
character_set_connection
My programm connect to MYSQL server, adn set it's charactor set by set
NAMES gbk, after a long while, like
one night, I found the client charactor set have been changed to latin, it
seems related to some timeout value.
why the characotor set would be changed? My programm use MYSQL C API
libmysqlclient.so.15), I
tried to see if I could connect with Use DBI; anyway, with the old DBD
drivers. And I can. So, my question is, how is this possible?? I thought
headers had changed (and should have, significantly, between 4.0.26 and
5.0.24a). And that the BDB::mysql drivers abolutely need
Mike,
Oracle Corp. and MySQL AB renewed the InnoDB OEM contract in spring
2006. The licensing of InnoDB is the same as before and it is
distributed in the official MySQL distros.
Best regards,
Heikki Tuuri
CEO of Innobase Oy
VP of Oracle Corporation
Has Oracle placed any
Has Oracle placed any restrictions on using InnoDb and MySQL now that the
original MySQL AB license has expired with Heikki??
What is the name of the new MySQL transaction engine and is anyone using
it? Is it any good?
TIA
Mike
--
MySQL General Mailing List
For list archives:
Hi all... i'm developing an aplication and i'm need to use begin,
commit, rollback, but when i try to use rollback i get a warning
| Warning | 1196 | Some non-transactional changed tables couldn't be
rolled back |
this is what i did
mysql begin;
Query OK, 0 rows affected (0.00 sec)
mysql
obed wrote:
Hi all... i'm developing an aplication and i'm need to use begin,
commit, rollback, but when i try to use rollback i get a warning
| Warning | 1196 | Some non-transactional changed tables couldn't be
rolled back |
Transactions only work for table types that support them. MyISAM
MYSQL wrote:
Hi,
I recently updated to version 4.1.2 from a slightly older one like
4.1.11 or something. But I am now having a problem.
Before,this query would work fine:
Select distinctrow * from mytable order by mydatecolumn.
mydatecolumn is a column of type date.
This used to return
Hi,
I recently updated to version 4.1.2 from a slightly
older one like 4.1.11 or something. But I am nowhaving
aproblem.
Before,this query would work fine:
Select distinctrow * from mytable order by
mydatecolumn.
mydatecolumn is a column of type date.
This used to return the records in
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for compatibility
starting MySQL..changed Data Directory
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password
Hi,
We would like to upgrade our current installation of Mysql 4.0.x to 4.1 to be
able to switch fastly to the MySQL Cluster Solution.
The problem is, that we were using the TIMESTAMP type quite heavily in the
SELECTS, and we splitted the result using for example,
substring in php, so we
Dear mySQl community,
In the following I do not only list a problem, others might also run in,
but I also want to point out a stangeness of one of your fixes.
Recently there was a change in 3.23.49 (on Debian/Woody):
* Applied patch for a bug that wrongly interpreted '_' in
conjunction
Hello,
I am currently looking at moving some of my FoxPro tables to a MySQL
implementation and I am hoping someone can help me with how to do the
following.
In my current code, whenever anyone makes a change to a row the original
value of the row is written to a history table with the same name
It sounds like you are looking to do an INSERT SELECT.
http://dev.mysql.com/doc/mysql/en/insert-select.html
It allows you to insert into one table based on a select from another
table. That will take care of creating your history. You then need to
do an update on the main table. It's still a two
reloaded, checked formatting and done
various other things without success. Then I went to the text (*.sql)
file in which I had dumped the mysql table, manually changed the
number to 16996941 and put the text file on the server. However, the
number that showed up on the web page table
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 06 April 2005 02:31
To: mysql@lists.mysql.com
Subject: Changed Number
I have loaded a large *.csv spreadsheet into mysql and one number, the
grand total, changes from 16996941 on the Excel spreadsheet to 8388607 in
the mysql database. The numbers surrounding
things without success. Then I went to the text (*.sql) file in which I
had dumped the mysql table, manually changed the number to 16996941 and
put the text file on the server. However, the number that showed up on
the web page table and the number in the database on the server is
8388607
To: mysql@lists.mysql.com
Subject: Changed Number
I have loaded a large *.csv spreadsheet into mysql and one number, the
grand total, changes from 16996941 on the Excel spreadsheet to 8388607 in
the mysql database. The numbers surrounding this number are correct at
all stages. I have reloaded
Maybe a review of http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html
will help?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:31 PM
To: mysql@lists.mysql.com
Subject: Changed Number
I have loaded a large *.csv spreadsheet
have reloaded, checked formatting and
done various other things without success. Then I went to the text
(*.sql) file in which I had dumped the mysql table, manually changed
the number to 16996941 and put the text file on the server. However,
the number that showed up on the web page table
Hello.
SHOW STATUS usually helps others to give you a good advice. I think
you should send the output of this statement to the list. Why have you
changed the type of engine? Did it gave you a great performance hit?
Thomas Lekai [EMAIL PROTECTED] wrote:
We finally split our huge
We finally split our huge logging aspect of an application to its own system,
and we changed the table type from InnoDB to MyIsam. This is a logging table,
1 log writer, many, many selects from customer care reps looking up the last
500 or so records. These are logs of timed events, so
A little off topic, sorry, but I am wondering if anyone has any good
Mac Web Dev resourses that i may find useful. Right now I am trying to
figure out how to install mySQL to get my local dev setup and any
pointers would be appreciated.
Thanks
Wikki
--
MySQL General Mailing List
For list
Things are pretty much the same for the Mac as any other Unix platform,
so there aren't too many sites out there that will give you Mac
specific stuff. Any instructions for Unix/Linux are pretty much the
same for the Mac, except for the darn path differences between Unix
platforms. You should
On Mon, 15 Nov 2004, Patrick Galbraith wrote:
William,
I'm not sure about this, because it involves windows/active state, and
those ppm packages used for active state perl are pre-compiled to run.
I'll talk to the current maintainer about this and see if he knows
about how active state
Rudy Lippan wrote:
On Mon, 15 Nov 2004, Patrick Galbraith wrote:
William,
I'm not sure about this, because it involves windows/active state, and
those ppm packages used for active state perl are pre-compiled to run.
I'll talk to the current maintainer about this and see if he knows
about how
Michael Stassen said:
Rudy Lippan wrote:
On Mon, 15 Nov 2004, Patrick Galbraith wrote:
William,
I'm not sure about this, because it involves windows/active state, and
those ppm packages used for active state perl are pre-compiled to
run. I'll talk to the current maintainer about this
I've been googling for 1/2 hr w/o any answers. sorry if I've missed the
obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not support authnticaiton protocol
DBI connect('cjuhsdinfo','{username}',...) failed: Client does not support
authentication
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed the
obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not support authnticaiton protocol
What version of MySQL were you using previously? If it was
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not support authnticaiton protocol
What version of MySQL were you using
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql via ppm.
Client does not
Mark Matthews said:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
Keith Ivey said:
William R. Mussatto wrote:
I've been googling for 1/2 hr w/o any answers. sorry if I've missed
the obvious.
Problem. Fresh install of mysql 4.7.1, AS perl 5.8
DBI and DBD-Mysql
Patrick Galbraith said:
William,
What was the error that you had specifically? Did you use a precompiled
version of DBD::mysql like a RPM, or did you build it yourself? I don't
know if this is a DBD version issue that you are experiencing, because
nothing was changed in authentication
Sometimes,my php program query the mysql using SELECT.
And I got this error,
mysql error: Record has changed since last read in table 'table'
mysql error number: 1020
The table is HEAP type,and this error will appear sometimes.
Not always.
Why did me get this error?Any suggestion?
I am using
Stefan Klopp [EMAIL PROTECTED] wrote:
We recently upgraded our mysql server from 3.23 to 4.0.18 and have found
that all of our Unicode characters are now being displayed as question marks
(?). Anyway this only happens when viewing over the web as when we view via
the shell mysql we can see
You were managing unicode characters with mysql 3.23?
It was just storing and retrieving the data then?
Because mysql can really manage unicode in 4.1 version, isn't it?
Stefan Klopp wrote:
Hello All,
We recently upgraded our mysql server from 3.23 to 4.0.18 and have found
that all of our Unicode
Hello,
(B
(BI had checked the variables on both the 3.23 and 4.0.18 and they both show
(Bthe exact same character sets. Nothing appears to have changed with our data
(Bin the tables or the setting of the server.
(B
(BHere is what the show variables reports:
(B
(B| character_set
: [EMAIL PROTECTED]
Sent: Thursday, July 22, 2004 12:46 AM
Subject: Re: after upgrade unicode characters changed to question marks
You were managing unicode characters with mysql 3.23?
It was just storing and retrieving the data then?
Because mysql can really manage unicode in 4.1 version, isn't
Hello All,
We recently upgraded our mysql server from 3.23 to 4.0.18 and have found
that all of our Unicode characters are now being displayed as question marks
(?). Anyway this only happens when viewing over the web as when we view via
the shell mysql we can see the characters fine. In addition
Hi!
terence == terence [EMAIL PROTECTED] writes:
terence Dear All,
terence Has the alpha release mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz
terence changed since April 12 2003? Just want to save myself a few hours
terence downloading...
terence I am putting it into production shortly
Dear All,
Has the alpha release mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz
changed since April 12 2003? Just want to save myself a few hours
downloading...
I am putting it into production shortly, and was wondering too if there's
any news on the stable release of the same?
Thanks
Terence
Terence [EMAIL PROTECTED] wrote:
Has the alpha release mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz
changed since April 12 2003? Just want to save myself a few hours
downloading...
4.1.1 will be released in September.
I am putting it into production shortly, and was wondering too
Is it possible to duplicate a record in a table into the same table with a changed
field? I have a single user who now has authority over an additional database. I
wanted to duplicate the records in myslq.db for this user, changing the Db field to
the name of the additional database.
I
success or fatal error' on query ''
I always have to copy the whole DB to the slave and start the
replication all over.
Am I doing something wrong?
The binlog format has changed, yes.
I suggest that next time you make sure your slaves are up-to-date and
flush the binlog on the master. That'll allow
Hello list,
when upgrading the master in a master slave setup from 3.23.x to 4.0.x or
downgrading back to 3.23.x the binlog seems to be corrupt for the slaves.
I get error messages like binlog truncated or 'unexpected success or fatal
error' on query ''
I always have to copy the whole DB to the
' on query ''
I always have to copy the whole DB to the slave and start the
replication all over.
Am I doing something wrong?
The binlog format has changed, yes.
I suggest that next time you make sure your slaves are up-to-date and
flush the binlog on the master. That'll allow it to start
address changed. Is this something that is stored in the mysql database?
If so, how so I change that? I'd rather not have to rerun mysql_install_db.
- chris
-
Before posting, please check:
http://www.mysql.com/manual.php
PM
Subject: my host IP changed
I just got mysql up and running (I'm a new user). I'm using it with
ColdFusionMX.
Just as I was about to bind a database to coldfusion, my IT department
decided to move my server to a new IP address.
Now I can't get a database to bind to coldFusion and I'm
]
[EMAIL PROTECTED]
- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 9:22 PM
Subject: my host IP changed
I just got mysql up and running (I'm a new user). I'm using it with
ColdFusionMX.
Just as I
14, 2002 11:47 AM
To: Chris Walcott; Mysql-L (E-mail)
Subject: Re: my host IP changed
Hi,
It's possible that in mysql.user table to exist the old IP
address of your
machine.You should check the field Host using:
use mysql;
select Host,User from user where User='YOUR_USER_NAME
PROTECTED]
- Original Message -
From: Chris Walcott [EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; Chris Walcott
[EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 9:52 PM
Subject: RE: my host IP changed
right now the host field has 2 entries
PROTECTED]
Sent: Thursday, November 14, 2002 2:05 PM
Subject: Re: my host IP changed
Yes.You can put the new IP address instead of the name (no localhost).When
you make update, you must be sure that YOU DON'T REPLACE and the record
where the Host field is 'localhost'.You must replace only
Hello,
I think that my problem boils down to the unimplemented getWarnings() method
in the mm. JDBC driver. If it was implemented, I could detect if the data
was e.g. truncated. Can anybody help me find an implementation for this
method?
Thank you again,
Charlie
Hi.
:I'd like to find out
- Original Message -
From: Charlie Thunderberg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 8:23 AM
Subject: RE: No Warnings after changed data
Hello,
I think that my problem boils down to the unimplemented getWarnings()
method
in the mm. JDBC driver
Hi All,
I'd like to find out how I could convince mysql to generate warnings
whenever the data I want to insert is modified by the server.
E.G. CREATE TABLE test (value real);
INSERT INTO test VALUES ('a1');
I am programming in JAVA using JDBC.
Thanks for any answers!
Charlie
On Sat, 8 Jun 2002, Charlie Thunderberg wrote:
Hi.
:I'd like to find out how I could convince mysql to generate warnings
:whenever the data I want to insert is modified by the server.
I believe there's no built-in way of doing that.
I keep a checksum of a data stored. And when i want to
I changed servers and now nothing works at all.
I am bright green to cgi and mysql and just purchased this site last month.
What is the recommended checklist I can check out to see where the problem is..
I need to get this all working asap before my hair turns green too.
Thank you all in advance
. Some values may have been changed since it was
last read
i can paste the code if this helps.
Thanks in advance.
Regards,
Nabil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
All of a sudden Apache and MySQL are not running correctly under Windows 98.
It appears that somehow localhost was changed from 127.0.0.1 to something else.
Could the fact that I NOW have a 24/7cable connection to the Net cause the
problem?
Thanks!
Anthony Rodriguez
([EMAIL PROTECTED
PROTECTED]]
Envoye : mercredi 27 fevrier 2002 15:58
A : [EMAIL PROTECTED]
Objet : Changed localhost?
All of a sudden Apache and MySQL are not running correctly under Windows 98.
It appears that somehow localhost was changed from 127.0.0.1 to something
else.
Could the fact that I NOW have a 24
Anthony,
Wednesday, February 27, 2002, 4:58:09 PM, you wrote:
AR All of a sudden Apache and MySQL are not running correctly under Windows 98.
AR It appears that somehow localhost was changed from 127.0.0.1 to something else.
No, localhost is 127.0.0.1
What type of error did you recieve?
AR
System = Linux 2.5.1
ARCH:i686-pc-linux-gnu
1. I changed the global.h file to include signal.h since if signal.h is
included after global.h I get an error with __sighandler_t. You should
change your configuration.
2. I had to install autoconf 2.13 since your autoconf scripts dont work
I had a column that was set to varchar(50) which ended up not being enough
space. So I went in and did a:
alter table main change description description varchar(255) not null;
It said everything went ok, I reimported the text file, but the words stop
after 50 characters still did I miss
You are expecting an awfull lot from mysql to remember data that it never
recorded. When you inserted something into the varchar(50) column that was
longer than 50 it dropped the rest of the string that would not fit.
Changing the column size will not bring back the data.
ryan
I had a column
Floats are inexact. If you want exact try the numeric data type. Its
stored as a character.
On Sat, 17 Feb 2001, Xi Jiang (ITSPORTSNET) wrote:
Date: Sat, 17 Feb 2001 21:05:25 -0700
From: Xi Jiang (ITSPORTSNET) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: float value is changed
Dear all,
I have a field defined as float (16,0). When I insert 99 (10 9s) into the
table, it changed it's value to 100(1 and 10 0s). It also change some other
inserted values.
Does anybody have any idea what the reason causing it? And how can I fix that?
Thanks
93 matches
Mail list logo