*** dyki has quit IRC | 01:00 | |
*** Alex| has quit IRC | 02:59 | |
*** Alex| has joined #ingres | 03:48 | |
*** ChanServ sets mode: +o Alex| | 03:48 | |
*** Alex| has quit IRC | 03:49 | |
*** Alex| has joined #ingres | 03:49 | |
*** ChanServ sets mode: +o Alex| | 03:49 | |
*** Alex| has quit IRC | 04:16 | |
*** rossand has joined #ingres | 04:22 | |
*** ChanServ sets mode: +o rossand | 04:22 | |
*** ultrav1olet has joined #ingres | 04:52 | |
ultrav1olet | I have installed Ingres 10 on Linux. What's the easiest way to import MySQL DB? | 04:52 |
---|---|---|
*** ultrav1olet has quit IRC | 05:09 | |
*** ultrav1olet has joined #ingres | 05:10 | |
ultrav1olet | I have installed Ingres 10 on Linux. What's the easiest way to import MySQL DB? | 05:10 |
bonsaikitten | ultrav1olet: that'll be fun | 05:49 |
bonsaikitten | you can motivate mysql to create a plaintext dump, which you could then massage until it can be imported by ingres | 05:50 |
bonsaikitten | but there will be lots of pain in the process because what mysql thinks is "SQL" and what everyone else uses is slightly different | 05:50 |
atrofast | Yeah MySQL is notorious for not following standards :P | 05:55 |
atrofast | PostgreSQL <-> Ingres is easier | 05:55 |
bonsaikitten | why would you do that? ;) | 05:57 |
atrofast | Just saying it can be done easier, not that it should be done ;) | 05:57 |
bonsaikitten | :) | 05:57 |
atrofast | If Ingres was off the table, I'd take Postgres over MySQL any day | 05:58 |
bonsaikitten | well, you want a DB, right? | 05:58 |
bonsaikitten | so mysql doesn't qualify ;) | 05:58 |
atrofast | Haha | 05:59 |
bonsaikitten | MyISAM is a nice game, and InnoDB ... wuargh. Not funny. | 05:59 |
*** mull has joined #ingres | 06:42 | |
*** Alex| has joined #ingres | 06:49 | |
*** ChanServ sets mode: +o Alex| | 06:49 | |
*** Alex| has quit IRC | 07:19 | |
*** Dejan has joined #ingres | 07:37 | |
Dejan | hi everybody | 07:37 |
*** Dejan has quit IRC | 07:55 | |
*** Dejan has joined #ingres | 08:28 | |
* Dejan is back | 08:28 | |
Dejan | question: what is the easiest way to rename a PK field in a table? | 09:09 |
Dejan | drop table, make a new one and then copy? | 09:09 |
grantc | at the moment that is the only option | 09:19 |
grantc | alter table rename column is in the pipe line | 09:19 |
Vroomfondle | woohoo, looks like we might *finally* move to 9.2 next week | 09:19 |
grantc | http://community.ingres.com/wiki/Tables_Columns_Rename | 09:20 |
grantc | Vroomfondle: just as 9.2.1 comes out? :) | 09:20 |
Vroomfondle | unfortunately it took a catastrophic failure in our 2.6 system to precipitate this | 09:20 |
Vroomfondle | but, meh, all's well that ends well I guess | 09:20 |
Vroomfondle | grantc: heh, naturally | 09:20 |
*** DerMeister has joined #ingres | 09:32 | |
Dejan | it is actually more tricksy... | 09:33 |
Dejan | because the colum is an identity column... | 09:33 |
Dejan | khm... | 09:33 |
*** Alex| has joined #ingres | 09:37 | |
*** ChanServ sets mode: +o Alex| | 09:37 | |
*** pboro has quit IRC | 09:57 | |
Dejan | i cannot wait RENAME TABLE|COLUMN to be in Ingres... | 09:59 |
*** pboro has joined #ingres | 10:04 | |
*** zxiiro has joined #ingres | 10:06 | |
*** ChanServ sets mode: +v zxiiro | 10:06 | |
*** pboro has quit IRC | 10:06 | |
*** pboro has joined #ingres | 10:13 | |
*** Alex| has quit IRC | 11:53 | |
*** zxiiro_ has joined #ingres | 12:47 | |
*** zxiiro has quit IRC | 12:47 | |
*** rossand has quit IRC | 13:40 | |
*** DerMeister has quit IRC | 14:29 | |
*** grantc has quit IRC | 14:38 | |
*** mull has quit IRC | 15:01 | |
*** bonsaikitten has quit IRC | 15:29 | |
*** bonsaikitten has joined #ingres | 15:36 | |
*** bonsaikitten has quit IRC | 15:48 | |
*** bonsaikitten has joined #ingres | 15:54 | |
*** rossand has joined #ingres | 15:57 | |
*** ChanServ sets mode: +o rossand | 15:57 | |
*** rossand has quit IRC | 16:00 | |
*** rossand has joined #ingres | 17:16 | |
*** ChanServ sets mode: +o rossand | 17:16 | |
*** zxiiro_ has quit IRC | 18:04 | |
*** mull has joined #ingres | 18:08 | |
*** mull has quit IRC | 18:34 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:37 | |
*** cytrinox_ is now known as cytrinox | 19:37 | |
*** rossand has quit IRC | 20:08 | |
*** rossand has joined #ingres | 20:15 | |
*** ChanServ sets mode: +o rossand | 20:15 | |
*** rossand has quit IRC | 20:30 | |
*** rossand has joined #ingres | 20:36 | |
*** ChanServ sets mode: +o rossand | 20:36 | |
*** rossand has quit IRC | 20:38 | |
ultrav1olet | How can I import SQL file from the shell? | 21:32 |
*** grantc has joined #ingres | 21:38 | |
*** ChanServ sets mode: +o grantc | 21:38 | |
*** Alex| has joined #ingres | 22:37 | |
*** ChanServ sets mode: +o Alex| | 22:37 | |
*** Alex| has quit IRC | 23:03 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!