Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-21 Thread Emanoil Kotsev
Boyd Stephen Smith Jr. wrote: > > No, thank $DEITY. I had a couple of jobs involving Oracle, but I tend to > avoid anything were I have to deal with too much proprietary software. I am using oracle at work and compiled tora with ora support. At this point I wanted to install the export tool and

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-21 Thread Boyd Stephen Smith Jr.
In , Emanoil Kotsev wrote: >Boyd Stephen Smith Jr. wrote: >> In , Emanoil Kotsev wrote: >>>Boyd Stephen Smith Jr. wrote: In , Emanoil Kotsev wrote: >Yeah, somehow SQL does not seem to be really "S"tandard :-) The "S" in SQL stands/stood for "Structured". [...] >>> >>>hehe, I was

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-21 Thread Emanoil Kotsev
Boyd Stephen Smith Jr. wrote: > In , Emanoil Kotsev wrote: >>Boyd Stephen Smith Jr. wrote: >>> In , Emanoil Kotsev wrote: Yeah, somehow SQL does not seem to be really "S"tandard :-) >>> >>> The "S" in SQL stands/stood for "Structured". [...] >>> >>> In short, most SQL you will find is not str

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-21 Thread Boyd Stephen Smith Jr.
In , Emanoil Kotsev wrote: >Boyd Stephen Smith Jr. wrote: >> In , Emanoil Kotsev wrote: >>>Yeah, somehow SQL does not seem to be really "S"tandard :-) >> >> The "S" in SQL stands/stood for "Structured". [...] >> >> In short, most SQL you will find is not strictly-conforming, just like >> most shel

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-21 Thread Emanoil Kotsev
Boyd Stephen Smith Jr. wrote: > In , Emanoil Kotsev wrote: > >>Yeah, somehow SQL does not seem to be really "S"tandard :-) > > The "S" in SQL stands/stood for "Structured". However, SQL has been > standardized about 3 times, roughly the same number of times UNIX has been > standardized. Howeve

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-20 Thread Boyd Stephen Smith Jr.
In , Emanoil Kotsev wrote: >Yeah, somehow SQL does not seem to be really "S"tandard :-) The "S" in SQL stands/stood for "Structured". However, SQL has been standardized about 3 times, roughly the same number of times UNIX has been standardized. However, like UNIX, each implementation has many

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-20 Thread Emanoil Kotsev
Martin Kraus wrote: >> >> there is actually a nice php interface to sqlite which can do the export >> in sql. I'm not sure if you can import into mzsql, but I think there is >> such an option in phpmyadmin > > it's not a problem with exporting into sql. it's a problem with importing > sql into m

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-20 Thread Martin Kraus
On Thu, Aug 20, 2009 at 06:55:25PM +0200, Emanoil Kotsev wrote: > Martin Kraus wrote: > > > > > hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > > on > > lenny. Is there a way to export data from sqlite so they can be imported > > into mysql for request-tracker3.6? >

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-20 Thread Emanoil Kotsev
Martin Kraus wrote: > > hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > on > lenny. Is there a way to export data from sqlite so they can be imported > into mysql for request-tracker3.6? > > rt-dump-database doesn't export sqlite database and sqlite and mysql > data

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-19 Thread Boyd Stephen Smith Jr.
In <20090819224241.gc22...@finrod>, Martin Kraus wrote: >On Wed, Aug 19, 2009 at 10:17:03PM +0200, Jesús M. Navarro wrote: >> On Wednesday 19 August 2009 02:37:37 Martin Kraus wrote: >> > hi. I'm trying to migrate request-tracker3.6 database from sqlite to >> > mysql on lenny. Is there a way to ex

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-19 Thread Martin Kraus
On Wed, Aug 19, 2009 at 10:17:03PM +0200, Jesús M. Navarro wrote: > On Wednesday 19 August 2009 02:37:37 Martin Kraus wrote: > > hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > > on lenny. Is there a way to export data from sqlite so they can be > > imported into mysql

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-19 Thread Jesús M. Navarro
On Wednesday 19 August 2009 02:37:37 Martin Kraus wrote: > hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > on lenny. Is there a way to export data from sqlite so they can be > imported into mysql for request-tracker3.6? > > rt-dump-database doesn't export sqlite databa

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-19 Thread Martin Kraus
On Wed, Aug 19, 2009 at 10:18:49AM -0500, Boyd Stephen Smith Jr. wrote: > So, request-tracker uses a different table layout (schema) depending on what > database server it is connecting to? If so, you'll probably have to roll a > one-off to translate from one to the other. If not, please clarif

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-19 Thread Boyd Stephen Smith Jr.
In <20090819003737.gd2...@finrod>, Martin Kraus wrote: >hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql > on lenny. Is there a way to export data from sqlite so they can be > imported into mysql for request-tracker3.6? > >rt-dump-database doesn't export sqlite database a

Re: how to migrate request-tracker database from sqlite3 to mysql

2009-08-19 Thread Cousin Stanley
> > hi. I'm trying to migrate request-tracker3.6 database from sqlite > to mysql on lenny. Is there a way to export data from sqlite > so they can be imported into mysql for request-tracker3.6? > martin One way might be to export from sqlite as .csv files and then import int