Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Adarsh Sharma
Dear all, I want to convert some tables from Mysql database to Postgresql Database in Linux Systems ( Ubuntu-10.4, CentOS ). Can someone Please tell me tool for it that makes it easier. I am able to done it through FW tools in Windows System but i want to achieve it in Linux ( CentOS )

Re: Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Jaime Crespo Rincón
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

Re: Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Dhaval Jaiswal
By default Postgresql database encoding in UTF8. It seems to me by seeing error that database encoding in mysql is different from it. -- Cheers, Dhaval Jaiswal On 01/03/2011 3:57 PM, Adarsh Sharma wrote: Dear all, I want to convert some tables from Mysql database to Postgresql

Newbie question: Association table and Foreign Key

2011-03-01 Thread Wagyu Beef
Hey guys, Am a newbie here and need a little help. Part of the database consists of two tables events and categories which look like this +---+-+ | eventID | eventName | +---+-+ | 1

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread Dhaval Jaiswal
Just curious as it is not mentioned. Can Category ID also have multiple event id ? -- Cheers Dhaval Jaiswal On 01/03/2011 5:53 PM, Wagyu Beef wrote: Hey guys, Am a newbie here and need a little help. Part of the database consists of two tables events and categories which look like this

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread Wagyu Beef
Oh yeah, forgot to mention that. Yes, one event will have multiple categories. And one category can be applicable to multiple events. On Tue, Mar 1, 2011 at 8:33 PM, Dhaval Jaiswal jaiswal.dha...@enzenglobal.com wrote: Just curious as it is not mentioned. Can Category ID also have multiple

Convert unix time to 12:00 AM of that same day

2011-03-01 Thread Bryan Cantwell
I'd asked before how to convert a unix timestamp to the hour that it is in (and got the perfect answer) : 1298999201 = 3/1/2011 11:06:41 AM (1298999201 - (1298999201 % 3600)) = 3/1/2011 11:00:00 AM Now getting the timestamp converted to midnight of that same day isn't as simple as: 1298999201

Re: Convert unix time to 12:00 AM of that same day

2011-03-01 Thread Claudio Nanni
You can start by using 60*60*24=86400 ;) On Mar 1, 2011 6:17 PM, Bryan Cantwell bcantw...@firescope.com wrote: I'd asked before how to convert a unix timestamp to the hour that it is in (and got the perfect answer) : 1298999201 = 3/1/2011 11:06:41 AM (1298999201 - (1298999201 % 3600)) =

Re: Convert unix time to 12:00 AM of that same day

2011-03-01 Thread Bryan Cantwell
It was of course a typo, and even with the correct number isn't the answer On 03/01/2011 11:47 AM, Claudio Nanni wrote: You can start by using 60*60*24=86400 ;) On Mar 1, 2011 6:17 PM, Bryan Cantwell bcantw...@firescope.com mailto:bcantw...@firescope.com wrote: I'd asked before how to

Re: Convert unix time to 12:00 AM of that same day

2011-03-01 Thread Johnny Withers
You could use: CONCAT(DATE_FORMAT(FROM_UNIXTIME(1298999201),'%Y-%m-%d'),' 12:00:00') JW On Tue, Mar 1, 2011 at 11:58 AM, Bryan Cantwell bcantw...@firescope.comwrote: It was of course a typo, and even with the correct number isn't the answer On 03/01/2011 11:47 AM, Claudio Nanni wrote:

Re: versions 5.1, 5.5

2011-03-01 Thread András Lukács
From the command line there was no way to run mysql.exe I may be dwelling on the obvious, but have you checked the place MySQL system libraries in the system path (or something similar) checkbox on install? v5.5.9 runs fine with me on Win7. -- MySQL General Mailing List For list archives:

Re: Question about performance

2011-03-01 Thread András Lukács
Or you can interrupt the query instead, although I've seen it not to work on occasions: KILL QUERY id; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Convert unix time to 12:00 AM of that same day

2011-03-01 Thread Bryan Cantwell
SELECT unix_timestamp() + 86400 + (unix_timestamp() % 86400); currently gives me 6:39 AM tomorrow SELECT UNIX_TIMESTAMP(DATE(FROM_UNIXTIME(1299003702))); actually gives me what I want, but seems really stupid way of getting something that is probably very simple On 03/01/2011 12:03

Re: Convert unix time to 12:00 AM of that same day

2011-03-01 Thread Bryan Cantwell
That's closer: SELECT UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400); Gives me 6:00 PM today... On 03/01/2011 12:32 PM, Singer X.J. Wang wrote: SELECT unix_timestamp() + 86400 - (unix_timestamp() % 86400); -- -- MySQL General Mailing List For list archives:

Re: Convert unix time to 12:00 AM of that same day

2011-03-01 Thread Joerg Bruehe
Hi Bryan, all! Bryan Cantwell wrote: That's closer: SELECT UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400); Gives me 6:00 PM today... The Unix timestamp is UTC-based (old name: GMT). You don't write which timezone you are using, but your notation 6:00 PM makes me assume you are

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread S�ndor Hal�sz
2011/03/01 20:23 +0800, Wagyu Beef Part of the database consists of two tables events and categories which look like this +---+-+ | eventID | eventName | +---+-+ | 1 | Event A