Hi All,

I have just got osticket v1.7.1 up and running on an internal VM.

Centos 6.3

MySQL version is 5.1.69

PHP Version 5.3.3

Apache version 2.2.15

I want to dump the data from my production osticket instance (v1.6RC5), and populate the new, currently empty, support database (v1.7.1) I am not using phpmyadmin. Is there anything I should do prior to importing the .sql file?

Is the table structure different in the new version?

Last time I got an error along the lines of the "topic" table being invalid.

Thanks so much!:

You cannot easy just import it from 1.6rc5 to 1.7.1st as there have been database structure changes and you would have to either do them manually, apply them manually, or run the upgrader.

I really recommend that you clone your existing setup (file structure and database) then perform the upgrade(s) on the clone. I believe that you will want to first upgrade from 1.6rc5 to 1.6ST then you should be okay to run the 1.7.1 upgrader.

SQL Script

Thank you for this reply. I would really rather edit the database structure manually, rather than install and upgrade.

Is there a mySQL script anybody can share with me to reflect these changes? Or any information you can share? My mysql experience is very limited, but I work with many SQL experts.

Thanks.

Write a Reply...