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?
(closed) Delete Company or reset full database to install backup?
Moderator: crythias
-
- 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?
Last edited by christopher on 19 Jan 2016, 18:43, edited 1 time in total.
-
- 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?
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
-
- 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?
Thanks for the feedback, got a clean database again.