flagflag  
1: 2015-01-29 (Thu) 09:31:41 iseki source
Line 1: Line 1:
 +** Maintenance of MySQL [#p08aee0a] 
 +*** エンジンチェック [#ccfee546] 
 + > use information_schema; 
 + > select table_name, engine from tables where table_schema = "jogrid_db"; 
 +#br 
 +*** ISAM 修復 [#d6210ca8] 
 + $ mysqlcheck -c -r -u root -p 
 +#br 
 +*** Innodb 修復 [#o6e69f5d] 
 + > use jogrid_db; 
 + > ALTER TABLE テーブル名 ENGINE=INNODB;


Front page   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)

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

35 user(s) are online (7 user(s) are browsing xpwiki)

Members: 0
Guests: 35

more...

Access Counter

Today : 3812381238123812
Yesterday : 5790579057905790
Total : 2365660823656608236566082365660823656608236566082365660823656608
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com