[SLL] Need MySQL expert

James Moore banshee at banshee.com
Wed Aug 2 17:53:54 PDT 2006


Are you trying to do an in-place update?  Every time I've gone through this
sort of thing it's been done by shutting down, grabbing a snapshot, do a
mysqldump of the snapshot, load it up into the new database, then apply the
post-snapshot logs to the new db.  Assuming you can't be down while you do
the export-import process; life is simpler if you can just tell the outside
world to go away for a small integer's worth of days.  I wouldn't update
from 3 to 4 with binary data.

 - James Moore



More information about the linux-list mailing list