Am 26.07.2012 06:11, schrieb Adi Ariyanto:
First of all thank you for anyone that answer my question J
After I try run backup otrs on my otrs virtual machine, now I want to try to restore it, i got an error /"ERROR: Already existing tables in this database. A empty database is required for restore!"/
Information 1. I am used my copy of OTRS vmware, it's very fresh, just need run /installer.pl to setup
My question is 1. It's a fresh system, I even not yet create a ticket, just test that /index.pl is opened, but why I got an error about existing tables? How to make this restore test is work ?
What backup tool did you use? the backup script that comes with otrs should create the correct commands... Your SQL dump probably contains CREATE TABLE directives without DROP TABLE, which doesn't work if the tables already exist. You could either load the SQL file (shouldn't be too big if you did not create any tickets yet), search for all CREATE TABLE `tablename` directives and put DROP TABLE IF EXISTS `tablename`; above them. You could also simply use DROP DATABASE databasename; and CREATE DATABASE databasename; (all from the mysql command shell) to create an empry database but this is only recommended if your SQL dump includes the neccesary information about collation, character set etc.