Rt-2.x copy from one server to another

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.

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 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 :frowning: 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: