RT 3.6.4 MYSQL Backup

Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore this DB on top of a new installation ? will I just not be able to browse the attachments or will this make it so we are unable to browse the old tickets?

I say this because the new RT will be running on a different machine as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy

100’s of Nikon cameras to be won with Live Search
http://clk.atdmt.com/UKM/go/101719808/direct/01/

Hi fay,
I’m not sure about the error, but if you can’t restore the attachments table correctly, then your rt install will be broken, rt stores not only the things we know as attachment like .doc or .xls, he also stores each mail text etc there. A broken table is not good in this way :wink:

Can you try as workaround to stop your mysqld copy over the plain files (innodb etc) to the new server an try to start there.

TobVon: rt-users-bounces@lists.bestpractical.com
An: rt mailing list
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup

Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore this DB on top of a new installation ? will I just not be able to browse the attachments or will this make it so we are unable to browse the old tickets?

I say this because the new RT will be running on a different machine as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy

Get Hotmail on your Mobile! Try it Now! http://clk.atdmt.com/UKM/go/101719965/direct/01/

I was thinking that it might be the max_allowed_packet option my.cnf.
Recent versions of MySQL seem to export the tables in what my office has
begun to refer to as “massive dumps,” that is, One insert statement for
each table.

One other option would be not exporting the data in binary format, IIRC.

Ham MI-ID, Torsten Brumm wrote:

Hi fay,
I’m not sure about the error, but if you can’t restore the attachments
table correctly, then your rt install will be broken, rt stores not
only the things we know as attachment like .doc or .xls, he also
stores each mail text etc there. A broken table is not good in this
way :wink:

Can you try as workaround to stop your mysqld copy over the plain
files (innodb etc) to the new server an try to start there.

Tob


Von: rt-users-bounces@lists.bestpractical.com
An: rt mailing list
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup
Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another
machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments
VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t
want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore
this DB on top of a new installation ? will I just not be able to
browse the attachments or will this make it so we are unable to browse
the old tickets?

I say this because the new RT will be running on a different machine
as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy


Get Hotmail on your Mobile! Try it Now!
http://clk.atdmt.com/UKM/go/101719965/direct/01/


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Yes, like drew said, this can also be the problem, i remeber from our last move.
We increased the max_allowed_packet option massivly, but also without success. We did the trick by dumping only the attachments table and restored them later. Was working fine.

----- Originalnachricht -----Von: Drew Barnes barnesaw@ucrwcu.rwc.uc.edu
An: Ham MI-ID, Torsten Brumm
Cc: andrew.fay@hotmail.co.uk andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:35:44 2008
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup

I was thinking that it might be the max_allowed_packet option my.cnf.
Recent versions of MySQL seem to export the tables in what my office has
begun to refer to as “massive dumps,” that is, One insert statement for
each table.

One other option would be not exporting the data in binary format, IIRC.

Ham MI-ID, Torsten Brumm wrote:

Hi fay,
I’m not sure about the error, but if you can’t restore the attachments
table correctly, then your rt install will be broken, rt stores not
only the things we know as attachment like .doc or .xls, he also
stores each mail text etc there. A broken table is not good in this
way :wink:

Can you try as workaround to stop your mysqld copy over the plain
files (innodb etc) to the new server an try to start there.

Tob


Von: rt-users-bounces@lists.bestpractical.com
An: rt mailing list
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup
Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another
machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments
VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t
want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore
this DB on top of a new installation ? will I just not be able to
browse the attachments or will this make it so we are unable to browse
the old tickets?

I say this because the new RT will be running on a different machine
as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy


Get Hotmail on your Mobile! Try it Now!
http://clk.atdmt.com/UKM/go/101719965/direct/01/


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Under xampp the is also a my.ini i think.Von: andrew fay
An: Ham MI-ID, Torsten Brumm; barnesaw@ucrwcu.rwc.uc.edu ; robert@ml.erje.net
Cc: rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:46:44 2008
Betreff: RE: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup

Hi,

Sorry I should of been more clear,

I have RT 3.6.4 running on an ubuntu machine and backing up the catalog using the Mysql Administrator. When I am restoring it I am restoring on to a windows xp pro machine running a mysql server. I have tried restoring attachments after and before just by itself with no luck.

How would I set the max_allowed_packet option under windows? I have access to the console and am using WAMP to run my mysql server.

Thanks!

Andy

Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
Date: Wed, 30 Jul 2008 16:39:02 +0200
From: torsten.brumm@Kuehne-Nagel.com
To: barnesaw@ucrwcu.rwc.uc.edu
CC: andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com

Yes, like drew said, this can also be the problem, i remeber from our last move.
We increased the max_allowed_packet option massivly, but also without success. We did the trick by dumping only the attachments table and restored them later. Was working fine.

----- Originalnachricht -----
Von: Drew Barnes barnesaw@ucrwcu.rwc.uc.edu
An: Ham MI-ID, Torsten Brumm
Cc: andrew.fay@hotmail.co.uk andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:35:44 2008
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup

I was thinking that it might be the max_allowed_packet option my.cnf.
Recent versions of MySQL seem to export the tables in what my office has
begun to refer to as “massive dumps,” that is, One insert statement for
each table.

One other option would be not exporting the data in binary format, IIRC.

Ham MI-ID, Torsten Brumm wrote:

Hi fay,
I’m not sure about the error, but if you can’t restore the attachments
table correctly, then your rt install will be broken, rt stores not
only the things we know as attachment like .doc or .xls, he also
stores each mail text etc there. A broken table is not good in this
way :wink:

Can you try as workaround to stop your mysqld copy over the plain
files (innodb etc) to the new server an try to start there.

Tob


Von: rt-users-bounces@lists.bestpractical.com
An: rt mailing list
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup
Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another
machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments
VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t
want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore
this DB on top of a new installation ? will I just not be able to
browse the attachments or will this make it so we are unable to browse
the old tickets?

I say this because the new RT will be running on a different machine
as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy


Get Hotmail on your Mobile! Try it Now!
http://clk.atdmt.com/UKM/go/101719965/direct/01/


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Find out how to make Messenger your very own TV! Try it Now! http://clk.atdmt.com/UKM/go/101719648/direct/01/

I have never used Mysql under windows, but from MySQL’s documentation:
When the MySQL server starts on Windows, it looks for options in two
files: the my.ini file in the Windows directory, and the C:\my.cnf file.

andrew fay wrote:

Hi,

Sorry I should of been more clear,

I have RT 3.6.4 running on an ubuntu machine and backing up the
catalog using the Mysql Administrator. When I am restoring it I am
restoring on to a windows xp pro machine running a mysql server. I
have tried restoring attachments after and before just by itself with
no luck.

How would I set the max_allowed_packet option under windows? I have
access to the console and am using WAMP to run my mysql server.

Thanks!

Andy


Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
Date: Wed, 30 Jul 2008 16:39:02 +0200
From: torsten.brumm@Kuehne-Nagel.com
To: barnesaw@ucrwcu.rwc.uc.edu
CC: andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com

Yes, like drew said, this can also be the problem, i remeber from our
last move.
We increased the max_allowed_packet option massivly, but also without
success. We did the trick by dumping only the attachments table and
restored them later. Was working fine.

----- Originalnachricht -----
Von: Drew Barnes barnesaw@ucrwcu.rwc.uc.edu
An: Ham MI-ID, Torsten Brumm
Cc: andrew.fay@hotmail.co.uk andrew.fay@hotmail.co.uk;
rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:35:44 2008
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup

I was thinking that it might be the max_allowed_packet option my.cnf.
Recent versions of MySQL seem to export the tables in what my office has
begun to refer to as “massive dumps,” that is, One insert statement for
each table.

One other option would be not exporting the data in binary format, IIRC.

Ham MI-ID, Torsten Brumm wrote:

Hi fay,
I’m not sure about the error, but if you can’t restore the attachments
table correctly, then your rt install will be broken, rt stores not
only the things we know as attachment like .doc or .xls, he also
stores each mail text etc there. A broken table is not good in this
way :wink:

Can you try as workaround to stop your mysqld copy over the plain
files (innodb etc) to the new server an try to start there.

Tob


Von: rt-users-bounces@lists.bestpractical.com
An: rt mailing list
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup
Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another
machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores
fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments
VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t
want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore
this DB on top of a new installation ? will I just not be able to
browse the attachments or will this make it so we are unable to browse
the old tickets?

I say this because the new RT will be running on a different machine
as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy


Get Hotmail on your Mobile! Try it Now!
http://clk.atdmt.com/UKM/go/101719965/direct/01/


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati


Find out how to make Messenger your very own TV! Try it Now!
http://clk.atdmt.com/UKM/go/101719648/direct/01/

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Hi,

Sorry I should of been more clear,

I have RT 3.6.4 running on an ubuntu machine and backing up the catalog using the Mysql Administrator. When I am restoring it I am restoring on to a windows xp pro machine running a mysql server. I have tried restoring attachments after and before just by itself with no luck.

How would I set the max_allowed_packet option under windows? I have access to the console and am using WAMP to run my mysql server.

Thanks!

AndySubject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
Date: Wed, 30 Jul 2008 16:39:02 +0200
From: torsten.brumm@Kuehne-Nagel.com
To: barnesaw@ucrwcu.rwc.uc.edu
CC: andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com

AW: Re: [rt-users] RT 3.6.4 MYSQL Backup

Yes, like drew said, this can also be the problem, i remeber from our last move.

We increased the max_allowed_packet option massivly, but also without success. We did the trick by dumping only the attachments table and restored them later. Was working fine.

----- Originalnachricht -----

Von: Drew Barnes barnesaw@ucrwcu.rwc.uc.edu

An: Ham MI-ID, Torsten Brumm

Cc: andrew.fay@hotmail.co.uk andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com

Gesendet: Wed Jul 30 16:35:44 2008

Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup

I was thinking that it might be the max_allowed_packet option my.cnf.

Recent versions of MySQL seem to export the tables in what my office has

begun to refer to as “massive dumps,” that is, One insert statement for

each table.

One other option would be not exporting the data in binary format, IIRC.

Ham MI-ID, Torsten Brumm wrote:

Hi fay,

I’m not sure about the error, but if you can’t restore the attachments

table correctly, then your rt install will be broken, rt stores not

only the things we know as attachment like .doc or .xls, he also

stores each mail text etc there. A broken table is not good in this

way :wink:

Can you try as workaround to stop your mysqld copy over the plain

files (innodb etc) to the new server an try to start there.

Tob


Von: rt-users-bounces@lists.bestpractical.com

An: rt mailing list

Gesendet: Wed Jul 30 16:11:20 2008

Betreff: [rt-users] RT 3.6.4 MYSQL Backup

Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another

machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments

VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t

want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore

this DB on top of a new installation ? will I just not be able to

browse the attachments or will this make it so we are unable to browse

the old tickets?

I say this because the new RT will be running on a different machine

as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy


Get Hotmail on your Mobile! Try it Now!

http://clk.atdmt.com/UKM/go/101719965/direct/01/



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

Community help: http://wiki.bestpractical.com

Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.

Buy a copy at http://rtbook.bestpractical.com

Drew Barnes

Applications Analyst

Network Resources Department

Raymond Walters College

University of Cincinnati

Find the best and worst places on the planet
http://clk.atdmt.com/UKM/go/101719807/direct/01/

added max_allowed_packet = 16M

to my.ini

The restore operation finished successfully!

Thanks guys,

Andy

Date: Wed, 30 Jul 2008 10:50:16 -0400
From: barnesaw@ucrwcu.rwc.uc.edu
To: andrew.fay@hotmail.co.uk
CC: torsten.brumm@kuehne-nagel.com; robert@ml.erje.net; rt-users@lists.bestpractical.com
Subject: Re: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup

I have never used Mysql under windows, but from MySQL’s documentation:
When the MySQL server starts on Windows, it looks for options in two
files: the my.ini file in the Windows directory, and the C:\my.cnf file.

andrew fay wrote:

Hi,

Sorry I should of been more clear,

I have RT 3.6.4 running on an ubuntu machine and backing up the
catalog using the Mysql Administrator. When I am restoring it I am
restoring on to a windows xp pro machine running a mysql server. I
have tried restoring attachments after and before just by itself with
no luck.

How would I set the max_allowed_packet option under windows? I have
access to the console and am using WAMP to run my mysql server.

Thanks!

Andy


Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
Date: Wed, 30 Jul 2008 16:39:02 +0200
From: torsten.brumm@Kuehne-Nagel.com
To: barnesaw@ucrwcu.rwc.uc.edu
CC: andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com

Yes, like drew said, this can also be the problem, i remeber from our
last move.
We increased the max_allowed_packet option massivly, but also without
success. We did the trick by dumping only the attachments table and
restored them later. Was working fine.

----- Originalnachricht -----
Von: Drew Barnes barnesaw@ucrwcu.rwc.uc.edu
An: Ham MI-ID, Torsten Brumm
Cc: andrew.fay@hotmail.co.uk andrew.fay@hotmail.co.uk;
rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:35:44 2008
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup

I was thinking that it might be the max_allowed_packet option my.cnf.
Recent versions of MySQL seem to export the tables in what my office has
begun to refer to as “massive dumps,” that is, One insert statement for
each table.

One other option would be not exporting the data in binary format, IIRC.

Ham MI-ID, Torsten Brumm wrote:

Hi fay,
I’m not sure about the error, but if you can’t restore the attachments
table correctly, then your rt install will be broken, rt stores not
only the things we know as attachment like .doc or .xls, he also
stores each mail text etc there. A broken table is not good in this
way :wink:

Can you try as workaround to stop your mysqld copy over the plain
files (innodb etc) to the new server an try to start there.

Tob


Von: rt-users-bounces@lists.bestpractical.com
An: rt mailing list
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup
Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another
machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores
fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments
VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t
want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore
this DB on top of a new installation ? will I just not be able to
browse the attachments or will this make it so we are unable to browse
the old tickets?

I say this because the new RT will be running on a different machine
as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy


Get Hotmail on your Mobile! Try it Now!
http://clk.atdmt.com/UKM/go/101719965/direct/01/


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati


Find out how to make Messenger your very own TV! Try it Now!
http://clk.atdmt.com/UKM/go/101719648/direct/01/


Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Play and win great prizes with Live Search and Kung Fu Panda
http://clk.atdmt.com/UKM/go/101719966/direct/01/

Is it really a prod system? Do you think its a good idea to use it under xampp or mamp? And windows? ;-)Von: rt-users-bounces@lists.bestpractical.com
An: andrew.fay@hotmail.co.uk ; barnesaw@ucrwcu.rwc.uc.edu ; robert@ml.erje.net
Cc: rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:48:01 2008
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup

Under xampp the is also a my.ini i think.

Von: andrew fay
An: Ham MI-ID, Torsten Brumm; barnesaw@ucrwcu.rwc.uc.edu ; robert@ml.erje.net
Cc: rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:46:44 2008
Betreff: RE: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup

Hi,

Sorry I should of been more clear,

I have RT 3.6.4 running on an ubuntu machine and backing up the catalog using the Mysql Administrator. When I am restoring it I am restoring on to a windows xp pro machine running a mysql server. I have tried restoring attachments after and before just by itself with no luck.

How would I set the max_allowed_packet option under windows? I have access to the console and am using WAMP to run my mysql server.

Thanks!

Andy

Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
Date: Wed, 30 Jul 2008 16:39:02 +0200
From: torsten.brumm@Kuehne-Nagel.com
To: barnesaw@ucrwcu.rwc.uc.edu
CC: andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com

Yes, like drew said, this can also be the problem, i remeber from our last move.
We increased the max_allowed_packet option massivly, but also without success. We did the trick by dumping only the attachments table and restored them later. Was working fine.

----- Originalnachricht -----
Von: Drew Barnes barnesaw@ucrwcu.rwc.uc.edu
An: Ham MI-ID, Torsten Brumm
Cc: andrew.fay@hotmail.co.uk andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:35:44 2008
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup

I was thinking that it might be the max_allowed_packet option my.cnf.
Recent versions of MySQL seem to export the tables in what my office has
begun to refer to as “massive dumps,” that is, One insert statement for
each table.

One other option would be not exporting the data in binary format, IIRC.

Ham MI-ID, Torsten Brumm wrote:

Hi fay,
I’m not sure about the error, but if you can’t restore the attachments
table correctly, then your rt install will be broken, rt stores not
only the things we know as attachment like .doc or .xls, he also
stores each mail text etc there. A broken table is not good in this
way :wink:

Can you try as workaround to stop your mysqld copy over the plain
files (innodb etc) to the new server an try to start there.

Tob


Von: rt-users-bounces@lists.bestpractical.com
An: rt mailing list
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup
Hi,

I am having a problem backing up the mysql db for our RT installation,

I can back it up correctly into an SQL file… move it to another
machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it restores fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments
VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I don’t
want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I restore
this DB on top of a new installation ? will I just not be able to
browse the attachments or will this make it so we are unable to browse
the old tickets?

I say this because the new RT will be running on a different machine
as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy


Get Hotmail on your Mobile! Try it Now!
http://clk.atdmt.com/UKM/go/101719965/direct/01/


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Find out how to make Messenger your very own TV! Try it Now! http://clk.atdmt.com/UKM/go/101719648/direct/01/

Btw, you can also use --skip-extended-insert in mysqldump to insert
statement always insert a single row at a time.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of andrew
fay
Sent: July 30, 2008 11:02
To: Drew Barnes
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT 3.6.4 MYSQL BackupRESOLVED

added max_allowed_packet = 16M

to my.ini

The restore operation finished successfully!

Thanks guys,

Andy

Date: Wed, 30 Jul 2008 10:50:16 -0400
From: barnesaw@ucrwcu.rwc.uc.edu
To: andrew.fay@hotmail.co.uk
CC: torsten.brumm@kuehne-nagel.com; robert@ml.erje.net;
rt-users@lists.bestpractical.com
Subject: Re: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup

I have never used Mysql under windows, but from MySQL’s documentation:
When the MySQL server starts on Windows, it looks for options in two
files: the my.ini file in the Windows directory, and the C:\my.cnf
file.

andrew fay wrote:

Hi,

Sorry I should of been more clear,

I have RT 3.6.4 running on an ubuntu machine and backing up the
catalog using the Mysql Administrator. When I am restoring it I am
restoring on to a windows xp pro machine running a mysql server. I
have tried restoring attachments after and before just by itself
with

no luck.

How would I set the max_allowed_packet option under windows? I have
access to the console and am using WAMP to run my mysql server.

Thanks!

Andy

Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
Date: Wed, 30 Jul 2008 16:39:02 +0200
From: torsten.brumm@Kuehne-Nagel.com
To: barnesaw@ucrwcu.rwc.uc.edu
CC: andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com

Yes, like drew said, this can also be the problem, i remeber from
our

last move.
We increased the max_allowed_packet option massivly, but also
without

success. We did the trick by dumping only the attachments table and
restored them later. Was working fine.

----- Originalnachricht -----
Von: Drew Barnes barnesaw@ucrwcu.rwc.uc.edu
An: Ham MI-ID, Torsten Brumm
Cc: andrew.fay@hotmail.co.uk andrew.fay@hotmail.co.uk;
rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
Gesendet: Wed Jul 30 16:35:44 2008
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup

I was thinking that it might be the max_allowed_packet option
my.cnf.

Recent versions of MySQL seem to export the tables in what my office
has

begun to refer to as “massive dumps,” that is, One insert statement
for

each table.

One other option would be not exporting the data in binary format,
IIRC.

Ham MI-ID, Torsten Brumm wrote:

Hi fay,
I’m not sure about the error, but if you can’t restore the
attachments

table correctly, then your rt install will be broken, rt stores
not

only the things we know as attachment like .doc or .xls, he also
stores each mail text etc there. A broken table is not good in
this

way :wink:

Can you try as workaround to stop your mysqld copy over the plain
files (innodb etc) to the new server an try to start there.

Tob

Von: rt-users-bounces@lists.bestpractical.com
An: rt mailing list
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup
Hi,

I am having a problem backing up the mysql db for our RT
installation,

I can back it up correctly into an SQL file… move it to another
machine with mysql running and get errors trying to restore it.

If I remove the attachments table from the restore then it
restores

fine,

the error i get is :

Error while executing this query:INSERT INTO rtdb.Attachments
VALUES (179,455,178,’’,’’,NULL,‘text/plain’,‘none’

etc and then a mess of illedgable text.

I am looking into upgrading to the latest version of RT but I
don’t

want to do this until I can back everything up correctly.

Ideally I would like the attachments backed up though.

If the attachment table can’t be saved what will happen if I
restore

this DB on top of a new installation ? will I just not be able to
browse the attachments or will this make it so we are unable to
browse

the old tickets?

I say this because the new RT will be running on a different
machine

as this one is coming to the end of it’s life unfortunatly.

Thanks in advance!

Andy

Get Hotmail on your Mobile! Try it Now!
http://clk.atdmt.com/UKM/go/101719965/direct/01/


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

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.

Buy a copy at http://rtbook.bestpractical.com


Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Find out how to make Messenger your very own TV! Try it Now!
http://clk.atdmt.com/UKM/go/101719648/direct/01/


Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

Get Messenger on your Mobile! Get it now!
http://clk.atdmt.com/UKM/go/101719964/direct/01/