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: 743, today: 2, yesterday: 0
Last-modified: 2019-10-14 (Mon) 21:32:34 (JST) (1663d) 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

90 user(s) are online (17 user(s) are browsing xpwiki)

Members: 0
Guests: 90

more...

Access Counter

Today : 9320932093209320
Yesterday : 1753317533175331753317533
Total : 2347246323472463234724632347246323472463234724632347246323472463
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com