[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On Tue, 2010-11-09 at 13:27 +0000, Gordon Henderson wrote: > MySQL databases don't like being copied "live" (although MySQL is good at > making sure stuff is on disk and 9 times out of 10 it'll "just work", but > you have the "mid-transaction" issues). When I move an existing database > to a new server, I shut-down MySQL, do the move, then start it again (on > both sides). But of a PITA on a live server though, but it's faster than > going through the export/import business. Its pretty much what I would have thought myself. I was thinking that you could in the script do something along the lines of: service mysql stop Do your copying and what not, then do a service start. I am a big fan of scripts and cron jobs where possible so I may be biased when I look for automated solutions ;) -- John http://subbass.blogspot.com/ -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq