Backup restoration issue

mohankarunasiri

Hi All,I've backed up my existing OSTicket server database and installed another server on different PC with blank database and restore through PHPAdmin tool to new server but it getting the error message please refer my screenshot attached herewith.Thanks,Mohan K.My ConfigurationWindows 7 ProfessionalOSTicket: v1.9.5.1 (1faad22)Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.5.19MySQL Version - 5.6.21

Backup Restoration Errror.jpg

mohankarunasiri

please refer screenshot.

Backup Restoration Errror.jpg

JRogers

The database is evidently not blank.Run:SELECT * from ost1_attachment;I don't know how to run this from inside PHPAdmin (In fact, I've never heard of PHPAdmin, just phpMyAdmin), but that's the sql command you could use from the MySQL client command line, once you have selected the correct database.See if it returns data. If it does, then it's not a blank database.Jack

Chefkeks

Based on the error I agree with @[deleted], I does not seem to be a blank database, since a blank database would not display an error message that there is an duplicate entry.

I backed up our osTicket database and restored to another server for testing purposes and never had any trouble using MySQL command on the shell or they PHPMyAdmin, so I would recommend to just start over and make sure that the database you are importing the backup to, is empty ;)

ntozier

Silly question.When you restored the database, did you re-create the DB user and give it permissions to your newly restored database?

mohankarunasiri

Hi All,

Thanks for your supporting us again.

Method - 01

1.Installed OSTicket on another PC with local database named "osticket"

2.Get the backup on existing server via "PhPMyAdmin" and "Export" data to file. Earlier I was stuck on error message but able to fix it via http://stackoverflow.com/questions/3278470/phpmyadmin-error-1062-duplicate-entry-1-for-key-1

3.After "Importing" the backup file to new pc its getting error message

---- Indexes for dumped tables------ Indexes for table `ost1_api_key`--ALTER TABLE `ost1_api_key` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `apikey` (`apikey`), ADD KEY `ipaddr` (`ipaddr`);

"#1068 - Multiple primary key defined "

Method - 02

1. Tried via command line get backup of existing server via

mysqldump -u root -p --databases osticket > originalbkp

2.Restore the database to new pc via

mysql -u root -p osticket < originalbkp

3.It restored the database without errors but http://localhost/support and http://localhost/support/scp not displayed.

Thanks,

Mohan K.

JRogers

Method 1 failed because you did the install before restoring the database. I don't know about the "fix" you found at the stackoverflow site. It was too much to read, the part about "auto increment" just wasn't right. Forget phpMyAdmin, it's just a simple restore. YIf you had done the mysqldump with the --add-drop-table option, it would eliminate the possibility of multiple primary keys.Method 2 is closer to how I'd do it, but if you have to operate as "root" to get a database dump you need to do some reading on "Securing MySQL".3.It restored the database without errors

Then the original issue is resolved--you got a good database backup and restore.but http://localhost/support and http://localhost/support/scp not displayed. What does that mean? Is there even a web server running on this new host? Sounds like a web server configuration issue. But once again, we don't know enough about this new host to help troubleshoot.Jack

mohankarunasiri

Hi,Thanks for your advice. Actually my target is I assumed my production server is crashed and I need to up my help desk (OSTicket) on different PC from back-up therefore please let me know restoration order which I have to follow correctly.Thanks,Mohan K.

JRogers

Your "Method - 02" was correct for the database. You also need to restore the filesystem. That's really not an osTicket question, because it is dependent on how you do your filesystem backups. Note: That is not the same as re-installing osTicket. With a restore, you don't do a re-install.The order is not important, but once you have your filesystem and database restored, osTicket should work.I'm making the following assumptions:The new PC has a web server runningosTicket is served from the same directory as on the old computerThe new computer can be accessed via the same URL as the old oneJack

mohankarunasiri

Hi Jack,

Thanks for your support. What did you mean by:

2. osTicket is served from the same directory as on the old computer

Do I need to backup entire C:\xammp folder or C:\xammp\htdocs or C:\xammp\htdocs\support folder.

Thanks,

Mohan K.

JRogers

Hi Jack,

Thanks for your support. What did you mean by:

2. osTicket is served from the same directory as on the old computer

Do I need to backup entire C:\xammp folder or C:\xammp\htdocs or C:\xammp\htdocs\support folder.

Thanks,

Mohan K.

What I meant was, if osTicket was at http:/support on the old server, it has to be accessible the same way on the new one. That does not necessarily mean that your DocumentRoot must be in the same directory as before, depending on how the web server is configured.Jack

mohankarunasiri

Please refer my attachment.

mohankarunasiri

Dearr All,Please go to https://drive.google.com/file/d/0B6VbYq2HdP6wLUh3dVRRV2UyNkE/viewI've attached complete guide of osTicket restoration on Windows.Thanks,Mohan K.(Please close this discussion)

ntozier

This might sound a little harsh, but that does not appear to be a restoration guide... but does appear to be a How to install osTicket and XAMPP. It also does not talk about restoring the database.

mohankarunasiri

Yes, I tested & restored it several times osTicket very successfully (according to guide) on Windows Platforms with XAMPP Package. Database backup & restoring is not a big concern. This is very simple guide, just getting backup of entire "XAMPP" folder and put it to backup PC.

mohankarunasiri

Please close the discussion.