[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On Tue, 9 Nov 2010, John wrote:
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 ;)
Just don't forget that there are other distributions out there. "service" doesn't exist in Debian. At least not the Debians I install... /etc/init.d/mysql stop etc. Gordon -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq