(closed) Delete Company or reset full database to install backup?

Moderator: crythias

Locked
christopher
Znuny newbie
Posts: 57
Joined: 20 Nov 2015, 16:47
Znuny Version: 5.0.14

(closed) Delete Company or reset full database to install backup?

Post by christopher »

I hope someone can give me hint.
I made some tests with the import of a few companies using the addon developed by cape-it.
The addon works great, but i made a mistake and prepared a csv that was not utf-8.
Now i have 4 companies n my database that i want to delete.

How can i, (manually) delete those customers? There is no ticket or setting linked to them. So i think it should be safe.

Alternative:
I created (of course) a backup before i made those tests. But i cant use restore.pl on a non-empty database.
Is there some script to first delete everything and than use the restore.pl?
Last edited by christopher on 19 Jan 2016, 18:43, edited 1 time in total.
RStraub
Znuny guru
Posts: 2210
Joined: 13 Mar 2014, 09:16
Znuny Version: 6.0.14
Real Name: Rolf Straub

Re: Delete Company or reset full database to install backup?

Post by RStraub »

To be able to restore, simply login to your DB and do a drop database followed by a create database.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
christopher
Znuny newbie
Posts: 57
Joined: 20 Nov 2015, 16:47
Znuny Version: 5.0.14

Re: (closed) Delete Company or reset full database to install backup?

Post by christopher »

Thanks for the feedback, got a clean database again.
Locked