Sidestep - mysql-backup question

hi,
on my recent upgrade-path from RT3.0.9 ot 3.4.1 I did a simple mysqldump and
then inserted everything into the new mysql-server but I had to realize now…
virtually all attachements are broken :frowning:

especially binary-attachments (pdf and like) have gone dead…

now here is my begging for “who has a real backup-way for RT?” - I would have
bet I had everything the right way (moving between same mysql-version-servers)
but I had to learn it the hard way that I was obviously wrong.

Is there any real way besides stopping mysql and copying the binary data files
away and store somewhere safe?

thank you in advance
Harald Kapper, icq# 36178328 http://kapper.net
software-development and loeblichgasse 6
security-consulting 1090 vienna, .at
tel +43 1 3195500-0, fax +43 1 3195502, hk@kapper.net
--------------mark---------------
The following Statement is False.
The previous Statement is True.
- Welcome to my World -

Harald Kapper wrote:

hi,
on my recent upgrade-path from RT3.0.9 ot 3.4.1 I did a simple mysqldump and
then inserted everything into the new mysql-server but I had to realize now…
virtually all attachements are broken :frowning:

especially binary-attachments (pdf and like) have gone dead…

Did you run the scripts to update the db schema, etc?

now here is my begging for “who has a real backup-way for RT?” - I would have
bet I had everything the right way (moving between same mysql-version-servers)
but I had to learn it the hard way that I was obviously wrong.

Is there any real way besides stopping mysql and copying the binary data files
away and store somewhere safe?

thank you in advance
Harald Kapper, icq# 36178328 http://kapper.net
software-development and loeblichgasse 6
security-consulting 1090 vienna, .at
tel +43 1 3195500-0, fax +43 1 3195502, hk@kapper.net
--------------mark---------------
The following Statement is False.
The previous Statement is True.
- Welcome to my World -


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

Did you run the scripts to update the db schema, etc?

hi
thanks for the pointer, but yes of course I did the upgrades and on the
original-box everything works fine (now after DBD::MySQL is resolved), but as
new tickets have gone into the new database I probably will have a really bad
weekend trying to merge those two, but in fact I care more about the future -
whether there is a correct way to get an RT-database backed up so one can really
restore it or not…

thank you for your support
Harald Kapper, icq# 36178328 http://kapper.net
software-development and loeblichgasse 6
security-consulting 1090 vienna, .at
tel +43 1 3195500-0, fax +43 1 3195502, hk@kapper.net
--------------mark---------------
The following Statement is False.
The previous Statement is True.
- Welcome to my World -