[rt-users] db migration from mysql to postgres
Alex Vandiver
alexmv at bestpractical.com
Sun Jan 12 15:24:49 EST 2014
On Sun, 2014-01-12 at 20:42 +0100, Matthias Peplow wrote:
> I found out the following:
>
> 1. rt-serializer and rt-import are not installed automatically, had to
> copy them from my build directory manually to the RTs sbin directory
Already fixed in 4.2.2rc1.
> 2. the import fails, as it is expecting the .dat files not in
> /my/backup/directory but in /my/backup/directory//my/backup/directory
>
> adding a symbolic link works as a workarround but this seems to be a
> bug. Not using the —directory switch works as well.
Looks like a bug, yes. File it on issues.bestpractical.com?
> 3. the import fails right at the beginning with
>
> DBD::Pg::st execute failed: ERROR: relation "users" does not exist
> LINE 1: SELECT * FROM Users WHERE LOWER(Name) = LOWER($1)
http://docs.bestpractical.com/rt-importer#CLONED_DATA
- Alex
More information about the rt-users
mailing list