[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