Skip to content

Instantly share code, notes, and snippets.

@mipmip

mipmip/copydbmysql.sh

Created February 16, 2012 12:12
Show Gist options
  • Save mipmip/1844414 to your computer and use it in GitHub Desktop.
Save mipmip/1844414 to your computer and use it in GitHub Desktop.
Download ZIP
copy mysql database in bash
Raw
copydbmysql.sh
#!/bin/sh
export APASS=rootpassword
export DB=dbname
export DBDEST=newdbname
mysqldump -uroot $DB -p$APASS | mysql -uroot -p$APASS $DBDEST
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment