Advertisement
Guest User

Untitled

a guest
Jan 26th, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. ```
  2. 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
  3. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement