mysql dump 1017_mysqldump: Got error: 1017: Can\'t find file: \'gene-atyu30-ChinaUnix博客

# mysqldump --opt --all-database -p > all.sql

Enter password:

mysqldump: Got error: 1017: Can't find file: 'general_log' (errno: 2) when using LOCK TABLES

# mysql -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 5

Server version: 5.0.45-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

# uname -r

2.6.18-92.el5

处理：

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

+---------------------------+

| Tables_in_mysql           |

+---------------------------+

| columns_priv              |

| db                        |

| event                     |

| func                      |

| general_log               |

| help_category             |

| help_keyword              |

| help_relation             |

| help_topic                |

| host                      |

| ndb_binlog_index          |

| plugin                    |

| proc                      |

| procs_priv                |

| servers                   |

| slow_log                  |

| tables_priv               |

| time_zone                 |

| time_zone_leap_second     |

| time_zone_name            |

| time_zone_transition      |

| time_zone_transition_type |

| user                      |

+---------------------------+

23 rows in set (0.02 sec)

mysql> select * from general_log;

ERROR 1017 (HY000): Can't find file: 'general_log' (errno: 2)

参考：

http://lists.mysql.com/mysql/206585

# mysqldump --opt --add-drop-database --add-drop-table  --add-locks wikidb -p > wikidb.sql

Enter password:

[root@wiki database]# ls -lh

-rw-r--r-- 1 root root 393M Oct  1  2009 wikidb.sql

阅读(5567) | 评论(0) | 转发(0) |

0

下一篇：想想