Advertisement
libdo

box

Sep 13th, 2017
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. $ mysql -u root -h host -p
  2. Enter password:
  3.  
  4. Welcome to the MySQL monitor. Commands end with ; or g.
  5. Your MySQL connection id is X
  6. Server version: 5.1.39-log MySQL Server
  7.  
  8. Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
  9.  
  10. mysql> mysqldump my_database
  11. ->
  12. -> [Ctrl + C]
  13. -> Aborted
  14. $
  15.  
  16. SELECT
  17. `users`.*
  18. FROM
  19. `users`
  20. WHERE
  21. `users`.`is_active` = 1 AND
  22. `users`.`age` < 13
  23. ORDER BY
  24. `users`.`username`
  25.  
  26. mysqldump my_database;
  27.  
  28. $ mysqldump -u root -h host -p ### my_database > dump.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement