Guest User

Untitled

a guest
Feb 25th, 2018
266
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. mysql> SHOW BINARY LOGS;
  2. +---------------+-----------+
  3. | Log_name | File_size |
  4. +---------------+-----------+
  5. | 0 | |
  6. | 0 | |
  7. | 0 | |
  8. | binlog.000027 | 724935 |
  9. | binlog.000028 | 733481 |
  10. +---------------+-----------+
  11.  
  12. mysql> SHOW BINARY LOGS;
  13. +---------------+-----------+
  14. | Log_name | File_size |
  15. +---------------+-----------+
  16. | binlog.000027 | 724935 |
  17. | binlog.000028 | 733481 |
  18. +---------------+-----------+
  19.  
  20. mysql> show databases;
  21. +--------------------+
  22. | Database |
  23. +--------------------+
  24. | information_schema |
  25. | client_prod |
  26. +--------------------+
  27. 2 rows in set (0.01 sec)
  28.  
  29. mysql> show databases;
  30. +--------------------+
  31. | Database |
  32. +--------------------+
  33. | information_schema |
  34. | mysql |
  35. | client_prod |
  36. +--------------------+
  37. 3 rows in set (0.00 sec)
  38.  
  39. lsof | grep '/path_to_mysql'
  40.  
  41. (deleted)
  42.  
  43. /etc/init.d/mysql stop
  44. scp -rp master_server:/var/lib/mysql/mysql /var/lib/mysql/
  45. /etc/init.d/mysql start
Add Comment
Please, Sign In to add comment