I didn't mean the whole attachments table. Putting that in the
filesystem would be crazy. I was more talking about files you manually
attach (word docs, images etc). These tend to me more throwaway for me
than the text of the replies/comments themselves, and we don't have
anywhere near as
Thanks Aaron for taking the time to dig them out. I'll take a look at
them (though fingers crossed adding the binary format options to the
DB dump seems to be working so far).
Justin
On 15 Oct 2009, at 22:09, Aaron Guise wrote:
Hi Justin,
Sorry it took so long. I was on leave and then
Thanks a lot for the info and advise Aaron. Don't suppose you kept the
scripts you used to dump the attachments and load them back in did you?
I'm going to talk to my sysadmins and see if they are using that
default-character-set option in the backup dump. If they aren't I'll
get them to
I'll have a look, I'm sure they are here somewhere. Might take a day
though.
*Regards,
Aaron Guise
07 838 7793
027 212 6638
aa...@guise.net.nz*
On Wed, Sep 16, 2009 at 9:20 PM, Justin Hayes justin.ha...@orbisuk.comwrote:
Thanks a lot for the info and advise Aaron. Don't suppose you kept
Thanks Aaron. I've always wondered why file attachments are stored in
the db at all. I'd have thought those would have been better placed
out in the filesystem.
Cheers,
Justin
Sent from my iPhone
On 16 Sep 2009, at 21:59, Aaron Guise aa...@guise.net.nz wrote:
I'll have a look, I'm sure
Justin Hayes wrote:
Thanks Aaron. I've always wondered why file attachments are stored in
the db at all. I'd have thought those would have been better placed out
in the filesystem.
Egads! What if the storage database is not local to the web server? How will
you perform comprehensive backups?
I fully agree Tom, SQL Servers totally own the filesystem equivalent in
this regard. Our attachments table is huge and it would be rather difficult
to keep a track of them all and ensure every last one is backed up without
the MySQL storage system :-)
*Regards,
Aaron Guise
07 838 7793
027 212
Hi guys,
I'm just testing an upgrade from 3.6.3 to 3.8.4. I ran the rt-setup-
database fine:
/opt/rt_support.openbet.com/sbin/rt-setup-database -dba rt_support --
prompt-for-dba-password --action upgrade
Then created the schema upgrade script:
perl
I had similar problems when moving upto 3.8.1. The previous sysadmin
responsible for RT had failed to upgrade the DB properly when going from
3.6.5 to 3.8.0 some time back. All our attachments went screwy too when I
tried to upgrade to 3.8.1.
In the end what I did is dump the database before
On Tue, Sep 15, 2009 at 11:54 PM, Justin Hayes justin.ha...@orbisuk.com wrote:
Hi guys,
I'm just testing an upgrade from 3.6.3 to 3.8.4. I ran the rt-setup-database
fine:
/opt/rt_support.openbet.com/sbin/rt-setup-database -dba rt_support
--prompt-for-dba-password --action upgrade
Then
10 matches
Mail list logo
