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

[Ruslan U. Zakirov]

    Hello again and again.
Problem is resolved.
It's problem of my system. Somewhere something set TMPDIR = 
/tmp/.private/root and mysql like a good worker try to use it :( instead 
of /tmp or something else more public.

Fixes:
1) Additional arg to mysqld --tmpdir=... or to safe_mysqld
2) In /etc/my.cnf in section mysqld string "tmpdir=..."
                Best regards. Ruslan.

Ruslan U. Zakirov wrote:

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