I've got 1.6 installed on a Ubuntu server that's several years old. I'm looking to move to a newer (larger) server. But can anyone point me to information on how to save/move the db? I don't want to lose the current tickets (and/or settings, if possible), and I have full access to the server, so any help would be appreciated! I've been reading the boards here, but have yet to find one that helps me. Thanks!
What kind of db is it? (Guessing mysql)man mysqldumpIt's not really an osTicket question, but if you run into difficulty, reply here with specific questions.Jack
And my question for the experts--Is the osTicket database "portable", or does it contain references to a specific host that would need to be modified? If it needs the hostnames and/or URLs modified, that's pretty trivial, just use sed to change them in the database dump. I do this all the time for my test sites.Jack
In short:use the DB server commands to export the database.move it to the new server.create your DB, DB User/Pass and grant it privs to the new DB.use the DB server commands to import the database.If you changed the DB Name, DB User/Pass update your /install/ost-config.phpSIDE NOTE: your file attachments would also need to be copied over to the new server also if you want to keep them. You would also need update your path to the attachments . Newer versions the attachments are stored in the DB by default.Jack, yes it should be portable.
