Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ mysql -u root -h host -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or g.
- Your MySQL connection id is X
- Server version: 5.1.39-log MySQL Server
- Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
- mysql> mysqldump my_database
- ->
- -> [Ctrl + C]
- -> Aborted
- $
- SELECT
- `users`.*
- FROM
- `users`
- WHERE
- `users`.`is_active` = 1 AND
- `users`.`age` < 13
- ORDER BY
- `users`.`username`
- mysqldump my_database;
- $ mysqldump -u root -h host -p ### my_database > dump.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement