活着,寻找生存。
发布时间: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'..........【阅读全文】