GoFuckYourself.com - Adult Webmaster Forum - View Single Post - How do you move MySQL database to different server?

xroach · 02-07-2006, 05:34 PM

(approx)

cd /var/db/mysql/$dbname
tar cf $dbname.tar $dbname
scp $dbname.tar root@$targethost:/$targdir
ssh -l root $targethost
cd /var/db/mysql
tar xzvf <targdir>/<dbname>.tar
chown -R mysql:mysql <dbname>

02-07-2006, 05:34 PM
xroach Confirmed User Join Date: Feb 2002 Location: vancouver, bc Posts: 963	(approx) cd /var/db/mysql/$dbname tar cf $dbname.tar $dbname scp $dbname.tar root@$targethost:/$targdir ssh -l root $targethost cd /var/db/mysql tar xzvf <targdir>/<dbname>.tar chown -R mysql:mysql <dbname>