Instant Infrastructure
Time to import a Jumpbox Mantis into a Virtual IronSubmitted by jblayter on Fri, 03/07/2008 - 2:49pm.I am in the middle of importing Mantis into our Virtual Iron. About 20 minutes has past and it is still going. How long should the import take? UPDATE: Still going along at 50 minutes now with no sign of life. Is this normal? |
Search |
Okay we were able to get the
So you are saying that you have a legacy, Non JumpBox Mantis installation you want to import into the JumpBox? We don't support that specifically, but with some Apps I know people have had luck importing their legacy data.
A very general overview ... You would have to register, enable ssh, and take the MySQL dump from your previous installation, scp it to the JumpBox and import that into MySQL, make sure the DB names are correct and the mantis configuration file matches then, if the mantis version you are importing from was older, you may have to go through an upgrade process.
Their Upgrade Instructions may help a little:
http://www.mantisbt.org/manual/manual.installation.upgrading.php
Unfortunately, I can't guarantee that it will work. If you are handy with MySQL then it would probably work out if its possible to upgrade between the versions of Mantis in general.
Austin
Time to import a Jumpbox Mantis into a Virtual Iron
This seems odd. I would try and cancel it and start over. Anything over 30 min is probably bad, if I recall correctly, it only took a few minutes (<10).
What release of Virtual Iron are you using?
Austin
Our virtual iron is using
Our virtual iron is using 4.2.3
Okay we were able to get the
Okay we were able to get the jumpbox up and running. How can I take my older MySQL database and run the upgrade scripts to get it to the version of Mantis that runs in the Jumpbox?
(UPDATE)
I purchased the license for the JumpBox and enabled the SSH. I tried accessing and moving the database over there via the MySQL Migration Toolkit and I was not able to do this. How do I access the MySQL database on the JumpBox?
Hi, I have no idea what the
Hi, I have no idea what the MySQL Migration Toolkit is. I interact with mysql entirely on the command line. However, I bet it needs to connect directly to the MySQL server over a network socket ... in order to do that, SSH into the JumpBox and follow step #3 listed here:
http://www.jumpbox.com/node/943#comment-869
That will make MySQL listen on the network. You may want to UNDO this when you are done for security purposes, but I will leave that to you.
Austin
Upgrading and MySQL Username / Password
I have an old version of Mantis that I want to load on the JumpBox. Does it contain the upgrade scripts that are talked about on this page? I looked around and didn't see them in the folders.
http://www.mantisbt.org/manual/manual.installation.upgrading.php
I also was able to get the MySQL to connect over the network but I am not sure what username and password I need to log in with.
Upgrading and MySQL Username / Password
The root MySQL password is the same as the debian-sys-maint users password and can be found in /etc/mysql/debian.cnf .... you will need to use sudo to read it:
sudo cat /etc/mysql/debian.cnf
Austin
PS : I forgot we had a FAQ on the data import issue:
http://www.jumpbox.com/node/963
MySQL Username / Password
I was able to get a WAMP running over the weekend and I was able to upgrade my Mantis version to match the Jumpbox. If you could please provide some instruction as to how I can transfer the latest database over to the Jumpbox we will be up and running again.
Thank you,
John
MySQL Username / Password
OK,
The instructions in the comment I linked to above were missing some important details. I am working on a more thorough FAQ entry that I will post here once I am done. But these are only relevant if you use some tool external to the JumpBox to move your Mantis DB.
Also, the general process to move your mantis database on Linux would be to dump the MySQL database on hostA then copy that file to hostB:
Then on hostB, the JumpBox, load that MySQL dump you just copied:
That would likely work, but like I said, we don't support this in anyway.
Austin
Updated MySQL FAQ
See the section on remotely accessing:
http://www.jumpbox.com/node/1101
The instructions I pointed you to earlier failed to grant any permissions to remote users. These rectify that. Once you grant permission to manipulate the mantis DB to a remote user, you may be able to use the tool you mentioned earlier.
Good luck
Austin
It worked!
I was able to get what I needed once I had the GRANT PERMISSION thing in the system. Thanks for all your help!