Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## Import database
- `mysql -h localhost --user=root --password=root wordpress < wordpress2.sql`
- ## Extract one database from a mysqldump
- ```sed -n '/^-- Current Database: `DB_NAME`/,/^-- Current Database: `/p' MYSQL_DUMP_FILE.sql > DB_NAME.sql```
- ```
- extractdb() {
- sed -n '/^-- Current Database: `'"$2"'`/,/^-- Current Database: `/p' $1 > $2.sql
- }
- alias extractdb=extractdb
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement