mipmip
2/16/2012 - 12:12 PM

copy mysql database in bash

copy mysql database in bash

#!/bin/sh

export APASS=rootpassword
export DB=dbname
export DBDEST=newdbname
mysqldump -uroot $DB -p$APASS | mysql -uroot -p$APASS $DBDEST