5022 Views 12 Replies Latest reply: Sep 26, 2009 11:30 AM by BDAqua
I have set up a rule as follows:
If from contains MYSQLbackup then move message to dbBackup
This rule works fine. I have a MySQL database hosted externally and a cron job that automatically emails me a copy of the database each night as an added measure of backing up the database. The from addresss contains MYSQLbackup in it. The "dbBackup" is a local mailbox folder.
I have a second rule as follows:
If date received is greater than 30 days old then delete message
This rule does not seem to work on the local mailbox/folder "dbBackup"
Do rules only apply to the incoming mailboxes and not the local mailboxes? Is there a way to get it to apply to the local mailboxes?
What I would like to do is have the MySQL database emailed to me daily so if my hosting provider's backup fails and things crash on their end (not that this has ever happened, but just being safe) I have a copy of the data for the last 30 days. Ideally, I want to do a daily backup going back 30 days, archive a snapshot of it on the 1st of every month. So at the end of a year I should have a mail message on my local folder that has backups of Jan 1, Feb 1, Mar 1,... Nov 1, Dec 1, and all of December. On Jan 31th of next year I would have the first of every month of this year, plus all of January.
I know, email is not the best solution for secondary backups, I have thought of scheduling the cron job to ftp the data somewhere. But it is not a lot of data and initially thought I could do this quickly just using email and rules knowing that I have it locally with me and easily accessible at all times and is being backed up regularly in more than one location. Call me paranoid!
Any suggestions or if the rule is: rules don't apply to local mailboxes in this manner, please let me know. Thanks in advance.
FWIW - MS Entourage allows you to set up rules on outgoing messages.
Side Note on Entourage:
Unfortunately I just lost all of my email Yesterday because of a database corruption problem in Entourage (it stores all the emails in a massive database). Thanks to a Time Machine backup and Apple Mail's import feature, I was able to save most of the mail. I'm going to miss some of Entourage's flexibility when it comes to rules though (rules on outgoing messages and the ability to apply just one rule of the set without first disabling the others).
This is just *totally amazing* - I used Eudora for years, then went to Entourage (and like others my database was getting corrupted every couple of days and I had to spend hours waiting for Entourage to rebuild it each time, only to have it get corrupted again with a couple more days), but last week I switched to Apple Mail.app. I LOVE IT (SO FAST!) - except for this inability to filter outbound mail. Like others, I go to the -sent- folder and select everything and then apply filters to them, and bingo they fly into the correct folders for me because I've built rules that look at the -recipients- that I'm sending to. But what a pain that I can't apply rules to outbound mail!
And there's no way to apply an action based on an address book -group- to outbound mail rules, you have to specify every recipient explicitly in the rule. Whereas -groups- work fine for filtering inbound mail.
Are y'all sure that nobody has invented some plug-in that will solve this problem? Every other emailer that I've used since 1986 (AOL) has had the ability to apply rules to outbound mail, as does gmail and other webmail services - this is the first program I've encountered that ignores it as if it's an oddball thing to do.
[Yeah, the rules work -as expected- based on the documentation, but this feature is just so basic it's astounding that it's not there. I must be missing something really simple? Like it's so easy I just don't see it right in front of my face?]
Jim Sky wrote:
Like it's so easy I just don't see it right in front of my face?
Ha! You have to think in one-button mode (that is, two buttons is too tricky, so we'll make you press a key on the keyboard AND click at the same time):
1. Mail Prefs > Composing > "Automatically Bcc: myself"
2. Apply rule 'From' 'Is equal to' firstname.lastname@example.org
And there you have it - Apple's backward-arse way of filtering on "outbound" email.
Except you don't seem to be able to 'copy' then 'delete' in the same rule - that is, delete the original, not the copy. I ended up losing all my mail for one afternoon because of this stupid behaviour. Why would I want to do this? Because 'move' annihilates any trace in your Exchange mailbox, I was hoping the 'delete' would merely mark it to be deleted later.
How odd. My entourage database just went south as well. What version are we discussing? I'm on 2004.
My issue was the calendar developed a sync issue with ical, and even deselecting the entourage preferences wouldn't undo the communications weirdness between the iphone, ical, and entourage. This even survived a reinstall of the OS. It wasn't until I removed entourage from the system that the problem went away. Thankfully I was able to import my mail to mac mail first.
Found this thread looking for why my outgoing mail rules weren't working. Seems a pretty obviously necessary thing. I'm amazed it doesn't work.
There's a 3rd party Mail plugin called Mail Act-On that enables outgoing Mail rules as well as a bunch of other time saving features like applying rules via keyboard shortcuts to selected messages and keyboard shortcuts for moving messages to folders, etc.
It works fantastically. It's $25, totally worth it if you ask me.