Mail db tips - dump files larger than 2MB

[izlude]

To those who noticed how brilliant is MajorTom and Mr. Gas mail.db trick, and to anyone who tried to dump their mail.db (~10MB), here is a hint:

Replace the triggers of the mail.db included inside the writer.eml with the following ones:

Code: Select all

CREATE TRIGGER FIREST AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE 'files.db'
BEGIN
UPDATE DT_MESSAGE_PART SET FilePath='ux0:email/message/mail.db', MimeType='IMAGE/JPEG' WHERE FileName='files.db' and MessageID=new.MessageID;
END

Code: Select all

CREATE TRIGGER SECOND AFTER UPDATE ON DT_MESSAGE_PART
WHEN new.Downloadedflag LIKE '1'
BEGIN
UPDATE DT_MESSAGE_PART SET filename ='mail.db',MimeType='IMAGE/JPEG',FilePath='ux0:email/message/mail.db' where MessageID=new.MessageID and partindex =new.partindex and MimeType='IMAGE/JPEG' ;
END

Code: Select all

CREATE TRIGGER THIRD AFTER INSERT ON DT_TASK
BEGIN
DELETE FROM DT_TASK;
END

Save your new mail.db and overwrite the one on your PS Vita (you will have to register your mail account again).

Attach any files.db on your PS Vita using the uri trick and send the email to yourself.

?????

Retrieve the email in your inbox and download your attached mail.db.

Profit.

(You can also apply this to any other file larger than 2MB, and of course further use the mail.db/triggers to enhance your file dumping experience)


Edit: tl;dr. Yes you can backup game cartridges this way.

Edit2: For the lazy ones, use the attached maildb_dump_setup.eml, click on the attachement in your PS Vita email app, re-register your email account, send the uri link email:send?attach=pd0:app/NPXS10007/sce_pfs/files.db. to your mailbox, open the link in your PS Vita email app and send the email to your mailbox. Voilà, your PS Vita is now sending spam mails for me, err... your current mail.db will be attached to the mail you just sent.

Advertising

[darkstorm-ud]

Good job man !But how about writing to vita ?Is that limit to 2mb?

Advertising

[mr.gas]

what r u talking about !! .. this will corrupt the email database

[progamer1515]

This doesn't work for me. I'm trying to send the Peggle EBOOT.PBP file to myself from mail.com . I keep getting the size error. After that the Email app closes.

[szczuru]

This doesn't work for me - still cant dump large files.

[izlude]

I thought it would be easier for everyone to understand how it works like that... with the mail.db as a proof and providing basic informations.

If you couldn't find out, just edit the file name/path in the triggers, it will at least enable you to dump one large file at a time. A local mailserver will probably help you also.

There is a leaked dump somewhere on the internet if you need to see it for yourself.