[rt-users] moving rt between machines.]

[Tore Micaelsen]

That one did the trick dr john,
but i came up with another problem.

[root at cache /root]# mysql -uroot -ppassword rt2 < rt2.out
ERROR 2006 at line 79: MySQL server has gone away
[root at cache /root]#


so i started the mysqld with some extra parameters...

--set-variable max_allowed_packet=4194304

Believe there was something that was too big in there... the rt2.out 
file was 120 MB

But now its up and running!

Thanks to you all!
Specially Alesh Mustar for his patience! ;-)

Tore



dr john halewood wrote:

>On Tuesday 20 November 2001 11:53, Tore Micaelsen wrote:
>
>>Am trying, but looks like i cant figue out the syntax...
>>trying
>>
>>[root at cache /root]#mysqlimport -uroot -ppassword rt2 rt2.sqldump
>>mysqlimport: Error: Table 'rt2.rt2' doesn't exist, when using table: rt2
>>
>
>try 
>mysql -uroot -ppassword rt2 < rt2.sqldump
>Providing your base install is there it should work fine. I've had to do this 
>to restore from backup on a number of occasions when users have mangled 
>tickets out of all recognition....
>
>cheers
>john
>
>
>----------------------------------------------------------
>   Secure your mail with MultiNet AS - www.multinet.no
>----------------------------------------------------------
>This mail has been scanned for viruses by moya.multinet.no 
>using AmaVis-Perl-11 with the following virus engines:
>Kaspersky Labs, F-Secure, Sophos and Innoculate with
>virus signaturefiles checked and updated every hour.
>
>
>
>
>




----------------------------------------------------------
   Secure your mail with MultiNet AS - www.multinet.no
----------------------------------------------------------
This mail has been scanned for viruses by moya.multinet.no 
using AmaVis-Perl-11 with the following virus engines:
Kaspersky Labs, F-Secure, Sophos and Innoculate with
virus signaturefiles checked and updated every hour.