5 messages in com.mysql.lists.eventum-usersRe: how to clean db out to start 'clean'| From | Sent On | Attachments |
|---|---|---|
| Madcapcartman | 21 Nov 2005 03:34 | |
| Vyacheslav Kvasnitsky | 21 Nov 2005 05:14 | |
| Madcapcartman | 21 Nov 2005 05:42 | |
| Travis Pierce | 21 Nov 2005 11:22 | |
| Madcapcartman | 22 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.
----- Original Message ----- From: "Travis Pierce" <trav...@yahoo.com> To: "Madcapcartman" <madc...@hotmail.com>; "Vyacheslav Kvasnitsky" <sal...@rws.com.ua>; <even...@lists.mysql.com> Sent: Monday, November 21, 2005 7:23 PM Subject: Re: how to clean db out to start 'clean'
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;
Travis
--- 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:
http://lists.mysql.com/eventum-users?unsub=trav...@yahoo.com
__________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com




