Mysqldump and reload?

RT Users
1

Running MySQL 4.1.x and RT 3.2.2, should I be able to do the following?

mysqldump -uroot -p rt3 > backup.sql
(create a new DB called rt3test)
mysql -uroot -p rt3test < backup.sql

When I do this, I receive an error message that a record was too large

for the field that I tried to put it into. When I comment out that
line and then try again, it complains about a different line. I’ve
gone through several dozen records this way. They all seem to be file
attachments, e.g. JPEGs.

						Thanks in advance,
						Jaime
2

You should probably ask MySQL questions on a MySQL mailing list.

Check MySQL config file for max_allowed_packet=1MOn Fri, Jan 28, 2005 at 07:14:23AM -0500, Jaime Kikpole wrote:

Running MySQL 4.1.x and RT 3.2.2, should I be able to do the
following?

mysqldump -uroot -p rt3 > backup.sql
(create a new DB called rt3test)
mysql -uroot -p rt3test < backup.sql

When I do this, I receive an error message that a record was too
large for the field that I tried to put it into. When I comment out that
line and then try again, it complains about a different line. I’ve
gone through several dozen records this way. They all seem to be file
attachments, e.g. JPEGs.

  					Thanks in advance,
  					Jaime

The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

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