如题,没有备份
解决方案 »
- 【求助】怎么用cmd开启 mysqld-nt.exe
- mysql如何计算日期加减天数,再得到日期,急!!!
- 双cpu服务器上mysqld-nt进程cpu占用率始终无法超过25%
- 【新手求助】为啥xp下java连不上mysql呢?
- 怎么查询最后5条记录?
- 做一个百货公司的网站,正考虑使用哪种数据库,请帮帮忙。
- 我安装了MySql ODBC为什么还是连接不上呢?
- php安装问题:怎么配置php.ini是php支持mysql啊?
- 用ADO可以连接MySQL吗?连接串怎么写?
- linux下的mysql插入中文出现乱码
- Mysql 单个表内最多能放多少行数据呢?
- Cannot create PoolableConnectionFactory
二进制日志有没有打开。
普通一般日志有没有的打开?按下面贴出来看一下。如果都没有,则没有办法了。
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>
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)
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)
| log_bin | OFF |
很可惜,你的日志没有打开。
这样的话,没有办法了。