[rt-users] moving database to new server

Filip Jonckers fjonckers at Interconnect.be
Thu Sep 15 05:59:36 EDT 2005


 
I'm having problems moving rt3 database to another machine (both
rt3.4.1)
on the production RT I did:

# mysqldump -uroot -ppassword --opt rt3 > dump.sql

on the new machine I did:

# make initialize-database

(database rt3 successfully created - RT webinterface works with empty
database)

# mysql -uroot -ppassword rt3 < dump.sql

I checked if the data was imported by doing:

# mysql
mysql> use rt3;
mysql> select * from tickets;

(a list of all tickets is shown - data imported succesfully..)

but...  opening webbrowser and surfing to the RT website shows no data -
still an empty database


did I miss something here ?

Any help appreciated,
Filip


CONFIDENTIALITY NOTICE
-----------------------------------------------
This E-mail message and any documents which accompany it are intended only for the use of the individual or entity to which addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law.  If the reader is not the intended recipient, any disclosure, distribution or other use of this E-mail message is prohibited.  If you have received this E-mail message in error, please delete and notify the sender immediately.  Thank you.





More information about the rt-users mailing list