Well, did you check the database on the target machine? Does it contain
tables? If so, delete them. As explained, the backup SQL should take
care of this, but... also check if there are sufficient rights to write
to the database and alter / drop tables for the database user.
Both I am use OTRS backup and restore tools
I am backup with this command /opt/otrs/scripts#./backup.pl --d
/var/backup_otrs àI put the backup folder in /var/backup_otrs, and success
Then I try to restore to another otrs machine with this command
/opt/otrs/scripts# ./restore.pl --b /var/backup_otrs/2012-07-25_11-45
--d /opt/otrs
*From:*[email protected] [mailto:[email protected]] *On Behalf
Of *Bernd Backhaus
*Sent:* Thursday, July 26, 2012 11:49 AM
*To:* [email protected]
*Subject:* Re: [otrs] Try to restore OTRS
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.
------------------------------------------------------------------------
This email and its attachments may be confidential and are intended
solely for the use of the individual to whom it is addressed. Any
views or opinions expressed are solely those of the author and do not
necessarily represent those of Bina Nusantara.
If you are not the intended recipient of this email and its
attachments, you must take no action based upon them, nor must you
copy or show them to anyone.
Please contact the sender if you believe you have received this email
in error.
------------------------------------------------------------------------
This email and its attachments may be confidential and are intended
solely for the use of the individual to whom it is addressed. Any
views or opinions expressed are solely those of the author and do not
necessarily represent those of Bina Nusantara.
If you are not the intended recipient of this email and its
attachments, you must take no action based upon them, nor must you
copy or show them to anyone.
Please contact the sender if you believe you have received this email
in error.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
