不小心把一个表的字段update了，有什么办法可以恢复

Question

如题，没有备份

Answer 1

应该有，不过我第一次用MySQL

Answer 2

有没有上次的备份。
二进制日志有没有打开。
普通一般日志有没有的打开？按下面贴出来看一下。如果都没有，则没有办法了。
mysql> show variables like '%log%';
+---------------------------------+---------------------------------
| Variable_name                   | Value
+---------------------------------+---------------------------------
| back_log                        | 50
| binlog_cache_size               | 32768
| binlog_format                   | STATEMENT
| expire_logs_days                | 0
| general_log                     | ON
| general_log_file                |
| innodb_flush_log_at_trx_commit  | 1
| innodb_locks_unsafe_for_binlog  | OFF
| innodb_log_buffer_size          | 1048576
| innodb_log_file_size            | 25165824
| innodb_log_files_in_group       | 2
| innodb_log_group_home_dir       | .\
| innodb_mirrored_log_groups      | 1
| log                             | ON
| log_bin                         | ON
| log_bin_trust_function_creators | OFF
| log_bin_trust_routine_creators  | OFF
| log_error                       | C:\Program Files\MySQL\MySQL Ser
| log_output                      | FILE
| log_queries_not_using_indexes   | OFF
| log_slave_updates               | OFF
| log_slow_queries                | ON
| log_warnings                    | 1
| max_binlog_cache_size           | 4294963200
| max_binlog_size                 | 1073741824
| max_relay_log_size              | 0
| relay_log                       |
| relay_log_index                 |
| relay_log_info_file             | relay-log.info
| relay_log_purge                 | ON
| relay_log_space_limit           | 0
| slow_query_log                  | ON
| slow_query_log_file             |
| sql_log_bin                     | ON
| sql_log_off                     | OFF
| sql_log_update                  | ON
| sync_binlog                     | 0
+---------------------------------+---------------------------------
37 rows in set (0.01 sec)mysql>

Answer 3

mysql> show variables like'%log%'
    -> ;
+--------------------------------+----------------------+
| Variable_name                  | Value                |
+--------------------------------+----------------------+
| back_log                       | 50                   |
| bdb_log_buffer_size            | 262144               |
| bdb_logdir                     |                      |
| binlog_cache_size              | 32768                |
| innodb_flush_log_at_trx_commit | 1                    |
| innodb_log_arch_dir            | .\                   |
| innodb_log_archive             | OFF                  |
| innodb_log_buffer_size         | 1048576              |
| innodb_log_file_size           | 5242880              |
| innodb_log_files_in_group      | 2                    |
| innodb_log_group_home_dir      | .\                   |
| innodb_mirrored_log_groups     | 1                    |
| log                            | OFF                  |
| log_bin                        | OFF                  |
| log_error                      | .\lyfyj-oaserver.err |
| log_slave_updates              | OFF                  |
| log_slow_queries               | OFF                  |
| log_update                     | OFF                  |
| log_warnings                   | 1                    |
| max_binlog_cache_size          | 4294967295           |
| max_binlog_size                | 1073741824           |
| max_relay_log_size             | 0                    |
+--------------------------------+----------------------+
22 rows in set (0.00 sec)

Answer 4

mysql> show variables like'%log%'
    -> ;
+--------------------------------+----------------------+
| Variable_name                  | Value                |
+--------------------------------+----------------------+
| back_log                       | 50                   |
| bdb_log_buffer_size            | 262144               |
| bdb_logdir                     |                      |
| binlog_cache_size              | 32768                |
| innodb_flush_log_at_trx_commit | 1                    |
| innodb_log_arch_dir            | .\                   |
| innodb_log_archive             | OFF                  |
| innodb_log_buffer_size         | 1048576              |
| innodb_log_file_size           | 5242880              |
| innodb_log_files_in_group      | 2                    |
| innodb_log_group_home_dir      | .\                   |
| innodb_mirrored_log_groups     | 1                    |
| log                            | OFF                  |
| log_bin                        | OFF                  |
| log_error                      | .\lyfyj-oaserver.err |
| log_slave_updates              | OFF                  |
| log_slow_queries               | OFF                  |
| log_update                     | OFF                  |
| log_warnings                   | 1                    |
| max_binlog_cache_size          | 4294967295           |
| max_binlog_size                | 1073741824           |
| max_relay_log_size             | 0                    |
+--------------------------------+----------------------+
22 rows in set (0.00 sec)

Answer 5

| log                            | OFF                  |
| log_bin                        | OFF                  |
很可惜，你的日志没有打开。
这样的话，没有办法了。