[rt-users] rt-2.x copy from one server to another.

[Ruslan U. Zakirov]

            Hello again.
Sorry, but rt logging was off.
No I've warning:

[Wed Jul 23 15:21:41 2003] [warning]: DBD::mysql::st execute failed: 
Can't create/write to file '/tmp/.private/root/#sqlcf2_a_0.MYI' 
(Errcode: 13) at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm 
line 145.
                                                                                                                             
[Wed Jul 23 15:21:41 2003] [warning]: DBIx::SearchBuilder error:Can't 
create/write to file '/tmp/.private/root/#sqlcf2_a_0.MYI' (Errcode: 13)
        Query String is SELECT DISTINCT main.* FROM Queues main  WHERE 
((main.Disabled = '0'))  ORDER BY main.Name ASC
[skip]

I don't understand why during transaction it try to write in 
/tmp/.private/root
mySQL user is mysql, but this dir is owned by ROOT.
Ofcouse this error may be only mysql related, but I didn't find anything 
helpful trough googling.
        Beforehead thanks. Ruslan.
_____________________________________
Ruslan U. Zakirov wrote:

>    Hello.
> I'm trying to do a copy of current RT installation from one machine to 
> another.
> Have done mysqldump of current db.
> Have setup blank RT installation on new server.
> Ok, everything looks fine.
> Next I do restoring of DB(mysql rt2 < rt_cur.dump) - OK
> Restart apache - OK
> Going to login - OK
> Have got login under user from current server's DB.
> But all lists is empty and can't create new queue or user or something 
> else.
> All logs are empty.
>        Any suggestions are wellcome.
>        I can add some aditional information.
>                Best regards, Ruslan.