Advertisement
Guest User

Untitled

a guest
Feb 19th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. ## Import database
  2.  
  3. `mysql -h localhost --user=root --password=root wordpress < wordpress2.sql`
  4.  
  5.  
  6. ## Extract one database from a mysqldump
  7.  
  8. ```sed -n '/^-- Current Database: `DB_NAME`/,/^-- Current Database: `/p' MYSQL_DUMP_FILE.sql > DB_NAME.sql```
  9.  
  10. ```
  11. extractdb() {
  12. sed -n '/^-- Current Database: `'"$2"'`/,/^-- Current Database: `/p' $1 > $2.sql
  13. }
  14. alias extractdb=extractdb
  15. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement