osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Importing .sql dump into new OSticket instance
I have been setting up a new Centos server to run osticket v1.7.
I have the system up and running, but now could use assistance importing my old osticket settings to the new server, without using phpmyadmin. Here is what I have done so far.
I performed an export of my current osticket (V1.6) mysql database, and used WINSCP to upload this .sql file to a new directory /sqldump. I want to populate the "support" database I created prior to the install.
I then ran this command to populate the new blank database with the .sql file#mysql
-u -p -h localhost support < /sqldump/mysql.sql
# service mysqld restart
Now when I look at the "support" database, I can see all of the tables imported successfully.
My question now is, how do I get the osticket application to recognize this new information? My new installation does not show these migrated tickets in webbrowser.
Any thoughts would be helpful! Thanks.