Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MYSQL_USER=root
- MYSQL_PASS=rootpassword
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- SQL="SELECT GROUP_CONCAT(schema_name) FROM information_schema.schemata"
- SQL="${SQL} WHERE schema_name NOT IN ('information_schema','mysql','performance_schema')"
- DB_CSV=`mysql ${MYSQL_CONN} -ANe"${SQL}"`
- DBLIST=`echo "${DB_CSV}" | sed 's/,/ /g'`
- #
- # Schema Only, No Data
- #
- mysqldump ${MYSQL_CONN} -d -B ${DBLIST}|sed 's/ENGINE=MyISAM/ENGINE=NDBCLUSTER' > schema_only.sql
- #
- # Data Only, No Schema
- #
- mysqldump ${MYSQL_CONN} -t -B ${DBLIST} > data_only.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement