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

2009-08-21 Thread Emanoil Kotsev
Boyd Stephen Smith Jr. wrote: In h6l9af$4p...@ger.gmane.org, Emanoil Kotsev wrote: Yeah, somehow SQL does not seem to be really Standard :-) 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

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

2009-08-21 Thread Boyd Stephen Smith Jr.
In h6lhuk$ek...@ger.gmane.org, Emanoil Kotsev wrote: Boyd Stephen Smith Jr. wrote: In h6l9af$4p...@ger.gmane.org, Emanoil Kotsev wrote: Yeah, somehow SQL does not seem to be really Standard :-) The S in SQL stands/stood for Structured. [...] In short, most SQL you will find is not

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

2009-08-21 Thread Emanoil Kotsev
Boyd Stephen Smith Jr. wrote: In h6lhuk$ek...@ger.gmane.org, Emanoil Kotsev wrote: Boyd Stephen Smith Jr. wrote: In h6l9af$4p...@ger.gmane.org, Emanoil Kotsev wrote: Yeah, somehow SQL does not seem to be really Standard :-) The S in SQL stands/stood for Structured. [...] In short, most SQL

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

2009-08-21 Thread Boyd Stephen Smith Jr.
In h6mefe$ad...@ger.gmane.org, Emanoil Kotsev wrote: Boyd Stephen Smith Jr. wrote: In h6lhuk$ek...@ger.gmane.org, Emanoil Kotsev wrote: Boyd Stephen Smith Jr. wrote: In h6l9af$4p...@ger.gmane.org, Emanoil Kotsev wrote: Yeah, somehow SQL does not seem to be really Standard :-) The S in SQL

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-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 databases

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: 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 mysql,

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

2009-08-20 Thread Boyd Stephen Smith Jr.
In h6l9af$4p...@ger.gmane.org, Emanoil Kotsev wrote: Yeah, somehow SQL does not seem to be really Standard :-) 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

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 into

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 and

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 clarify.

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 database

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 for

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 export data

how to migrate request-tracker database from sqlite3 to mysql

2009-08-18 Thread Martin Kraus
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 databases for rt are not compatible