Re: Tool for shifting tables from Mysql to Postgresql

2011/3/1 Adarsh Sharma : > 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 not match the > enc

Re: contact gives empty result

2011/2/22 Joerg Bruehe : > 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:

Re: Mysql to Postgresql

2011/2/22 Adarsh Sharma : > 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:

Re: Loading Unicode Data to mySQL

2011/1/20 : > 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 charset is negotiated o

Re: How to unstall MySQL 5.1 on Ubuntu 8.04 LTS

2010/8/23 Manasi Save : > 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 official guide: http://dev.mysql.com

Re: RHEL Auto Start / stop mysql???

2010/8/12 Nunzio Daveri : > 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 > services script since

Re: MySQL Replication

2010/6/30 Tompkins Neil : > 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 formats: row and statement-base

Re: MySQL Replication

2010/6/24 Tompkins Neil : > 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 MySQL gives some suppo

Re: MySQL Replication

2010/6/24 Tompkins Neil : > 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 connection goes down between

Re: Missing database file names

2010/6/4 Jesse F. Hughes : > 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 REPAIR command

Re: optimization

2010/1/25 John G. Heim : > 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 is that insert

Re: auto_increment without primary key in innodb?

2010/1/25 Yang Zhang : > 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. Non-primary key works fo

Re: mysql load balancing

El día 22 de diciembre de 2009 13:44, Miguel Angel Nieto 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 about LVS and keepali

Re: Table level locking when inserting auto-increment PK to InnoDB

2009/12/23 Ryan Chan : > 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: there is a m

Re: mysql load balancing

2009/12/21 Miguel Angel Nieto : > 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 load-aware *DNS balancin

Re: different 5.0 and 5.1 about long_query_time

2009/12/11 Yang Wang : > 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, -- Jaime Crespo MyS

Re: How normal mysql server 5.1 uses multiple cores

2009/11/24 Johan De Meersman : > 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 cluster on a sin

Re: OPTIMIZE TABLE

Not an expert, but: 2009/11/14 Krishna Chandra Prajapati : > 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 TABLE varies from

Re: Find neighboring rows

2009/11/8 Andrew Tran : > 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 theory,

Re: Choose certain columns in mysqldump?

2009/10/29 Michael Dykman : > 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 > >                    http://dev.mysql.com/doc/refman/5.1/en/select.html

Re: Using IF in a query to set a variable then sort on said variable

2009/10/26 Jeff : > 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 function is the way t

Re: Using IF in a query to set a variable then sort on said variable

2009/10/23 Jeff : > 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 d.prospectId = > p.fldId WHER

Re: MYSQL slow query log in table.

2009/10/7 Brown, Charles : > 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; -- Jaime Crespo MySQL & Java