Instant Infrastructure
import otrs.sqlSubmitted by machines on Thu, 01/10/2008 - 1:24am.hello again, i like to import an existing sql-dump into my jump-box otrs, can someone give me a few tips to manage this task in greetings marco. |
Search |
great job !
hi austin,
that´s really more than i expected. we have the same otrs-version, because
we used an actual windows-installation ... since now.
if i had to figure this out, i think it would have last for days ...
the import worked without any problems. the only thing is to configure the
config.pm and make some other configuration. but that doesn´t matter.
finally, is it possible that you can give me a command to create a sql-dump
within the jumpbox ? thanks in advance.
greetings marco.
OTRS manual MySQL Database Dump
Hi Marco,
To dump JUST the otrs database you can do this.
That is almost everything you need, there is an OTRS user in the mysql database though. This is the user that the OTRS software uses to connect to the database. You can dump the mysql database as well with this:
And then restore each file to the appropriate database as I showed above.
Austin
import otrs.sql
Hi Marco,
Importing existing Application data falls outside of our support, even for Silver level, so we can only answer these questions as time permits. Does the version of OTRS data you are importing match the OTRS version on your JumpBox? Doing this could either be very easy or quite painful.
See this FAQ on Importing Application Data.
If the OTRS versions match it could be as simple as importing the OTRS data, like you hope. There is a considerable chance that its not that easy but lets at least give that a try.
Ok, I am assuming that the JumpBox you are importing to contains no information you need to save. First, Enable SSH if you haven't already, SCP/SFTP the otrs.sql file to the JumpBox, then SSH into the JumpBox where you will import the data with the mysql command as follows (if you are asked for a password, it is asking for the admin users password):
So, at this point, OTRS may or may not work with your old data. Maybe you have to restart apache but probably not, but you might try it:
If it doesn't appear to be working then you may be out of luck. If you need to do more elaborate database work and you are uncomfortable with the mysql command line interface you might have luck installing phpmyadmin.
Austin