Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- DBUSER=user
- DBPASSWORD=pwd
- DBSNAME=sourceDb
- DBNAME=destinationDb
- DBSERVER=localhost
- fCreateTable=""
- fInsertData=""
- echo "Copying database ... (may take a while ...)"
- DBCONN="-h ${DBSERVER} -u ${DBUSER} --password=${DBPASSWORD}"
- echo "DROP DATABASE IF EXISTS ${DBNAME}" | mysql ${DBCONN}
- echo "CREATE DATABASE ${DBNAME}" | mysql ${DBCONN}
- for TABLE in `echo "SHOW TABLES" | mysql $DBCONN $DBSNAME | tail -n +2`; do
- createTable=`echo "SHOW CREATE TABLE ${TABLE}"|mysql -B -r $DBCONN $DBSNAME|tail -n +2|cut -f 2-`
- fCreateTable="${fCreateTable} ; ${createTable}"
- insertData="INSERT INTO ${DBNAME}.${TABLE} SELECT * FROM ${DBSNAME}.${TABLE}"
- fInsertData="${fInsertData} ; ${insertData}"
- done;
- echo "set foreign_key_checks = 0; $fCreateTable ; $fInsertData ; set foreign_key_checks = 1;" | mysql $DBCONN $DBNAME
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement