[rt-users] mysqldump and reload?

Jaime Kikpole jkikpole at cairodurham.org
Fri Jan 28 07:14:23 EST 2005


	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




More information about the rt-users mailing list