barry flanagan qstdstmehgcflanaganie 13 nov 2007 1449 hamilton david tsg ci wrote plan would run db external hard drive could shut unmounted unplugged moved machine could mounted place started assume youve said work fine david would need sure mysql version architecture well settings would strongly advise using mysqldump well usb disk case certainly setting mysql replication procedure tar varlibmysql master untar slave dependencies hope helps helped often enough oracle questions back day barry flanagan thanks david original message vincent cunniffe mailtovmxopgocunniffenet sent 13 november 2007 1443 hamilton david tsg ci cc qifwlinuxie subject ilug mysql database question hamilton david tsg ci wrote looking create mysql database moved around system system see create database directory name created data directory correct required run database assuming base config files need able take db external disk reconnect mount point another system able start im coming oracle perspective every db needs initora file yes copymount files directly database directory target system directory contains everything need database however youre guaranteed structural integrity mysql datafiles unless stop database copying similarly good idea copy files directory target mysql either without restarting however use 1liner mysql commandline call dump entire database sql backup textfile similar 1liner cat back target database far side allows move data instance instance without restarting regards vin irish linux users group mailing list list httpmaillinuxiemailmanlistinfoilug httpwwwlinuxie httpwwwlinuxiemap barry flanagan fri 08 aug 2008 013036 0000 ilug mysql database question