5 messages in com.mysql.lists.eventum-usersRe: how to clean db out to start 'clean'
FromSent OnAttachments
Madcapcartman21 Nov 2005 03:34 
Vyacheslav Kvasnitsky21 Nov 2005 05:14 
Madcapcartman21 Nov 2005 05:42 
Travis Pierce21 Nov 2005 11:22 
Madcapcartman22 Nov 2005 10:50 
Subject:Re: how to clean db out to start 'clean'
From:Madcapcartman (madc@hotmail.com)
Date:11/22/2005 10:50:34 AM
List:com.mysql.lists.eventum-users

Many thanks for the information.

I would create a query based on the delete issue query that has been posted on the wiki at http://eventum.mysql.org/wiki/index.php/Deleting_Issues

You should do this yourself, but I get something like this:

DELETE FROM eventum_issue_association; DELETE FROM eventum_issue_attachment; DELETE FROM eventum_issue_checkin; DELETE FROM eventum_issue_history; DELETE FROM eventum_issue_requirement; DELETE FROM eventum_issue_user; DELETE FROM eventum_note; DELETE FROM eventum_subscription; DELETE FROM eventum_support_email; DELETE FROM eventum_time_tracking; DELETE FROM eventum_issue_custom_field; DELETE FROM eventum_phone_support; DELETE FROM eventum_reminder_requirement; DELETE FROM eventum_reminder_history; DELETE FROM eventum_email_draft; DELETE FROM eventum_irc_notice; DELETE FROM eventum_issue_user_replier; DELETE FROM eventum_mail_queue; DELETE FROM eventum_issue;

--- Madcapcartman <madc@hotmail.com> wrote:

I'd like to be able to clean out all issues etc but leave the customised settings....i.e. Project Name, users etc etc

TIA

----- Original Message ----- From: "Vyacheslav Kvasnitsky" <sal@rws.com.ua> To: <even@lists.mysql.com> Sent: Monday, November 21, 2005 1:14 PM Subject: Re: how to clean db out to start 'clean'

Don't forget to create the backup after eventum installation.

You may run eventum/setup/schema.sql in order to install clean database, or specify what you need to clean in the database. May be I can help.

Sincerely,

-- Vyacheslav Kvasnitsky Real Web Solutions

-- Got a web project? Get a FREE quote! http://www.rws.com.ua/contact_us_project.php

On Monday 21 November 2005 13:35, Madcapcartman wrote:

Hi there

Now that the list has helped resolve the downloading of emails problem I was facing - is there a sql statement that will 'clean' the db out of all the test issues I've created but doesn't clean out the settings?

TIA

-- Eventum Users Mailing List For list archives: http://lists.mysql.com/eventum-users To unsubscribe:

http://lists.mysql.com/eventum-users?unsub=madc@hotmail.com

-- Eventum Users Mailing List For list archives: http://lists.mysql.com/eventum-users To unsubscribe: