2011/3/1 Adarsh Sharma adarsh.sha...@orkash.com:
Dear all,
I want to convert some tables from Mysql database to Postgresql Database in
Linux Systems ( Ubuntu-10.4, CentOS ).
[...]
invalid byte sequence for encoding UTF8: 0xe3ba27
HINT: This error can also happen if the byte sequence does
2011/2/22 Adarsh Sharma adarsh.sha...@orkash.com:
Dear all,
Today I need to back up a mysql database and restore in Postgresql database
but I don't know how to achieve this accurately.
Have a look at: mysqldump --compatible=postgresql command:
2011/2/22 Joerg Bruehe joerg.bru...@oracle.com:
You have not understood the concept of NULL in SQL:
NULL does not mean empty, it means unknown.
[...]
Apart form fully agreeing with Joerg, just a tip:
you can use the the IFNULL() operand as a workaround:
2011/1/21 Jerry Schwartz je...@gii.co.jp:
-Original Message-
From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Sent: Friday, January 21, 2011 12:47 PM
To: mysql@lists.mysql.com
Subject: Re: CURRENT insert ID
Ok, you must have your own reasons to do that.
The fact is: You
2011/1/20 swagat.le...@accenture.com:
Hi,
I lack on knowledge about Informatica software. But if you are
really sure that the problem is not on source data and not on backend
configuration, then it is just in the middle. :-)
I will be more specific (at least, as far as I can be). In a MySQL, a
2010/8/23 Manasi Save manasi.s...@artificialmachines.com:
Dear All,
I need to install MySQL 5.1.42 on ubuntu. MySQL site does not have installer
packages for ubuntu(.deb).
If I need to use tar.gz is there any document available which will help me
do this specific changes.
Follow the
2010/8/12 Nunzio Daveri nunziodav...@yahoo.com:
Hi Guifre, thanks for answering. I already have mysql installed and works
just
fine, but I did untar and then go to folder and run. I used what is called
mysql no-install so no yum, rpm etc.. No files in /etc/init.d and no startup
or
2010/6/30 Tompkins Neil neil.tompk...@googlemail.com:
Hi
Just one other question. With regards the replication in MySQL 5.1 - does
it it replication the whole row of data or just the field in which the data
has been changed for the current record ?
MySQL 5.1 supports two replication
2010/6/24 Tompkins Neil neil.tompk...@googlemail.com:
HI,
We have set-up MySQL Community Server 5.1.46 with Master to Slave
replication and everything appears to be working correctly, however I have a
couple of questions which I hope somebody can shed some light.
(1) When the network
2010/6/24 Tompkins Neil neil.tompk...@googlemail.com:
Hi
Regarding two-way replication what do you mean by very
controlled environment ? What things do I need to consider ?
Control at application level that you are not going to
insert/update/delete the same record on the two servers.
Even if
2010/6/4 Jesse F. Hughes je...@phiwumbda.org:
Is it possible to build a .MYI file from scratch?
I have found a file that I believe is recorded.MYD. I have the .frm
file as well, but I don't think that recorded.MYI survived the
file system event.
Yes, the mysql utility myisamchk and the
2010/1/25 Yang Zhang yanghates...@gmail.com:
Right, I saw the docs. I'm fine with creating an index on it, but the
only way I've successfully created a table with auto_increment is by
making it a primary key. And I still don't understand why this
requirement is there in the first place.
2010/1/25 John G. Heim jh...@math.wisc.edu:
I have a server with 16Gb of RAM and a dual-core 2Ghz processor. It is
running the latest mysql-server from debian lenny (5.0.1). I have databases
for drupal, moodle, spamassassin, horde3, and a small database for
departmental stuff.
The problem
2009/12/23 Ryan Chan ryanchan...@gmail.com:
Hey.
Back to few years ago, InnoDB require table level locking when
inserting auto-increment PK to the table, and Heikki said there will
be a fix.
Is this problem still exist now?
If you refer to this bug:
http://bugs.mysql.com/bug.php?id=16979
El día 22 de diciembre de 2009 13:44, Miguel Angel Nieto
cor...@miguelangelnieto.net escribió:
It depends a lot on how you plan to coordinate the db servers
(sharding, replication, ndb), the kind of applications you are going
to deploy and how much scability you need.
Thank you. I have read
2009/12/21 Miguel Angel Nieto cor...@miguelangelnieto.net:
Hi,
I am searching fot a Mysql Load Balacing tool. I read about mysql
proxy, sqlrelay, haproxy...
What do you prefer?
Hi,
The solutions I have heard most from our customers (in production) are
not mysql-specific:
1) Simple, not
2009/12/11 Yang Wang yw...@lfm-agile.com.hk:
Hi,All
The version of 5.1 include microtime slow query patch?
As of MySQL 5.1.21, the minimum value is 0, and a resolution of
microseconds is supported when logging to a file.
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
Regards,
--
2009/11/24 Johan De Meersman vegiv...@tuxera.be:
If you are wondering about parallel query execution (that is, splitting a
single query over multiple cores for faster execution), that is currently
not supported by MySQL.
[offtopic]
Probably is something stupid, but could that be done with ndb
Not an expert, but:
2009/11/14 Krishna Chandra Prajapati prajapat...@gmail.com:
I would like to know how optimize table work internally. A table contains
200 millions records. Whether query performance will be faster after
deletion of 30 million records from this table or not.
Use of OPTIMIZE
2009/11/8 Andrew Tran aochi...@gmail.com:
I want to find the first occurrence of Andrew, but also the
neighboring rows (like the two rows above the first Andrew and the
There is a conceptual issue with what you are trying to accomplish.
What are the rows above and below?
According to relational
2009/10/29 Michael Dykman mdyk...@gmail.com:
mysqldump is not really a data manipulation tool.. as the name
implies, it is a dumper.
What you are trying to accomlish can be done rather elegantly via the
SELECT .. INTO OUTFILE syntax
2009/10/26 Jeff j...@platinumsynergy.com:
Perhaps case is the way to go, I'll look into that this morning.
Unfortunately there are three groupings. So my IF or CASE needs to check for
example:
if timezone = 3,5,6,7 then 1
if timezone = 1,2,4 then 2
if timezone = 8,9 then 3
Yes, Case
2009/10/23 Jeff j...@platinumsynergy.com:
I currently have a query like so:
SELECT p.fldId, p.fldFName, p.fldLName, p.fldEmail, p.fldPhone, p.resellerId,
d.timezoneId, d.bestTime, d.lastDate, d.lastTime, d.lastConnected FROM
tblProspects as p LEFT JOIN tblProspectsDetails as d ON
2009/10/7 Brown, Charles cbr...@bmi.com:
Hello All. I would like to implement MYSQL slow query log in table. Can
someone kindly assist me with the table definition and implementation.
SHOW CREATE TABLE mysql.slow_log;
http://dev.mysql.com/doc/refman/5.1/en/log-tables.html
--
Jaime Crespo
24 matches
Mail list logo