Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SHOW BINARY LOGS;
- +---------------+-----------+
- | Log_name | File_size |
- +---------------+-----------+
- | 0 | |
- | 0 | |
- | 0 | |
- | binlog.000027 | 724935 |
- | binlog.000028 | 733481 |
- +---------------+-----------+
- mysql> SHOW BINARY LOGS;
- +---------------+-----------+
- | Log_name | File_size |
- +---------------+-----------+
- | binlog.000027 | 724935 |
- | binlog.000028 | 733481 |
- +---------------+-----------+
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | client_prod |
- +--------------------+
- 2 rows in set (0.01 sec)
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | client_prod |
- +--------------------+
- 3 rows in set (0.00 sec)
- lsof | grep '/path_to_mysql'
- (deleted)
- /etc/init.d/mysql stop
- scp -rp master_server:/var/lib/mysql/mysql /var/lib/mysql/
- /etc/init.d/mysql start
Add Comment
Please, Sign In to add comment