flagflag  
Page Top

エンジンチェック anchor.png

> use information_schema;
> select table_name, engine from tables where table_schema = "jogrid_db";
 
Page Top

ISAM 修復 anchor.png

$ mysqlcheck -c -r データベース名 -u root -p
 
Page Top

Innodb 修復 anchor.png

> use jogrid_db;
> ALTER TABLE テーブル名 ENGINE=INNODB;

Front page   Freeze Diff Backup Copy Rename Reload   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)
Counter: 741, today: 2, yesterday: 1
Last-modified: 2019-10-14 (Mon) 21:32:34 (JST) (1661d) by iseki

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMay 2024Next Month
Su Mo Tu We Th Fr Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Today

Who's Online

81 user(s) are online (20 user(s) are browsing xpwiki)

Members: 0
Guests: 81

more...

Access Counter

Today : 1104711047110471104711047
Yesterday : 7722772277227722
Total : 2344252823442528234425282344252823442528234425282344252823442528
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com