发布时间：2016-06-27 14:35:52

今天在学习mysql 备份的时候，使用mysqldump 工具备份数据库的时候出现如下错误：mysqldump: Error 1194: Table 'id_csv1' is marked as crashed and should be repaired when dumping table `id_csv1` at row: 0这个表说明下：应该当时测试外部csv数据导入csv存储引擎表中，笔者直接将csv数据写入到data目录下，可能导.........【阅读全文】

发布时间：2016-05-19 17:40:23

MYSQL修改redo log size检查innodb_fast_shutdown系统参数：root@localhost 16:41:13 (none)> show global variables like 'innodb_fast_shutdown';+----------------------+-------+| Variable_name        | Value |+----------------------+-------+| innodb_fast_shutdown | 1    .........【阅读全文】

发布时间：2016-03-08 17:53:31

在启动mysql出现如下错误：2016-03-08 17:22:01 21968 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 65536 pages, max 0 (relevant if non-zero) pages!2016-03-08 17:22:01 21968 [ERROR] InnoDB: Could not .........【阅读全文】

发布时间：2016-03-08 17:48:36

在启动mysql出现如下警告：2016-03-08 17:22:01 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).解决办法： 在my.cnf文件中添加如下参数，关闭警告： [mysqld] explicit_defa.........【阅读全文】

发布时间：2016-03-04 11:23:40

在通过mysqld_multi 关闭mysql的时候出现如下警告：root># mysqld_multi stop 3306WARNING: my_print_defaults command not found.Please make sure you have this command available andin your path. The command is available from the latestMySQL distribution.ABORT: Can't find command 'my_print_defaults'..........【阅读全文】