Server A will be the machine that is being migrated from, with server B being the target machine. The same scheme applies to database (DB) A and B.
I would like to encourage you to use a search engine of your choice to attempt and resolve any issues that may arise - you will find that there are more than enough guides, tutorials and articles on virtually any problem you may face.
-
Export database A and move it to server B.
You would for example use
scpto move the copy, andmysqldumpto export the database.$ mysqldump -u root -p osticket_db > ~/dump.sql $ scp ~/dump.sql root@serverB:~/dump.sql -
Move the OSTicket folder from server A to server B.
To stick with the toolset, you could use
scpagain, this time moving a whole folder and all it's subfolders using the-roption.$ scp -r /path/to/your/folder/osticket/* root@serverB:~/where/you/want/it/to/be/Note that you will most likely find your osticket folder in
/var/www/htmlor just/var/www/. Running a default configured Apache on Ubuntu LTS you would want the folder to be in/var/www/html/, on your new server. -
Create DB B on server B, and import DB A.
To create a new DB you would use the
CREATE DATABASE name;MySQL query, which you can invoke from the MySQL command line - to enter which you will have to simply domysql -u root -p.Importing database A can be done with
$ mysql -u root -p osticket_database < ~/dump.sql -
Adjust configuration of the imported OSTicket install.
Since, on server B, the database will most likely have a different name, user, and password, you will have to manually edit the
includes/ost-config.phpfile.Assuming you are in the root directory of your OSTicket install, open a text editor with
$ nano includes/ost-config.phpAnd edit the lines relevant to MySQL. You can read more on editing with nano here.
-
Copy OSTicket 1.10 over the files now on server B.
Since we have now completely migrated OSTicket from server A to server B, it is time to upgrade versions. Now would also be a good idea to check if everything works.
Assuming the new version of OSTicket lies in
~/osticket/, you would simply do$ mv -f -r ~/osticket/* /var/www/html/osticket/ -
Running the upgrader.
This is an automatic process that should begin once you navigate to http://yourip/support/scp.
Congratulations! If everything went well, you just migrated and upgraded OSTicket! If not.. well, sucks to be you, I guess. Feel free to drop me any questions, of course.