Hi. I just purchased the vtiger jumpbox, because I want to move my current vtiger 5.0.2 implementation on Windows to a virtual machine, for speed and reliability, etc.
I'm having a very hard time doing this. I managed to use mysqladmin on windows to dump the db, and I used mysql on the jumbox via an ssh session to run the script, but I get spurious errors in varios pages. I think the best way would be to connect the mysqladmin running on an external machine to the mysql on the jumpbox, but I don't think that port 3306 is open for external connections (is it?).
Can you help me out with instructions on moving a windows 5.0.2 installation to the jumpbox 5.0.3 installation?
Thanks a lot,
Eli
To answer your other
To answer your other question, No, MySQL is not listening on 3306 on the actual network interface. It can be made to do so, but is not likely necessary in this case.
Oh, and you should try the above procedure on a fresh JumpBox just to make sure you don't have any messed up data from trying to use the app with the wrong version data.
Austin
Succesful (99%) migration
I have managed to migrate most of the vtiger application. Only minor messages show up here or there.
1. I couldn't import the database through any regular means. The backup feature in the Windows vtiger failed to import into the jumpbox vtiger.
2. I opened an SSH tunnel to the jumpbox and tunneled port 3306 to the jumbox. I was then able to use MySQLAdmin to connect to the windows MySQL and the jumbox MySQL and export from Windows and import to JumpBox.
3. Then I ran the migration procedure from 5.0.2 to 5.0.3.
4. Most of the application is now working fine.
Thanks.
Hi Eli, Going from 5.0.2
Hi Eli,
Going from 5.0.2 to 5.0.3 requires lots of changes in the database schema. If you have successfully imported the data into the database on your JumpBox all that you need to do is run the vTiger Migration script tool. You can do so by following these instructions:
Also, if you have uploaded attachments they would not have been stored in the database. They would be in various directories under your vTiger installation. Let me know if you need help tracking them down or if you have any other problems.
Austin