Can't restore OTRS after server change

[hopeitl]

I had OTRS running mostly fine on a physical Ubuntu 10.04 server. We created a VMware server running 10.04 (I had to install 10.04 because of LVM instead of cloning it). I backed up the old OTRS using the backup.pl script, and it went fine. So I created a /opt/otrs directory on the new server, unzipped files and ran through the installation.pl script because the restore.pl script didn't work right before that point. Note: I used the OTRS wiki for installing on Ubuntu 10.04.

I now tried to use the restore.pl script on the backup and I get the error "ERROR: Already existing tables in this database. An empty database is required for restore."

Can anyone help me out? I want this to become exactly what I had on the physical. Oh, if it matters, OTRS 3.0.9, with latest updates on 10.04.

[crythias]

the answer is given in the error code.

You are being prevented from restoring over data. Either drop or rename the installed otrs database and you should be able to restore.

[hopeitl]

the answer is given in the error code.

You are being prevented from restoring over data. Either drop or rename the installed otrs database and you should be able to restore.

I deleted the mysql OTRS database using webmin, and it "restored" without an error, but nothing's changed, and the old users aren't there, nor any of the settings from the old physical.

EDIT:
So, I restored the mysql database from the physical (using a dump), the ./restore restored applications, but not sql. I got errors, so I just manually overwrote /opt/otrs with the physical folder. Now I'm stuck with this:

Code: Select all

<![CDATA[
Message:
Can't write '/opt/otrs/var/httpd/htdocs/skins/Agent/default/css-cache//CommonCSS[..]

Comment:
Please contact your administrator

Traceback:
ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Wed Jul 13 10:15:46 2011

 Message: Can't write '/opt/otrs/var/httpd/htdocs/skins/Agent/default/css-cache//CommonCSS_IE8_ed04f76238d176133c8c56e5de8364b2.css': Permission denied

 Traceback (2865): 
   Module: Kernel::System::Main::FileWrite (v1.58) Line: 444
   Module: Kernel::System::Loader::MinifyFiles (v1.17) Line: 247
   Module: Kernel::Output::HTML::LayoutLoader::_HandleCSSList (v1.37) Line: 600
   Module: Kernel::Output::HTML::LayoutLoader::LoaderCreateAgentCSSCalls (v1.37) Line: 177
   Module: Kernel::Output::HTML::Layout::Header (v1.351.2.5) Line: 1311
   Module: Kernel::Output::HTML::Layout::FatalError (v1.351.2.5) Line: 1051
   Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 144
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
   Module: (eval) (v1.89.2.1) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

"
                    ]]>

This is driving me nuts, it worked fine on the physical, there's no reason why I shouldn't just be able to copy the physical's config/sql/otrs files. Any suggestions? I tried to change permissions via

Code: Select all

cd /opt/otrs
bin/otrs.SetPermissions.pl --otrs-user=otrs --otrs-group=otrs --web-user=www-data --web-group=www-data /opt/otrs

and I keep getting permissions denied errors too.