Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```
- MYSQLUSER='root' MYSQLPASSWORD='' MYSQLHOST='127.0.0.1' MYSQLPORT=3306; mysqldump -u$MYSQLUSER -p$MYSQLPASSWORD -h$MYSQLHOST -P$MYSQLPORT --databases `mysql --skip-column-names -u$MYSQLUSER -p$MYSQLPASSWORD -h$MYSQLHOST -P$MYSQLPORT -e "SELECT GROUP_CONCAT(schema_name SEPARATOR ' ') FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','performance_schema','information_schema');"` > dump.sql
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement