[rt-users] mysqldump and reload?

Todd Chapman rt at chaka.net
Fri Jan 28 09:59:28 EST 2005


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

Check MySQL config file for max_allowed_packet=1M

On 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
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Administrator and Developer training is coming to your town soon! 
> (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com 
> for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com



More information about the rt-users mailing list